Excel for Big Data: Techniques for Handling and Analyzing Massive Datasets

In this tutorial, we’ll show you how to use Excel for big data along with techniques for handling and analyzing massive datasets.

Build a Cohort Analysis Tool in Excel for Data Science

In this tutorial, we will build a cohort analysis tool in Excel for data science.

How to Implement Drag-and-Drop File Uploads with Excel + Power Query

In this tutorial, we will show how to implement drag-and-drop file uploads using Excel and Power Query.

From Spreadsheets to Solutions: Building Workflow Tools with Excel

In this tutorial, we will show how to transform ordinary spreadsheets into powerful workflow tools with Excel.

How to Use Excel as a Lightweight CMS for Website Content Planning

In this tutorial, we will show how to use Excel as a lightweight CMS for website content planning.

How to Create a Fillable Form in Microsoft Word Without Developer Mode

In this tutorial, we will show how to create a fillable form in Microsoft Word without developer mode.

Unlock Your Excel Data in Power BI: A Beginner’s Guide to Connecting Spreadsheets

This tutorial will show you how to unlock your Excel data by connecting your spreadsheets to Power BI.

How to Trigger Conditional Formatting Based on External Workbook Values

In this tutorial, we will show how to trigger conditional formatting based on external workbook values.

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.

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo