60 results for: pivot table
Google Sheets course cover

Google Sheets – The Comprehensive Masterclass

Master the Powerful Features of Google Sheets from data collection, automation to proper data analysis and visualization. This course will teach you everything you need to know about Google Sheets. Plus you’ll benefit from our EXCLUSIVE bonuses.

Excel VBA and macros course cover

Unlock Excel VBA & Excel Macros

Automate ANYTHING you need done in Excel with VBA and macros. Go from Beginner to VBA Expert and design automations with confidence.

Excel New functions course cover

Master NEW Excel Functions in Office 365 & Office 2021

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.

Excel dashboards course cover

Visually Effective Excel Dashboards

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

Learn Financial Analysis Course cover

Fundamentals of Financial Analysis

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 Course

Master Excel Power Query – Beginner to Pro

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.

Power BI course image

Fast Track to Power BI

Stay ahead of the game in 2024.
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!

Excel Essentials for the Real World

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

4 Excel Settings to Review to be More Productive

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.

How to Do Many-to-One Side Calculations in Data Models with DAX

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.

7 Things You’re Doing Wrong (or perhaps not the best way) in Excel

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.

How to Use Power BI – Beginner’s Guide

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!

Free Guide!

The ONE Critical Excel Skill You Need

This free Excel guide will help you to:

  • Pinpoint the Excel skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill