Chandoo.org – Learn Excel, Power BI & Charting Online Fresh Excel Tips, Power BI, Power Pivot, Power Query, Tricks, Charts, Tutorials, Downloads, Dashboards and Visualization Showcase for your Inspiration and Productivity
- 3 Weeks Roadmap to Learn Power BI (with free resources)by Chandoo on October 22, 2026 at 6:07 am
- Mutual Fund Portfolio Tracker using MS Excelby Chandoo on August 22, 2026 at 7:01 pm
- Mandatory Trainings: Are we doing them? [Data Analysis Challenge – 002]by Chandoo on May 1, 2026 at 6:46 pm
- FREE Calendar & Planner Excel Template for 2026by Chandoo on December 15, 2025 at 11:03 pm
- Who is my boss’s boss? [Data Analytics Challenge – 001]by Chandoo on August 8, 2025 at 6:13 am
- New Zealand GST Calculation with Excel [Free Template]by Chandoo on July 2, 2025 at 12:28 am
- Make a Pivot from Another Pivot Table in Excelby Chandoo on June 25, 2025 at 12:59 am
Contextures Blog Excel tips and tutorials
- Fix This Old Spreadsheet? Employee Hoursby Debra Dalgleish on November 5, 2026 at 8:01 am
What would you do with a dusty old Excel file, that’s still useful, but outdated? For some files, a quick fix is all you need. For other files, the best fix is to start over, in a brand new workbook! This Old Spreadsheet This week’s old Excel file – Employee Hours – is the first … Continue reading “Fix This Old Spreadsheet? Employee Hours”
- Get This Custom Tab for Excel Macros – Demoby Debra Dalgleish on October 29, 2026 at 7:01 am
Quickly add your favourite macros to a custom tab on the Excel Ribbon. Then, use those macros in other Excel files, with just a couple of clicks. Video: Custom Tab for Excel Macros – Demo In the short video below, I show how the Excel Ribbon custom tab works, and the worksheet where you can … Continue reading “Get This Custom Tab for Excel Macros – Demo”
- Quick Excel Lists with RANDARRAY Function – Examplesby Debra Dalgleish on October 8, 2026 at 7:02 am
Use the Excel RANDARRAY function to make quick lists of random numbers or random text in Excel. It’s similar to the old RANDBETWEEN function, but gives you better control over the results. Video: RANDARRAY Function Example The Excel RANDARRAY function is available in Excel 365, and other versions that support Spill functions. In this short … Continue reading “Quick Excel Lists with RANDARRAY Function – Examples”
- Excel Golf Score Tracker by Player and Courseby Debra Dalgleish on August 27, 2026 at 6:02 am
I made this Excel Golf Score Tracker for anyone who loves Excel, and golf! Set it up at the start of golf season, then record your results after every round of golf. Video: Golf Score Tracker Demo In the video below, I show two versions of the Excel Golf Score Tracker. There’s a workbook is … Continue reading “Excel Golf Score Tracker by Player and Course”
- Build a Daily Events Calendar in Excelby Debra Dalgleish on December 16, 2025 at 7:02 am
Use my Excel events calendar to track meetings and events inside a workbook. Add your upcoming events to a list, set a start date, and then see those items in a 6-week calendar view. Video: Daily Events Calendar in Excel In this short video, I show how to use the daily events Excel calendar, and … Continue reading “Build a Daily Events Calendar in Excel”
![Mandatory Trainings: Are we doing them? [Data Analysis Challenge – 002]](https://chandoo.org/wp/wp-content/uploads/2026/05/screenshot-0355.png)

![Who is my boss’s boss? [Data Analytics Challenge – 001]](https://chandoo.org/wp/wp-content/uploads/2025/08/image.png)
![New Zealand GST Calculation with Excel [Free Template]](https://chandoo.org/wp/wp-content/uploads/2025/07/nz-gst-calculation-excel-formula.png)
