Latest Blog Posts

Calculate Conditional Weighted Average with Multiple Conditions in Excel: 5 Easy Methods

Method 1 - Use Generic Formula Calculate Conditional Weighted Average with Multiple Conditions in Excel STEPS: Select cell F13. Type the ...

How to Make Geographic Heat Map in Excel (2 Easy Ways)

  Method 1 - Using Built-in Maps Chart to Make Geographic Heat Map in Excel   Case 1.1 Creating Heat Map of States For a demonstration ...

How to Unprotect Excel Sheet with Password Using VBA: 3 Quick Methods

Method 1 - Perform a VBA Code to Unprotect Single Excel Sheet with Password in Excel Step 1: Open a Module, to do that, firstly, from your ...

How to Recover Previous Version of Excel File (4 Easy Ways)

We'll use a simple dataset to show how to recover a previous version of a file. The name of the workbook is Recover Previous Version of Excel ...

Time Series Forecasting Methods in Excel

If you are looking for different types of time series forecasting methods in Excel, then you will find this article useful. Forecasting methods are ...

How to Replace Text in Selected Cells in Excel: 4 Simple Methods

Method 1 - Replace the Text in Selected Cells Using Find and Replace Steps: Select the range of cells we want to perform find and replace it. ...

How to Replace Text after Specific Character in Excel (3 Methods)

If you want to replace text after a specific character in Excel, this article is for you. Here, we will walk you through 3 simple, easy, and ...

How to Replace Text between Two Characters in Excel (3 Easy Ways)

In this article, we will learn to replace text between two characters in Excel. Sometimes, we import datasets from other sources. Those datasets can ...

How to Show Ribbon in Excel (5 Quick & Simple Ways)

This article illustrates 5 easy ways to show the ribbon in Excel. You may accidentally hide the ribbon in Excel. If you are wondering about how to ...

How to Calculate Weighted Average in Excel (3 Easy Methods)

This tutorial illustrates three easy methods to calculate the weighted average in Excel. While evaluating a simple average of a group of numbers, we ...

Pivot Table: Percentage Difference between Two Columns – 2 Methods

  The following table contains selling and cost prices of different products.   Method 1 - Using the 'Fields, Items, & ...

How to Create a Simple Database in Excel VBA

Watch Video – Create a Simple Database in Excel VBA The sample data set below contains the names, joining dates, and salaries of ...

How to Show Toolbar in Excel: 4 Simple Ways

Method 1 - Show Toolbar Using Control Buttons Steps: The ribbon menu toolbar on a given Excel sheet is hidden at the moment. That means there ...

Is There Any Way to Increase the Excel Row Limit?

Each workbook in Excel has a limit on the number of rows and columns of data it allows. Tip: Hold the CTRL+Down Arrow key simultaneously to ...

How to Calculate Significant Difference Between Two Means in Excel

The following picture highlights calculating the difference between means. What Is the Significant Difference and T-Test? Significant ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo