Latest Blog Posts

Power BI Alerts and Subscriptions: Getting Notified Before You Open the Report

In this tutorial, we will show how to use Power BI alerts and subscriptions to get notified before you open the report. Use an alert when the ...

7 Keyboard Shortcuts That Will Cut Your Excel Time in Half

In this tutorial, we will list seven keyboard shortcuts that will cut your Excel time in half. These shortcuts can make the biggest difference in ...

Power BI Dataflows: Reusable ETL for Your Excel and Power BI Reports

In this tutorial, we will show how to use Power BI Dataflows to create reusable ETL (Extract, Transform, Load) for your Excel and Power BI reports. ...

Visualizing Excel Data with ChatGPT

In this tutorial, we will show how you can visualize Excel data with ChatGPT, from getting smart chart-type recommendations based on your data ...

5 Excel Functions Every Marketer Should Know

In this tutorial, we will show five Excel functions that every marketer should know. These functions can help you summarize, categorize, measure ...

Top 10 Excel Influencers to Follow on YouTube

In this article, we have listed the top 10 Excel influencers you can follow on YouTube. These Excel influencers consistently publish high-quality ...

How to Connect Excel to Live Web APIs Without Using VBA

In this tutorial, we will show how to connect Excel to live web APIs without using VBA. We will use Power Query’s From Web feature to pull live API ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo