Advanced Excel

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

DAX in Power Pivot: All Things to Explore

In this article, I have described what DAX is in Power Pivot and how to use it, including its applications and benefits. I have shown the use of ...

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

Power Query Excel

Power Query Excel: Knowledge Hub How to Use Power Query Date Functions in Excel Power Query Multiple Sources in One Query Power Query Get ...

Power Query Joins

Power Query Joins: Knowledge Hub Combine Two Tables Using Power Query in Excel How to Perform Left Join in Excel Perform Left Outer Join ...

Excel Intersection (Ranges, Named Ranges & Datasets)

In this article, we’ll focus on the topic of Excel intersection. We will explore different scenarios where this functionality works successfully. ...

Custom Data Validation in Excel

Excel Custom Data Validation: Knowledge Hub Excel data validation custom formula vlookup Excel data validation custom multiple criteria ...

How Can You Alternate Row Colors in Excel? (4 Easy Ways)

In this Excel tutorial, we will show you how to apply alternating row colors in Excel using a manual approach, conditional formatting, table ...

Merge Excel File (Excel Features, Formula, VBA & Power Query)

In this Excel tutorial, you will learn how to merge data in Excel file with manual copying, merge in Excel using the move or copy option 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 ...

Print Scale Excel (Complete Guide)

In this article, we will review the benefits of using the print scale in Excel. The ability to scale prints is crucial for professionals who rely on ...

Markers in Excel (Add and Customize)

In this tutorial, we will show how to insert and customize markers in Excel. We will also show how to add pictures as data markers and how to add ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo