Excel Basics Archives - Page 142 of 176

How to Calculate Cumulative Sum in Excel (9 Methods)

Jul 3, 2024

The following picture shows the cumulative sum obtained by using one of the methods. 9 Ways to Perform Cumulative Sum in Excel ...

How to Calculate Cumulative Sum in Excel (9 Methods)

How to Keep 0 Before a Phone Number in Excel (6 Methods)

May 17, 2024

Method 1- Apply Text Format to Retain 0 Before a Phone Number in Excel Highlight all the cells where you want to keep the numbers with a leading ...

How to Keep 0 Before a Phone Number in Excel (6 Methods)

Hotel Bill Format in Excel (Create with Easy Steps)

Apr 16, 2024

Hotel Bill format is an invoice format that you can use to create hotel bills for clients in order to document information about hotel services as ...

Hotel Bill Format in Excel (Create with Easy Steps)

Shortcut for Sum in Excel (2 Quick Tricks)

Nov 11, 2025

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

Shortcut for Sum in Excel (2 Quick Tricks)

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

Nov 11, 2025

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 Sum of Squares in Excel (6 Quick Tricks)

How to Calculate Percent Frequency Distribution in Excel

Nov 11, 2025

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

How to Calculate Percent Frequency Distribution in Excel

44 Mathematical Functions in Excel (Download Free PDF)

Jun 18, 2024

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

44 Mathematical Functions in Excel (Download Free PDF)

Create Tally Bill Format in Excel From Scratch: 7 Methods

Jul 5, 2024

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

Create Tally Bill Format in Excel From Scratch: 7 Methods

Excel Invoice Tracker: Format and Usage

May 30, 2024

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?

Nov 11, 2025

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

Nov 11, 2025

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

Relative and Absolute Cell Address in the Spreadsheet

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

Jul 27, 2024

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

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

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

Jul 5, 2024

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 Perform Greater than and Less than in Excel (5 Methods)

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

Jun 27, 2024

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 First And Last Name in Excel (6 Easy Ways)

How to Split Screen in Excel (3 Ways)

Nov 11, 2025

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