Home Excel Excel Basics

Excel Basics

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

Display Formula and Value Simultaneously

Ever need to display a formula and value simultaneously in the same spreadsheet? This could not be easier to...

Autofilter in Excel

AutoFilter Excel offers an easy way to search or modify complex data sets using the AutoFilter feature. In order to use...

GOAL SEEK in EXCEL – What-If Analysis

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

Calculate Work Days in Excel

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

How are dates stored in Excel?

Learn how dates are stored sequentially in Excel.

Named Ranges in Excel – Setup, Rules, and Uses

Learn how to use Named Ranges in Excel.

Pivot Tables

Overview: Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to...

Data Filtering in Microsoft Excel 2013

Filtering is a fast and easy approach of sorting work with a portion of data so that you are able to display only...

Mortgage Calculator in Excel

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

Average Annual Growth Rate (AAGR)

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

Latest Tutorials

time value


Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than

Calculate Work Days in Excel