Advanced Excel

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

In this article, you will learn about Excel AutoFilter. From enabling AutoFilter to applying different criteria, you will find them here. Filtering ...

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 for better handling data. Moreover, we will show how to add pictures as ...

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 Examples)

In this article, we will provide a brief and thorough overview of create an algorithm in Microsoft Excel. First, we will give a glimpse of what an ...

Excel Add-ins (Ultimate Guide)

In this article, you will learn all things you need to know about Excel Add-ins like the advantages of using add-ins, types of it, ways to activate ...

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)

In this Excel tutorial, you will learn how to - Check the encoding of an Excel file - Change the encoding to UTF-8 using the web option - Change ...

Report in Excel (Using Pivot Table and Charts)

In this Excel tutorial, you will learn how to generate a report in Excel.  We will also see how we can organize raw data with PivotTable, create ...

How to Open CSV File in Excel

Open CSV in Excel: Knowledge Hub Open CSV File in Excel Without Formatting Excel Open CSV with Delimiter Open CSV file in Excel with ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo