Excel Basics

How to Remove Data Validation Restrictions in Excel (3 Ways)

In Microsoft Excel, data validation is one of those tasks that makes it easy to input data. If you want to limit your input data type, you can use ...

Create Table in Excel Using Shortcut (8 Methods)

A table in Excel allows you to perform different calculations and organize your data more easily. You can create a table in Excel in different ways. ...

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

In Excel, number formatting is an amazing feature. Sometimes we have large numbers which may be difficult to read. We can improve the readability of ...

How to Sum by Group in Excel (4 Methods)

To sum by group means to add up values of a particular category. We often use it on numerous occasions in our daily lives. The summation of a group ...

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

While working with a big data set, we frequently need to compare numbers. In some cases, we need to find the summation, average or conditional ...

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 can easily Sum a range of Excel datasheets. But, quite frequently we need to add the cell values following a condition. This article will show you ...

How to Calculate Cumulative Sum in Excel (9 Methods)

The Cumulative Sum is very commonly performed in Excel by many people all over the world. It is often called the Running Total/Balance. The ...

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

In some cases, a number starts with zero (0). Such as phone numbers, credit card numbers, product codes, postal codes, personal identification ...

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

44 Mathematical Functions in Excel (Download Free PDF)

Microsoft Excel has plenty of mathematical functions that help perform various mathematical operations. In this article, you will get to know 44 ...

Tally Bill Format in Excel (Create with 7 Easy Steps)

In this article, I will show you how to create a tally bill format in Excel from scratch. You can make bill format from Excel Template too. Small ...

Excel Invoice Tracker (Format and Usage)

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

Find Unique Values in a Column in Excel (6 Easy Methods)

In Microsoft Excel, extracting unique values from a column is one of the crucial tasks. You will find yourself in various situations where you may ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo