Latest Blog Posts

How to Unprotect Excel Workbook with Password (3 Easy Ways)

We sometimes protect our Excel workbook with a password to restrain further structural modifications of our dataset. However, at the time of any ...

How to Pin the Ribbon in Excel (4 Simple Methods)

Excel user interface holds multiple Tabs, Groups/Sections, Command Menus, Commands, Dialog Boxes, and a single Pin or Unpin Toggle. This combination ...

How to Remove Password from Excel File (3 Easy Ways)

Method 1 - Remove the Password from an Excel File Using the Info Panel Steps: Open the file. Insert the password (“exceldemy” for the file ...

How to Calculate Absolute Difference between Two Numbers in Excel

We have Permissible Speed Limits (mph) for different states along with the tendency of drivers’ Average Speeds (mph). From these two numbers, we want ...

VBA Code to Convert Text File to Excel (7 Methods)

The sample Text file named “Test File” contains random lines and Line breaks. We will learn how to convert this text file to a new Excel file with ...

How to Hide Ribbon in Excel (6 Simple Ways)

The Microsoft Excel ribbon is a row of tabs and icons at the top of the Excel window that lets you rapidly identify, understand, and utilize commands ...

How to Sum to End of a Column in Excel (8 Methods)

  We will determine the sum of a column up to the bottom in Excel. We have taken a dataset that shows the store's sales for the month of ...

How to Replace Text with Blank Cell in Excel (5 Simple Methods)

This tutorial will demonstrate 5 simple methods to replace text with a blank cell in Excel. When working with a dataset, we may need to eliminate ...

How to Automate the Goal Seek in Excel – 2 Methods

The dataset showcases “Base Price”, “VAT, “Service Charge”, and “Total Price”. Change the Total Price to find the Base Price of a product (“VAT” and ...

How to Unprotect Excel Sheet with Password (2 Quick Methods)

This article illustrates how to unprotect an Excel sheet with a password. You may need to protect your worksheet to prevent any change in data or as ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo