Latest Blog Posts

How to Keep Track of Small Business Expenses in Excel (2 Ways)

In this article, we will discuss expense tracking and its components, as well as methods for small businesses to keep track of expenses in Excel. The ...

How to Apply Conditional Formatting with 3 Color Scale in an Excel Formula – 2 Methods

The sample dataset is a large Excel worksheet containing information about several students. Method 1 - Using the IF Function to Apply ...

How to Make Excel Faster on Windows 10 (19 Effective Ways)

When the Excel spreadsheet contains a large number of data and calculations, the application loses its efficiency, and the processing time of that ...

How to Calculate Income Tax on Salary with Old Regime in Excel

The income tax is a tax imposed on individuals in respect of their income or profits. Frequently, you need to calculate the income tax on salary by ...

How to Fill a Series Based on Extrapolation in Excel (6 Easy Methods)

In our regular professional life, we have to fill many series based on extrapolation to fulfill our organization's requirements. Using Microsoft ...

How to Arrange Excel Sheet in Ascending Order (2 Methods)

When you have to work with a lot of Excel sheets, it’s a better practice to organize all the sheets well. Excel sheets can be organized into a folder ...

[Solved]: Data Bars Not Working in Excel (3 Possible Solutions)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. ...

How to Open Large Excel Files Without Crashing (10 Methods)

Method 1 – Removing Excel Add-ins Steps: Go to the File tab on your ribbon. Select Options from the left side of the backstage view. ...

How to Change Case in Excel Sheet (8 Quick Methods)

While working in Microsoft Excel we might find different cases like lowercase, and uppercase in different cells. Sometimes you will find upper and ...

How to Make Office Expense Sheet in Excel (with Easy Steps)

Here's an overview of how a sample office expense sheet might look. You can customize this template later. How to Make an Office Expense ...

How to Make a Family Budget in Excel (2 Effective Ways)

The article will show you how to make a family budget in Excel. Excel is a very useful tool to calculate mathematical problems in a very efficient ...

Excel VBA: Turn Off Auto Calculate

In this article, I’ll show you how you can turn off auto calculate using in Excel. Excel VBA: Turn Off Auto Calculate (Quick View) Sub ...

How to Calculate BMI in Excel (2 Methods)

BMI Calculation BMI stands for Body Mass Index. It’s a simple method that uses height and weight to determine a person’s body status. By calculating ...

How to Separate Address in Excel Using Formula (With Easy Steps)

We have the following dataset which contains some addresses. We will separate the address into parts separated by comma. Step 1 - Merge ...

Excel Change to Proper Case Without Formula (6 Easy Ways)

Looking for ways to know how you can change to proper case without formula in Excel? Then, this is the right place for you. Here, you will find 6 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo