60 results for: pivot table

How to Combine Files From a Folder with Excel Power Query

Learn the easiest way to combine multiple Excel files into one Workbook. With Power Query you can import files directly from a folder and append them into one table or Pivot Table. It just takes a few clicks.

Power BI course image

Fast Track to Power BI – Limited Offer

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!

5 Hidden Excel Features for Busy People

Learn five amazing time-saving features in Excel that you likely have never tried or even knew existed. Turn hours of work into seconds.

Guerilla data analysis eBook

Guerrilla Data Analysis Using Microsoft Excel (eBook)

Upgrade your Excel knowledge with this guide.
Perfect for any skill level. Dive into hands-on analysis with real-world cases and tools.

Microsoft 365 Excel: The Only App That Matters (eBook)

Boost Your Excel Skills!
This comprehensive eBook makes learning Excel easy and effective for all levels. Perfect for career growth. Start your learning journey now!

Excel Essentials for the Real World – Limited Offer

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

Insert Image in Excel Cell (and Lookup Images)

Learn how to use the new “Image in Cell” feature in Excel to store and lookup images from cells.

Import Power BI Data into Excel

Learn how to export data from Power BI and use it in Excel. The data can be enhanced by Excel and receive updates from Power BI when new data is added to the Power BI Data Model.

Excel Find and Highlight Duplicates

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.

Automate With Power Query – Recipes to solve business data challenges

Do you want to become more confident using Power Query and automate your entire data workflow? Join this course and learn from real-world scenarios.

Excel Insights by 24 MVPs – eBook with Bonus Video

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

Power Excel Bundle course cover

Power Excel Bundle

10x your productivity in Excel 💪. This bundle includes Master Excel Power Query course & Master Power Pivot and DAX course. It’s Excel’s Ultimate Power Tools in ONE convenient (cost savings) bundle. Learnings apply to Power BI as well.

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