Advanced Excel

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

Find Duplicates in Excel Column

Find Duplicates in Excel Column: Knowledge Hub Find Duplicates in Two Columns in Excel Find Similar Text in Two Columns in Excel Excel ...

How to Create an Algorithm in Excel: 5 Methods

Method 1 - Machine Learning Algorithm Step-1: Prepare Training Data To demonstrate the whole procedure, we have taken the following sample dataset, ...

The Ultimate Guide to Excel Add-ins: 9 Methods

Method 1 - Analysis ToolPak Description: The Analysis ToolPak is a collection of data analysis tools that provide advanced functions for ...

Excel Protected View (Amazing Feature of Excel)

Excel Protected View feature acts as a barrier, protecting us from potential dangers when we open specific files. In this article, we'll look at ...

How to Do Excel Encoding (Check and Change)

The texts or symbols we see on our computer screens are stored in different forms on the back end. The numerical values are stored with some special ...

Report in Excel (Using Pivot Table and Charts)

In this Excel tutorial, you will learn how to generate a report in Excel. You can organize raw data with PivotTable, create charts to visualize data, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo