Latest Blog Posts

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

How to Use an Excel Trendline for Part of the Data – 2 Methods

This is an overview. Download Practice Workbook Download the workbook here. Trendline for Part of Data.xlsx What is a ...

How to Insert the Excel Tooltip on Hover – 3 Examples

The image below showcases the Excel tooltip on hover. Using the Excel Tooltip You can use the tooltip to: Input Data Explain Data ...

How to Combine Two Formulas in Excel (3 Ways)

Here is an overview of combining two formulas in Excel. How to Combine Two Formulas in Excel: 3 Ways Method 1 - Two Different ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo