Advanced Excel Archives

Excel Power Pivot Measures – 5 Examples

May 21, 2024

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)

Feb 11, 2024

In this article, you will get a proper overview of Power Pivot formulas and get to know about the types of calculations performed in Power Pivot with ...

Power Pivot Formulas (2 Suitable Examples)

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

Jun 15, 2024

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

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

How to Do Web Scraping in Excel (2 Methods)

Jul 8, 2024

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 Do Web Scraping in Excel (2 Methods)

How to Create and Remove Floating Cells in Excel

May 28, 2024

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 Create and Remove Floating Cells in Excel

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

May 9, 2024

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

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

Drawing in Excel (Basics & Application)

Jun 20, 2024

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)

Jul 1, 2024

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

How to Insert a Shape in Excel (2 Methods)

Excel Data Mining (All Things You Need to Know)

Jun 19, 2024

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

Excel Data Mining (All Things You Need to Know)

Workflow in Excel: A Must-Have Guide

Dec 24, 2023

In this article, we have given a detailed guide for creating and automating workflow in Excel. Workflow is necessary for company to synchronise steps ...

Transform Data in Excel: A Visual Guide

Jun 20, 2024

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

Jun 2, 2024

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 Multiple Sources in One Query: 2 Practical Methods

Excel AutoFilter – A Complete Guide

Jun 9, 2024

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)

Jul 7, 2024

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

Jul 3, 2024

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