Latest Blog Posts

How to Create a Timeline Chart in Excel (3 Simple Ways)

Timeline Charts are charts or graphs that depict the chronological execution of partial events of a much bigger event. We have tasks of a ...

How to Generate Reports Using Macros in Excel (with Easy Steps)

In this article, we’ll demonstrate a quick, effective method to generate reports in Excel using Macros. Quick View of the Macro Code Private ...

How to Add a ROUND Formula to Multiple Cells in Excel – 2 Methods

This is the sample dataset. Method 1 - Dragging the Fill Handle Icon to Apply the ROUND Formula Steps Select D5 and enter the ...

How to Convert Minutes to Decimal values in Excel – 3 Methods

The sample dataset is in Time Format. To convert time into minutes and then to decimal format: Method 1 - Using a Simple Multiplication to ...

Currency Conversion Using VLOOKUP in Excel (2 Suitable Examples)

As of now, Excel doesn’t have any built-in currency conversion tool yet. So we either need at least a basic multiplication formula or other formulas ...

How to Round Excel Data to Make Summations Correct (7 Easy Methods)

We work with numerical data in our Excel worksheet all the time. We perform various operations on them. Finding Summation is the most common task of ...

Rounding to Nearest Dollar in Excel: 6 Easy Ways

Method 1 - Using ROUND Function for Rounding to Nearest Dollar Steps: Select cell E5. Write down the following formula into the cell. ...

How to Recover Corrupted Excel Files from USB (4 Quick Methods)

Due to either physical or logical corruption, an Excel file may be corrupted. In this article, you will learn 4 quick methods to recover corrupted ...

How to Insert Slicer without Pivot Table in Excel

To filter and analyze data Excel Slicer helps a lot because it provides some extra features than the Filter command. But the problem is you can’t use ...

How to Create a Project Timeline in Excel (3 Simple Methods)

We will use the following dataset, which contains Milestones and metrics of the Effort of a project. Method 1 - Use the SmartArt Graphics ...

How to Fill Blank Cells with Text in Excel (3 Methods)

Dataset Overview Let’s start with our sample dataset, which contains several blank cells. Our objective is to fill these blank cells with text. ...

Excel VBA to Read CSV File into Array (4 Ideal Examples)

  What Is a CSV File? A CSV file is a comma-separated values file, which saves data in an organized format. CSV files are compatible with many ...

How to Change Decimals to Percentages in Excel (4 Easy Ways)

If you want to change decimals to percentages in Excel, this article will be helpful to you. Here, we will walk you through 4 easy and effective ...

Excel VBA to Replace Blank Cells with Text (3 Examples)

We have a dataset of some students containing their names, class, and percentage in the examination. There are some blank cells in the Percentage ...

Excel VBA: How to Replace Text in a String – 5 Methods

This is the sample dataset.   Method 1 - Using Excel VBA to Replace a Text Starting in the n-th Position of a Random String Step ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo