Latest Blog Posts

How to Calculate Cost of Debt in Excel (3 Simple Ways)

Debt financing and equity financing are two important types of financing. Any business that wants to operate must obtain loans from a variety of ...

How to Make Automatic Marksheet in Excel (with Easy Steps)

Sheet1 contains the personal details, numbers, and grading of each student. Sheet2 contains the mark sheet template. We inserted a bold ...

How to Show a Relationship Between Two Variables in an Excel Graph

Understanding Correlation Correlation measures how strongly two variables are connected. It’s represented by a coefficient called ...

How to Add Row Hierarchy in Excel (2 Easy Methods)

Row Hierarchies are helpful to read data easily when we have rows of data that are connected to each other. If you want to add row hierarchy in ...

How to Create a Table in Excel with Multiple Columns

We have a column with First and Last Names, ID, and their respective marks in a single column, starting with B4. We will convert this into a table ...

How to Use Macro to Save Excel File with New Name (5 Ways)

Method 1 - Keeping File in Current Location Press Ctrl+F11 to open the VBA. Go to the Insert option and select the Module. The VBA ...

How to Create a General Ledger in Excel – 4 Steps

Step 1 - Input Fields and Choose the Range Select data to input into the General Ledger. A typical ledger has 5 fields: Serial no., Date, ...

[Fixed!] Up and Down Arrows Not Working in Excel (8 Solutions)

Try the following solutions one-by-one to try and solve the issue of up and down arrow keys not working in Excel. Solution 1 - Turn Off Scroll ...

How to Add Bullets in Excel Cell (10 Quick Ways)

Here is a dataset showing the obtained marks of 5 students in a school. We will insert bullets before the names. Method 1 - Add Bullets in ...

Excel Formula to Return Blank If Cell Value Is Negative

There are 2 suitable ways to return a blank if the cell value is negative in an Excel formula: by using the IF function and by using the Format Cells ...

How to Compute Grades in Excel (3 Ways)

In this sample dataset the columns are labelled Name, Marks, and Grades. For the grades, we have 5 possible options.   Method 1 - ...

How to Turn Off the Sheet View in Excel – 2 Steps

The sample dataset: Dataset to Turn Off Sheet View, showcases Branch Name, Sales Rep, Product Name, and Sales.   Step 1 - Activating ...

How to Show the Quick Access Toolbar in Excel – 3 Methods

This is the Quick Access Toolbar:   Method 1 - Applying the Ribbon Display Options Click Ribbon Display Options. Check ...

How to Draw a Line Through Text in Excel (6 Easy Ways)

Excel is excellent for working with numbers, but formatting text values in the way you want is not always obvious. The example of strikethrough is ...

How to Hide Zero Values in Excel Chart (5 Easy Ways)

Zero values often create difficulties while visualizing data in a chart. Here are 5 effective methods to hide these values from Excel charts. We will ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo