Home Excel Excel Basics

Excel Basics

Learn the basics of Excel by reviewing easy to follow tutorials, tricks, and tips.

Creating a Template in Excel

0
To create a new template in Excel, follow the steps below. In this example, we will be creating the structure for a...

GOAL SEEK in EXCEL – What-If Analysis

0
Learn to master Goal Seek in Excel. We cover multiple real world examples.

Sum if between

0
To sum if between in Excel, we need to use the SUMIFS Function and define our criteria.

Mortgage Calculator in Excel

0
Need to figure out how much home you can afford? Let's create a mortgage calculator in excel. Want it be flexible and...

INDIRECT Function with Named Ranges

0
In this tutorial, we are going to cover how to use the INDIRECT Function with named ranges in Excel. Before we begin,...

Delete Multiple Rows of data

0
In some cases, there is a need to delete multiple rows of data in Excel. When dealing with large data sets, there...

Clear a filter in Excel

0
After filtering has been done, you might want to change or do away with the filtering. Clearing can...
Excel Tip Calculator

Tip Calculator Template

0
Learn to create a tip calculator template in Excel. This basic template allows you to setup a tip calculator for splitting up...

Data Validation Techniques in Excel

0
We are going to cover Data validation techniques in Excel. Data validation is a very important feature of Excel document. This feature...

Calculate Work Days in Excel

0
Calculate Work Days in Excel Using the following Functions Learn how to calculate work days for a given year,...

Latest Tutorials

NPER Function

NPER Function

CUMPRINC Function

CUMPRINC Function

YEARFRAC Function

YEARFRAC Function