Home Excel Excel Basics

Excel Basics

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

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

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

Sum if between

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

_xlfn. prefix in Excel

0
The Excel _xlfn. prefix indicates that your workbook contains a function that is not supported by your version of Excel.

How are dates stored in Excel?

0
Learn how dates are stored sequentially in Excel.

CONCAT Function

0
The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016 as a...

Average Annual Growth Rate (AAGR)

0
Learn how to calculate the Average Annual Growth Rate (AAGR) in Excel.

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

Round Numbers in Excel

0
Rounding numbers in excel is critical in order to make spreadsheets look more professional.

Print to X Number of Pages

0
Sometimes when using Excel you may want to customize the way that you print the information you are working with.  One option...

Latest Tutorials

Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than

Sum if between