How to Protect Cells Without Protecting Sheet in Excel (3 Ways)

We have the following dataset containing the sales records of some products of a company. We will protect specific cells of this dataset without ...

How to Separate Date from Text in Excel (4 Methods)

  Method 1 - Combining MID, SEARCH & DATEVALUE Functions to Separate Date from Text in Excel Let’s consider the following dataset with ...

How to Add Data Types to the Excel Ribbon (Quick Steps)

What Are Data Types in Excel? Data Types in Excel refer to various categories of information, each with specific details. By utilizing the Data ...

Excel Macro: Save as PDF with Date in Filename (4 Suitable Examples)

In this article, I’ve discussed 4 suitable examples to save an Excel file as a PDF using the Macro with the date in the filename. How to Save ...

How to Forecast Sales Growth Rate in Excel (6 Methods)

If you want to forecast sales growth rate in Excel, this article is for you. Here, we will demonstrate to you 6 simple, easy and effective methods to ...

How to Subtract from a Total in Excel (3 Quick Methods)

Method 1 - Subtract from a Total in Excel Using Relative Cell Reference   Insert the following formula in cell E5. =C5-D5 C5 has ...

Flash Fill Not Working in Excel: 5 Solutions

Method 1 - Flash Fill Not Working in Excel If It Is Turned Off Steps: Press ALT + F, then T to bring up the Excel Options window. Go to the ...

How to Open Two Excel Files Separately in Different Windows (5 Methods)

Method 1 - Use Shift Key and Taskbar Open the first Excel file (e.g., Data-1). Press the Shift key and click the Excel icon on the ...

Calculate Time Difference Between Two Dates in Minutes in Excel – 6 Methods

The dataset showcases Soldiers' names ans their training time. Method 1 - Using the Excel Arithmetic Operator to Calculate the Time Difference ...

How to Create a Correlation Heatmap in Excel – Quick Steps

The dataset contains students' marks in different Exams. Step 1 -  Enable the Data Analysis Tool In the Data tab, enable Data ...

How to Import Data into Excel from Another Excel File (2 Ways)

We've included a sample data set with a workbook named Subtotal Pivot Table in the image below. This worksheet's data will be imported into another ...

How to Use an Excel Formula to Replace Text with Number (5 Examples)

  Method 1 - Applying an Excel Formula with the SUBSTITUTE Function to Replace Text with Number Steps: Select cell C4. Enter the ...

How to Move Cells using the Keyboard in Excel – 3 Methods

The dataset showcases students’ Names, Departments, Id No., and Grade. Method 1 - Using the Copy-Paste Method with the Keyboard to Move ...

Excel VBA: Replace Character in String by Position (4 Effective Ways)

This article illustrates how to replace a character in a string by position using VBA in Excel with 4 effective approaches. We’ll use Excel’s ...

Excel Formula to Split String by Comma (5 Examples)

In the below dataset, ID no., LastName, and Dept. are kept as a single string separated by commas. Our goal is to split the strings into 3 columns. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo