Excel Basics

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

A1 vs R1C1 Reference Style

0
Learn the difference between A1 vs R1C1 Reference Style in Excel.

Randomly Sort Data in Excel

0
Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Display Formula and Value Simultaneously

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

Clear a filter in Excel

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

How to apply Multiple Filters in Excel

0
We are going to cover how to use Multiple filters in Excel. A Filter is cumulative, this implies that you can apply...

Data Filtering in Microsoft Excel 2013

0
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

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

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

Find and Select

0
This tutorial is going to review the Find & Select button in the Home section of the ribbon. Let’s say...

Find and Replace in Excel

0
Learn how to use the Find and Replace feature in Excel. This handy tool can save you a ton of time and...

Latest Tutorials

NPER Function

NPER Function

CUMPRINC Function

CUMPRINC Function

YEARFRAC Function

YEARFRAC Function