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

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

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

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

How to Open a 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 ...

Encryption in Excel: 3 Possible Methods

Method 1 - Encrypt an Excel File Using Encrypt with Password Feature Go to File>> Info>> Protect Workbook>> Encrypt with ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo