What is Power Pivot?
Power Pivot, commonly referred to as the Data Model is an Excel add-in that helps you to create normal Pivot reports that draw data from a variety of sources. It allows you to extend Excel capabilities in two ways: (1) [...]
Need a new search?
If you didn't find what you were looking for, try a new search!
What is Power Query?
Power Query enhances and simplifies tasks that revolve data access, cleaning, segmenting, grouping and merging. It is a free add-in available in MS Excel 2010 and above. In Excel 2010 and 2013 you download and install for free. With Excel [...]
online
Accelerate your reports. Learn anytime, anywhere Build a solid understanding of MS Excel and MS Power BI and start taking back your valuable time! Online Courses [...]
Excel Training
Broaden Your Excel Skill Set. Speed Up Your Reports. Build your confidence to write robust & dynamic formulas that reduce your turn-around time while creating better, reliable and dynamic management reports in Excel [...]
pivot tables max
Speak Visually. Create an infographic with Visme
Creating Interactive Charts in Excel Using Dropdown Lists
Creating Interactive Charts in Excel Using Dropdown Lists Charts are very central when it comes to communicating information. Whether you’re doing it in MS Excel, Power BI or Tableau, the principles are [...]
Files download page
This page will be populated with files used for the various blogs: BLOG: Creating Interactive Charts in Excel Using Dropdown Lists Interactive-Charts-with-Drop-Downs-in-Excel.xlsx Calculate quarters from a date column Using the CHOOSE function for quarters
Using Excel Power Query to Unpivot Data [Extremely Easy That It Will Shock You]
Most times when data is organized in Excel, it is done in a report format (cross tabulation) since it is easy to understand. Working with this format for further analysis can be an uphill task. It is therefore paramount for [...]
Boardroom Ready Chart Book Download
Congratulations and welcome aboard! A copy of the Boardroom-Ready Excel Chart book has been emailed to you You are now on your way to becoming splendid in creating PowerPoint and Excel Charts & Dashboards and taking your [...]
Excel Master Class [Distilled to Cover the Must-Know Concepts]
Hands-on Advanced Excel Master Class [Master Data Analysis in Excel] Learn how to use Excel the right way. Boost your productivity Enroll Online Now In today's [...]