Excel Basics

How to Remove Percentage in Excel (5 Quick Ways)

Method 1 - Remove Percentage Using General Format in Excel Select the cell or cell range from where you want to remove the percentage. Open the ...

How to Use Boolean Operators in Excel: 4 Methods

Method 1 - Application of NOT Boolean Operator Step 1: Go to Cell F5. Write the below code: =NOT(D5=5) Step 2: Press ...

How to Remove Grid from Excel (Complete Guide)

In this article, you are going to learn everything about how to remove gridlines in Excel. Additionally, you will know about removing gridlines from ...

How to Remove Borders in Excel (4 Quick Ways)

Method 1 - Use the Excel Borders Drop-Down to Remove Borders STEPS: Select the Cell or Range of Cells where the Border is. In the Font ...

Removing Data Validation Restrictions: 3 Ways

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

Create Table in Excel Using Shortcut (8 Methods)

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

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

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 Sum by Group in Excel (4 Methods)

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 Apply ‘If Greater Than’ Condition In Excel (9 Ways)

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 Sum Only Visible Cells in Excel (4 Quick Ways)

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

Labour Contractor Bill Format in Excel (Download Free Template)

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

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

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 Calculate Cumulative Sum in Excel (9 Methods)

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

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

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

Hotel Bill Format in Excel (Create with Easy Steps)

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo