Latest Blog Posts

How to Build a Custom Data Entry UserForm in Excel VBA

In this tutorial, we'll show how to build a custom data entry UserForm in Excel VBA that validates user input and stores records in an Excel table.

Detecting Suspicious Expenses with Benford’s Law in Excel: A Real-World Case Study

Learn how to use Benford's Law in Excel to screen a real vendor-payment dataset for suspicious expenses, with first-digit formulas, a comparison ...

7 Power BI Design Rules for Reports People Actually Read

In this tutorial, we will show 7 Power BI design rules for reports people actually read. The seven rules cover page layout, KPI placement, color ...

How to Validate InputBox Entries in VBA

In this tutorial, we will show how to validate InputBox entries in VBA. You will be able to validate InputBox entries and handle common user input ...

How to Analyze an A/B Test in Excel: From Raw Data to a Decision

In this tutorial, we'll show how to analyze an A/B test in Excel from raw data to a one-page decision summary you can hand to a manager.

Writing Complex Data Validation and Dependent Dropdown Rules with ChatGPT

In this tutorial, we will show how to write complex data validation and dependent dropdown rules with ChatGPT.

Power BI Premium vs. Pro vs. Fabric: Which License Do You Actually Need?

In this tutorial, we will explain the differences among Power BI Premium, Pro, and Fabric: which license do you actually need? This will help you ...

How to Use Named Ranges to Make Formulas Easier to Read and Maintain

In this tutorial, we will show how to use named ranges to make formulas easier to read and maintain. We will cover everything from the basics to ...

How to Build an Image & Media Asset Inventory Tracker in Excel

Managing a growing collection of digital media, family photos, or marketing assets can quickly become overwhelming without a structured system. ...

Building a Robust Job Application Tracker in Excel

In this tutorial, we will build a robust job application tracker in Excel, using tables, drop-down lists, formulas, conditional formatting, filters, ...

Building LAMBDA and LET Functions with ChatGPT in Excel

In this tutorial, we will explore how to build LAMBDA and LET functions with ChatGPT in Excel. Let’s build both functions from scratch, refine them, ...

Writing Power Query M Code with ChatGPT

In this tutorial, we will show writing Power Query M code with ChatGPT and then apply that code in Excel or Power BI.

All About Excel Table Relationships

In this tutorial, we will cover all about Excel table relationships. Excel relationships are particularly useful for large datasets, PivotTables, ...

7 Excel Functions for Managing a Small Business Budget

In this tutorial, we will show 7 useful Excel functions for managing a small business budget.

Power BI Mobile: Designing Reports That Actually Work on a Phone

In this tutorial, we will show how to design reports that actually work on a phone in Power BI mobile. We will optimize the following sales dashboard ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo