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 ...

How to Link PowerPoint Chart to Excel: 2 Methods

Method 1 - Create the Chart in Excel Select the table range C5:D13 and go to Insert Tab >> Chart to create a chart. An Excel ...

How to Do a GST Reconciliation in Excel (4 Methods)

What Is GST Reconciliation in Excel? GST (Goods and Services Tax) is a tax applied to items you purchase or services you use. It’s added to the cost ...

How to Create a 3D Scatter Plot in Excel

Suppose you have the following dataset to use for a 3D Scatter Plot. Insert a Scatter Chart Steps: Select the active range (B4:D16 ...

How to Create Multiple Invoices in an Excel Spreadsheet – 2 Steps

This is an overview. Download Practice Workbook Invoices.xlsx Creating Multiple Invoices.docx Create Invoices in ...

How to Use Advanced Pivot Table in Excel (25 Tips & Techniques)

PivotTable - Basic Things A PivotTable is a powerful data analysis tool in Microsoft Excel. It allows users to quickly summarize, organize, and gain ...

How to Make Periodic Table in Excel: 2 Easy Ways

Method 1 - Manual Periodic Table 1.1. Insert Data in Properties Table Each element of a periodic table has a unique set of properties. These ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo