Latest Blog Posts

How to Create Pivot Table with Values as Text (with Easy Steps)

The following figure shows a table and a pivot table created from the table. The table has no numeric data, containing a list of some employees, ...

How to Copy a Pivot Table in Excel (2 Quick Methods)

In the dataset, you will see a shop's Sales and Profit information on random days from June to August. We will use this data to create a Pivot Table ...

How to Format an Excel Pivot Table (The Complete Guide)

  1. Formatting Numbers in Pivot Tables Steps: To change the data format, right-click any value >> choose Number Format from the ...

Basic Terminologies of Microsoft Excel

In this article, we will provide an overview of some of the basic terminology used in Microsoft Excel, including explanations of basic concepts, and ...

Creating a Pivot Table Automatically in Excel (2 Methods)

Pivot tables allow you to easily extract insights from complex datasets, but creating them manually can be time-consuming and tedious. Fortunately, ...

How to Create Pivot Table in Excel for Different Worksheets

Here's an overview of a pivot table created from different worksheets. An Example of Creating a Pivot Table in Excel Step 1 - Insert a ...

Excel Pivot Table Example (11 Different Case)

What Is a Pivot Table in Excel? A Pivot Table is an amazing data analysis tool of Microsoft Excel. It can analyze data according to our desired ...

19 Practical Data Cleaning Techniques in Excel

  Method 1 - Remove Duplicate Rows Here's a sample dataset that contains duplicate rows. Let’s replicate the column and remove the ...

How to Change a Vertical Column to a Horizontal row in Excel – 6 Methods

This is the sample dataset. This will be the output: Method 1 - Change a Vertical Column to a Horizontal row using the Paste ...

Examples of OFFSET Function in Excel (Formula+VBA ) 

Download Practice Workbook Examples of OFFSET Function.xlsm Overview of OFFSET Function The OFFSET function returns a reference to a ...

How to Do Automated Data Cleaning in Excel (10 Easy Tips)

We have a disorganized dataset containing Name, Date of Birth, Profession, and Salary of some people. Method 1 - Use the Power Query Feature ...

How to Get Filename from Path in Excel: 7 Simple Methods

Method 1 - Use Find and Replace Feature to Get Filename from Path Steps: Select cells (B5:B11) from the worksheet with paths. Selecting ...

How to Randomize Rows in Excel (2 Easy Ways)

Method 1 - Randomizing Rows in Excel with Multiple Columns We have a dataset of some sales representatives of an organization, their net sales, ...

Examples of VLOOKUP Function in Excel: 7 Ideal Examples

Method 1 - Search for Particular Value Steps: Look at the following image, where you want to find Paul's marks on his G. Science exam. ...

How to Use Flash Fill in Excel (7 Easy Examples)

Introduction to Excel Flash Fill Flash Fill can recognize a pattern in values and fill in the rest of the range based on the initial provided ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo