Advanced Excel

Supercharging Excel with Python

This tutorial will show how you can supercharge Excel with Python within Excel and via traditional external libraries.

Create Stunning Charts in Excel: Tips and Tricks from the Pros

This tutorial will show you tips and tricks to create stunning charts in Excel.

Excel Power Pivot Measures – 5 Examples

A DAX code will be used to find average sales, commission, success rate of broker calls, and the greatest number of calls. Download ...

Power Pivot Formulas (2 Suitable Examples)

Here's an overview of Power Pivot formulas: Download the Practice Workbook Using Formula in Power Pivot.xlsx Understanding ...

Excel Data Connections (Create, Refresh, Manage & Remove)

Here's an overview of one of the ways you can make data connections in Excel. Download Practice Workbook We recommend downloading the ...

How to Do Web Scraping in Excel (2 Methods)

Method 1 - Using the "Get Data from Web" Feature Go to the Data tab and select From Web under the Get & Transform Data section. ...

How to Create and Remove Floating Cells in Excel

Method 1 - Using Watch Window to Create Floating Cells To make particular info available all the time while scrolling through big data in Excel, ...

How to Use a Timeline in Excel? – A Visual Presentation

A timeline is a representation of events in chronological order. Download Practice Workbook Timeline in Excel.xlsx How to ...

Drawing in Excel (Basics & Application)

In this article, you will learn about drawing in Excel. More specifically, you will learn about the basics, drawing flow charts, and free-form ...

How to Insert a Shape in Excel (2 Methods)

    Method 1 - Inserting a Shape from the Insert Tab STEPS: Go to the Insert tab >> Illustrations >> Shapes. ...

Excel Data Mining (All Things You Need to Know)

Here's a simplified overview of data mining in a smaller dataset. Download the Practice Workbook Data Mining Excel Example.xlsx ...

Workflow in Excel: A Must-Have Guide

In this article, we provide a detailed guide to creating and automating workflow in Excel using Excel's built-in shapes. Creating a workflow can ...

Transform Data in Excel: A Visual Guide

Here's an image overview of the sample dataset we'll use to demonstrate how you can transform data. Download the Practice Workbook ...

Power Query Multiple Sources in One Query: 2 Practical Methods

Method 1 - Merge Multiple Data Sources in One Query with Power Query Step 1: Import Data into Excel Workbook Import an Excel workbook from the ...

Excel AutoFilter – A Complete Guide

This is an overview. Download Practice Workbook Download this file to practice. Excel AutoFilter.xlsx How to Enable the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo