Latest Blog Posts

Power BI DAX Formulas to Simplify Complex Excel Calculations

In this tutorial, we will explore 5 Power BI DAX formulas to simplify complex Excel calculations. If you are an Excel power user, learning DAX ...

5 Essential Power Query Transformations for E-commerce Sales Data

In this tutorial, we will learn 5 essential Power Query transformations for e-commerce sales data that are especially useful for online store ...

How to Show a Progress Message While VBA Runs

In this tutorial, we will show how to show a progress message with VBA runs. You do not need a UserForm or a graphical progress bar. In many cases, ...

Python in Excel: When and How It’s Useful

In this tutorial, we will show how to use Python in Excel and when and how it’s useful. Instead of switching to other tools like Jupyter or VS Code, ...

How to Format Currency and Percentages in a Power BI Visual

In this tutorial, we will show how to format currency and percentages in a Power BI visual.

How to Create Your First DAX Measure

In this tutorial, we will show how to create your first DAX measure by clicking New measure. We'll keep it simple and literal, just the clicks and ...

How to Change a Visual’s Data Summary from Sum to Average

In this tutorial, we will show how to change a visual’s data summary from sum to average using the field wells. Select the visual, expand the value ...

5 Python Libraries for Advanced Excel Data Analysis Every Pro Should Use

In this tutorial, we will show 5 Python libraries for advanced Excel data analysis every pro should use. These libraries allow you to perform ...

The Excel Email Generator: Using VBA to Send Personalized Outlook Messages from Spreadsheet Rows

In this tutorial, we will show how you can build an Excel Email Generator, using VBA to send personalized Outlook messages from spreadsheet rows. The ...

A Practical Guide to Importing and Linking Large Excel Datasets in MS Access

In this tutorial, we will show step-by-step practical guide to importing and linking large Excel datasets in MS Access. This guide walks you through ...

7 Excel Settings Secretly Slowing Down Your Large Workbooks

In this tutorial, we will show 7 Excel settings secretly slowing down your large workbooks, with practical steps to identify and fix them. We'll ...

Creating Cross-Referenced Appendices and Tables of Contents in Word via Excel

In this tutorial, we will show how to create cross-referenced appendices and tables of contents in Word via Excel.

Creating and Using R Visuals in Power BI

In this tutorial, we will show how to create and use R visuals in Power BI.  Let us walk you through everything you need to know to create, publish, ...

7 Excel Functions for Effective Human Resources Management

In this tutorial, we will show 7 Excel functions for effective human resources management. We will focus on seven key functions. These are ...

Perform Time Series Anomaly Detection in Power BI

In this tutorial, we will show how to perform time series anomaly detection in Power BI to enhance your line charts and gain deeper insights into ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo