Excel Basics

Shortcut for Sum in Excel (2 Quick Tricks)

From time to time, we store various types of data in Excel sheets, and most of the time we need to Sum up cell values. This article will show you ...

How to Calculate Sum of Squares in Excel (6 Quick Tricks)

Microsoft Excel provides us with the option to calculate the Sum of Squares very easily. We can also compute the Sum of Squares using mathematical ...

How to Calculate Percent Frequency Distribution in Excel

A percent frequency distribution can help you figure out what proportion of the distribution is made up of specific values. By grouping values ...

44 Mathematical Functions in Excel (Download Free PDF)

1. The AVERAGE Function Function Objective: The AVERAGE function calculates the average of numbers in a range of cells. Syntax: ...

Create Tally Bill Format in Excel From Scratch: 7 Methods

Method 1 - Create a Bill Header with Company Details Enter company details such as Company Logo, Name, Address, Contact Details, GSTIN No. etc. ...

Excel Invoice Tracker: Format and Usage

Managing and keeping track of billing is a daunting task when we use a plain Excel worksheet. Using an Excel Invoice Tracker can ease this task. An ...

How to Make an Amortization Table in Excel?

This article shows how to make an Amortization table in Excel that shows the periodic payments on a loan over a period of time. This table breaks ...

Relative and Absolute Cell Address in the Spreadsheet

We can use the cell addresses of other workbooks and applications as a reference. In Excel, there are two types of cell addresses one is a relative ...

How to Find Unique Values in an Excel Column (6 Methods)

Method 1 - Using Advanced Filter for Unique Values We'll use the below dataset: Steps Open your Excel workbook. Navigate to ...

How to Perform Greater than and Less than in Excel (5 Methods)

We have an Excel worksheet that contains information on various outlets of a chain restaurant all across the United States. The Excel worksheet ...

How to Split First And Last Name in Excel (6 Easy Ways)

The sample dataset contains two columns: Full Name and Account Number. We'll split the Full Name column. Split the First and Last Name in ...

How to Split Screen in Excel (3 Ways)

Excel’s split screen option is a great way to view your work simultaneously at the same time. You can even visualize your work vertically or ...

Transport Bill Format in Excel (Create in 4 Simple Steps)

What Is an Excel Transport Bill Format? A transport bill is a type of receipt provided by a transport service. The overview of a bill template is in ...

How to Insert a Picture in Excel Header

Below is a dataset that represents some data from an online article publisher. Follow the steps to insert a Header in the Excel dataset. If you know ...

How to Use an Excel Table Reference -10 Methods

The following sample Table contains students's marks. Method-1 -Using a Structured Reference as an Excel Table Reference Marks1 is the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo