Latest Blog Posts

Blank in Pivot Table

Blank in Pivot Table: Knowledge Hub Show Zero Values in Excel Pivot Table Hide Zero Values in Excel Pivot Table Remove Blank Rows in Excel ...

Amortization Schedule Excel Template with Extra Payments – Free Download

In the Amortization schedule borrowers can visualize their loan repayment process. This schedule shows: regular due payment, principal paid, interest ...

How to Zoom In or Out in Excel – 6 Examples

This is an overview. Example 1 - Use the Zoom Slider to Zoom In or Out in Excel Drag the zoom slider to the left to zoom out and to the ...

EIDL Loan Amortization Schedule Excel [Free Download]

The EIDL loan amortization schedule is a great tool to visualize EIDL loan repayment. EIDL stands for “Economic Injury Disaster Loan”. Some borrowers ...

How to Add, Edit, Hide and Remove Notes in Excel

Method 1 - Apply Keyboard Shortcut Select the cell you want to add notes to and press  Shift+F2  on your keyboard. As a result, a note will appear. ...

How to Use the Status Bar in Excel? (All Things to Know)

In this Excel tutorial, you will learn - About the default options in the status bar that appear whenever you open the Excel application - How to ...

How to Open, Run and Turn Off Excel Safe Mode (Complete Guideline)

This tutorial was prepared using Microsoft 365, but the operations apply to all versions of Excel. ⏷What Is Safe Mode in Excel? ⏷Open ...

How to Add, Remove, and Print Background in Excel

Here's an overview of how a table looks without and with a background. Click here to see the full image ⏷What Is Excel Background? ⏷Add ...

How to Freeze Panes in Excel – Rows/Columns/Multiple Panes

Consider the following dataset. It contains 60 rows and 11 columns. The top row is frozen.   How to Freeze Rows in Excel 1. ...

How to Insert and Remove Carriage Return in Excel

A carriage return is also known as a line break in an Excel cell. While they are technically different, the traditional meaning of carriage return ...

How to Attach File in Excel (4 Easy Methods)

Here's an overview showing what types of files you can attach to a sheet. ⏷When Do We Attach File in Excel? ⏷How to Attach a File ...

How to Insert, Use and Convert Complex Numbers in Excel?

In the following image, we have shown different functions related to complex number operations in Excel. X and Y are two complex numbers. We can see ...

How to Add, Change and Format Cell Borders in Excel [Ultimate Guide]

In this Excel tutorial, we will describe how to add, change, format, draw, remove, and create custom styles for cell borders in Excel, and even how ...

Table Array in Excel (Create, Use and Fix Issues)

The table below is an overview of table array to lookup values in Excel. Download Practice Workbook Table Array.xlsx What Is ...

How to Use the Excel Screenshot Option (Take, Edit and Copy)

To take a screenshot in Excel, first, go to the Insert tab and then select the Screenshot option from the Illustrations group. There are two ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo