AI-Powered Multiple Dimension Visualizations with Decomposition Trees in Power BI

In this tutorial, we will explain how to create AI-powered multiple-dimension visualizations with Decomposition Trees in Power BI. We will also cover ...

Summarize Visuals and Reports with Smart Narrative in Power BI

In this tutorial, we will show how to summarize visuals and reports with smart narrative in Power BI. Let's explore how it works, how to configure it ...

Pacifying #N/A Errors with IFNA

In this tutorial, we will pacify #N/A errors with IFNA, what IFNA really does, and when to use it.

5 Power BI Visualization Types That Excel Can’t Replicate (And Why They Matter)

In this tutorial, we will show 5 Power BI visualization types that Excel can’t truly replicate. We will also explain why they matter to help Excel ...

Top External Tools to Pair with Excel

In this tutorial, we list top external tools to pair with Excel. External tools bridge these gaps while letting you leverage Excel's strengths.

How to Import Data From Microsoft Access

In this tutorial, we will show how to import data from Microsoft Access into Excel.

How to Create a VBA Log Sheet for Errors

In this tutorial, we will show how to create a VBA log sheet for errors.

Regex Crash Course for Excel Power Users

This is our Regex crash course for Excel power users.

5 Things You Can Do with Excel + Python

In this tutorial, we will show five things you can do with Excel + Python.

How to Build Nested IF Statements in a Single Cell

In this tutorial, we will show how to build nested IF statements in a single cell.

5 Excel Shortcuts Most People Discover Too Late

In this tutorial, we will show 5 Excel shortcuts that most people discover late.

Something Totally Different: Excel Tricks to Build Mini Games and Puzzles

In this tutorial, we will show Excel tricks to build mini games and puzzles — something totally different.

How to Create Dynamic Drill-Through Reports in Power BI

In this tutorial, we will show how to create dynamic drill-through reports in Power BI.

3 Ways to Use Excel Pivot Tables to Better Understand Your Data

In this tutorial, we will explain 3 ways to use Excel Pivot Tables to better understand your data.

Choosing the Right IF Function: An Excel Function Map

In this tutorial, we will show the steps to choosing the right IF function. Instead of memorizing formulas, you will learn how to decide which ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo