How to Use Drawing Tools in Excel (2 Easy Methods)

Method 1 - Using the Drawing Tools from the Insert Tab We'll draw a simple flow chart. Steps: Choose “Shapes” from the “Insert” option. ...

How to Reconcile Credit Card Statements in Excel – 4 Steps

The dataset below showcases bank and the accountant's cash book statements. There are discrepancies in these statements. Step 1 - ...

How to Calculate Monthly Payment on a Loan in Excel (2 Ways)

In this article, we will learn how to calculate monthly payment on a loan in Excel. When you take a loan for a certain period, you need to make a ...

How to Calculate Growing Annuity in Excel (2 Methods)

What is an Annuity? An annuity, often associated with retirement planning, represents a fixed stream of payments received either annually or monthly ...

How to Fix If Undo and Redo in Excel Are Not Working (3 Simple Solutions)

  Solution 1 – Open Excel in Safe Mode STEPS: Go to the Windows search bar. Enter Excel.exe /Safe. You’ll get the application, as ...

How to Create Employee Attendance Sheet with Time in Excel

We have a sample dataset that contains the Employee ID numbers and Employee Names. We will create an employee attendance sheet with time for the ...

How to Calculate Future Value in Excel with Different Payments: 5 Ideal Methods

Method 1 - Calculate Future Value of Periodic Payments in Excel Steps: Select the cell (C9) where you want to keep the future value. ...

How to Zoom in When Zoom Slider Is Not Working in Excel

Looking for ways to know how to zoom when the zoom slider is not working in Excel? Sometimes, we may find that the zoom slider is not added or is not ...

How to Zoom in on a Map Chart in Excel (5 Methods)

Dataset Method 1 - Zooming in on a Map Chart in Excel Using Paste Special In this method, we’ll utilize the Paste Special feature to zoom ...

Calculating Payback Period in Excel with Uneven Cash Flows

In this article, we discuss how to calculate the payback period on an investment with uneven cash flows in Excel. What Is Uneven Cash Flow? ...

How to Make a Grade Calculator in Excel (2 Suitable Ways)

If you are working for a school or any educational institution, then you may need to make a grade sheet calculator describing the grade percentage ...

2 Easy Ways to Indent Twice the Data in Excel

Indenting twice the data refers to adding a double gap at the start of a cell's content. Indentation makes it easier to read and understand long ...

How to Use Debt to Equity Ratio Formula in Excel (3 Examples)

In business, the debt-to-equity ratio is an essential factor to evaluate, because it expresses the condition of a business. We can easily guess the ...

How to Repeat Rows at Top in Excel (3 Suitable Ways)

  How to Repeat Rows at Top in Excel: 3 Suitable Ways  The sample dataset contains some items, the quantity of each item, and the total number ...

How to Remove Unwanted Objects in Excel (4 Quick Methods)

The sample dataset below includes company logos (images). We will remove the logos from the worksheet using 4 different methods. Methods 1 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo