Latest Blog Posts

Downloadable Resume Templates: ATS-Friendly Designs Made in Microsoft Word

In this tutorial, we will create a downloadable ATS-friendly design in Microsoft Word.

How to Build a Full Calendar Interface in Excel Using Form Controls

In this tutorial, we will show how to build a full calendar interface in Excel using form controls.

Harnessing Office Scripts: Automating Workflows in Excel Online

In this tutorial, we will show how to automate workflows in Excel online using Office scripts.

The Ultimate Guide to Understanding Excel Power Tools: Power Query, Power Pivot, and Power BI

This article dives into understanding what Power Query, Power Pivot, and Power BI are, highlighting their differences, niches, and practical use ...

How to Build Lightweight Machine Learning Models in Excel Using Solver and Formulas

In this tutorial, we will show how to build lightweight machine learning models in Excel using Solver and formulas.

Power BI as a Back-End Engine for Excel Reports

In this tutorial, we will show how to use Power BI as back-end engine for Excel Reports.

How to Automate Reports from Excel to Power BI

In this tutorial, we will show how to automate reports from Excel to Power BI.

How to Use Excel to Simulate Real-World Random Events (From Coin Flips to Weather)

In this tutorial, we will show how to use Excel to simulate real-world random events, including practical datasets for coin flips, dice rolls, and ...

Building Advanced Excel Dashboards: Power Query, Power Pivot, and VBA

In this tutorial, we will show how to build advanced Excel dashboards using Power Query, Power Pivot, and VBA.

From Excel Workbook to Power BI Report in 30 Minutes

In this tutorial, we will show the transformation of an Excel workbook to a Power BI report in 30 minutes.

8 Ways to Remove Duplicates in Excel Without Losing Data

In this tutorial, we will show 8 ways to remove duplicates in Excel without losing data.

Unleashing Power Query for Data Scientists: Reshape, Merge, Clean at Scale

In this tutorial, we will show how data scientists can use Power Query to reshape, merge, and clean at scale.

Power BI vs Excel Dashboards: Which is Right for You?

This tutorial will help you understand the strengths, limitations, and ideal use cases for each platform.

7 Hidden Microsoft Word Features You’re Probably Not Using (But Should Be)

In this tutorial, we'll explore seven hidden Microsoft Word features you are probably not using but you should use.

Getting Started with Excel for Financial Modeling

This tutorial will show you how to use Excel for financial modeling.

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo