5 LAMBDA Functions That Turn Excel Into Your Own Programming Language

In this tutorial, we will show 5 LAMBDA functions that turn Excel into your own programming language.

Fixing Excel Formulas with ChatGPT

In this tutorial, we will show how to fix Excel formulas with ChatGPT. ChatGPT excels as a debugging partner: it can explain complex formulas, ...

How to Use Boolean Variables in VBA

In this tutorial, we will show how to use Boolean variables in VBA. Instead of writing long conditions repeatedly, you can store the result in a ...

How to Rename Visual Fields Without Changing Your Power BI Source Data

In this tutorial, we will show how to rename visual fields without changing your Power BI source data. At the same time, keep the data model intact.

How to Use Conditional Formatting in Power BI for Table Cell Colors

In this tutorial, we will show how to use conditional formatting in Power BI for table cell colors.

Mining Your Excel Spreadsheets with ChatGPT

In this tutorial, we will show how you can mine your Excel spreadsheets with ChatGPT. You will get the prompts and techniques to get actionable ...

How to Format Dates in Excel Using VBA

In this tutorial, we will show how to format dates in Excel using VBA. Here you will get VBA examples with short codes.

How to Build an Automated Invoice Routing Workflow with Excel and Power Automate

In this tutorial, we will show how to build an automated invoice routing workflow with Excel and Power Automate. It will read new invoice rows from ...

Building Excel Spreadsheets with ChatGPT

In this tutorial, we will show how to build Excel spreadsheets with ChatGPT. Let’s explore how to use ChatGPT to create Excel spreadsheets faster and ...

5 Dynamic Excel Templates for Start-up Financial Projections

In this tutorial, we will show how to build 5 dynamic Excel templates for start-up financial projections. These templates will help startups track ...

5 Creative Ways to Use Excel for Event Planning and Management

In this tutorial, we will show 5 creative ways to use Excel for event planning and management. We will include seating charts, budget trackers, ...

Counting vs Summing vs Averaging: What’s the Right Function?

In this tutorial, we will explain Counting vs Summing vs Averaging and what’s the right function? The main decision is simple: do you want to count, ...

3 Dynamic Array Formulas That Make Your Old Workbooks Look Like Antiques

In this tutorial, we will show 3 dynamic array formulas that make your old workbooks look like antiques. Powerful dynamic array formulas: FILTER, ...

How to Loop Through Tables with ListObjects Using VBA

In this tutorial, we will show how to loop through Excel Tables with ListObjects using VBA. The focus is not only on referencing tables, but also on ...

How to Prevent Excel From Freezing During VBA Runs

In this tutorial, we will show how to prevent Excel from freezing during VBA runs. You can use DoEvents to temporarily give control back to Excel so ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo