Advanced Excel

Excel Power Pivot Measures – 5 Examples

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)

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

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

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

How to Do Web Scraping in Excel (Power Query & VBA)

In this article, learn how to - Scrape tabular data from web in Excel. - Scrape entire page data including hyperlinks from web. While ...

Excel Floating Cells (Create and Remove)

We'll talk about different methods to give the spreadsheet a floating effect as we explore the idea of floating cells in Excel. Excel does not have a ...

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

Insert Shape in Excel (2 Easy Methods)

In this article, we'll learn how to insert shape in Excel. Understanding how to work with shapes can significantly elevate your Excel skills. We ...

Excel Data Mining (All Things You Need to Know)

In this tutorial, we will demonstrate data mining Excel example. Further, we will explore examples to prepare data before data mining in Excel. You ...

Workflow in Excel: A Must-Have Guide

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

In this article, we will see various techniques to transform data in Excel. We will explore some common Excel functions like SUM, AVERAGE, and MAX, ...

Power Query Multiple Sources in One Query (2 Practical Methods)

In this tutorial, we will demonstrate how to add multiple sources in one query with Power Query. We will import data from the local Excel workbook ...

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

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo