Latest Blog Posts

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

How to Insert Pictures in Excel?

In this Excel tutorial, you will learn how to - Insert pictures in Excel - Insert a picture into an Excel cell and fit it to its size - Add a ...

Flowcharts in Excel – Different Workflow Types

This is an overview. Download Practice Workbook Download the Excel file and practice. Creating Flowchart.xlsx What Is a ...

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

DAX in Power Pivot: All Things to Explore

In this article, I have described what DAX is in Power Pivot and how to use it, including its applications and benefits. I have shown the use of ...

Conditional Average in Excel (Complete Guide)

Conditional averages involve calculating the average of a subset of data that meets specific criteria. In this Excel tutorial, we will demonstrate ...

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

How to Create a Hierarchy in Excel Using Different Methods

  What Is Hierarchy? Hierarchical Chart: The term hierarchy has a dual meaning. First, it refers to a specific type of ...

Excel Expense Tracker

Excel Expense Tracker: Knowledge Hub Daily income and expense excel sheet Daily expense sheet format in excel Business income and expense ...

Change Table Style in Excel (Change, Create & Remove)

We will demonstrate how to change table style by choosing table style, creating a custom table, resizing the table style, and removing table style. ...

Excel Charts : Add, Edit, Move and Remove Data

This is an overview. Download Excel Workbook Data for Chart.xlsx How to Add a Chart in Excel The sample dataset contains ...

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

Selling Price Formula Excel

Selling Price Formula Excel: Knowledge Hub How to Calculate Retail Price in Excel How to Calculate Selling Price in Excel Calculate the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo