Excel Basics

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

Named Ranges in Excel – Setup, Rules, and Uses

0
Learn how to use Named Ranges in Excel.

GOAL SEEK in EXCEL – What-If Analysis

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

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

Latest Tutorials