Excel Basics Archives - Page 96 of 124

Removing Data Validation Restrictions: 3 Ways

May 28, 2024

Data Validation is a built-in feature that allows you to control the type of data documented in your dataset; it is also called a drop-down list. In ...

Removing Data Validation Restrictions: 3 Ways

Create Table in Excel Using Shortcut (8 Methods)

Jul 3, 2024

Method 1 - Create Table with Keyboard Shortcut Key ➤ Select the Entire dataset and press the following keys, CTRL+T The Create Table ...

Create Table in Excel Using Shortcut (8 Methods)

How to Format Number to Millions in Excel (6 Easy Ways)

Jun 28, 2024

We are using the dataset which contains some Product ID in column B, the total number of products in column C, and the budget of all the products in ...

How to Format Number to Millions in Excel (6 Easy Ways)

How to Sum by Group in Excel (4 Methods)

Jul 5, 2024

We will use the following dataset to illustrate summing by group. We have groups of items in the Items column, some of which repeat. ...

How to Sum by Group in Excel (4 Methods)

How to Apply ‘If Greater Than’ Condition In Excel (9 Ways)

Jul 1, 2024

Method 1 - Using a Logical Operator to Test the If Greater Than Condition Here's a dataset of the marks obtained by several students. We want to ...

How to Apply ‘If Greater Than’ Condition In Excel (9 Ways)

How to Sum Only Visible Cells in Excel (4 Quick Ways)

Apr 26, 2024

We have a dataset of some employees. It contains four columns: Employee name, Department, working Hours per day, and Salary. Here’s an overview of ...

How to Sum Only Visible Cells in Excel (4 Quick Ways)

Labour Contractor Bill Format in Excel (Download Free Template)

Apr 30, 2024

Here's a template we will make to ensure you can properly bill your customers for the work you do. Download the Practice Workbook ...

Labour Contractor Bill Format in Excel (Download Free Template)

How to Sum Only Positive Numbers in Excel (4 Simple Ways)

Jul 29, 2024

We're going to use a sample dataset as an example. The following dataset represents the Profit/Loss in the first 5 Days of January of a store. ...

How to Sum Only Positive Numbers in Excel (4 Simple Ways)

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)

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