Search Results

Discover 10 pro hacks that will make creating pivot tables easier. Learn how to customize layouts, create dynamic reports, conduct in-depth analysis.

Learn 10 of the most productivity increasing “hidden” features of Power Query to take your skills to the next level.

Learn to locate duplicate values in a list, between multiple lists, as well as duplicate rows in a table. Generate a report that lists all duplicates.

Learn to use Excel’s FILTER function with multiple criteria (AND/OR) and how to return only the columns you need with the help of CHOOSECOLS.

Learn to properly use Excel’s TAKE function. With TAKE you’ll be able to extract a specified number of rows or columns from the start or end of your dataset. This opens many opportunities for data extraction in combination with other Excel functions.

Get step-by-step recipes for real-world automation problems. Learn Power Query and Power Automate solutions for SharePoint, PDFs, and workflows – apply them immediately to save hours.

You’d like to create financial models in Power BI? This eBook will teach you how. Download the templates and get started today!

This book shares a wide variety of advanced and new techniques. Bonus videos on Data Presentation included.

This Excel Black Belt Package includes EIGHT of our Popular Courses.
You’ll learn high-value, in-depth Excel skills that solve real problems.

10x your productivity in Excel 💪 by mastering Excel’s Power Tools in ONE convenient (cost savings) bundle.
Learnings apply to Power BI as well.

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.

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