Search Results

Ready to supercharge your Excel skills? This course will help you master the new set of functions introduced to Excel for Office 365. You’ll create professional-grade reports in a fraction of the time it used to take you.

Create eye-catching Excel Dashboards with actionable tips you can use right away.

Whether you’re a newbie or have an MBA in Finance, you’ll FINALLY “get” the big picture.
This comprehensive course will equip you with these critical skills – even if you’ve never taken a finance or accounting class.

Power Query is essential for Excel users who work with lots of data. This course teaches you how to use Excel in Power Mode and create meaningful reports with far less effort.

Stay ahead of the game in 2023.
Get access to our best-selling Power BI course now and become a highly sought-after Power BI professional.
This course gets you started in Power BI – Fast!

Learn time-saving hacks to work smarter in Excel. Our members also consistently report a newfound enthusiasm for using Excel after taking our course.

Excel comes with default settings and options. You can change these to support your workflow and be more productive. This post covers my list of options to review.

This is a real-life example of Excel’s VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

In Power BI or Power Pivot, you often need to create reports that go from the many side of the relationship to the one side. How can you do that without expanding your data model by adding more columns to your table? There is an easy trick you can use to solve this with a single DAX formula. Of course, the formula uses the CALCULATE function.

Don’t merge cells in Excel – Don’t Copy Excel sheets without updating links – Don’t hide rows and columns! There are better ways of doing these things. Find out 7 things you’re doing wrong in Excel and how to do it correctly.

Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you’ll have setup your interactive dashboard which you’ve published to the web!

If you’d like to “see” how the DAX CALCULATE function works, then you need this tutorial. It will show you how the CALCULATE function works and delivers results.