Excel Basics

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

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

GOAL SEEK in EXCEL – What-If Analysis

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

Create a Drop Down List

0
If you want to force user for selecting data from the fixed data items and prevent user from entering custom data for any...
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...

How are dates stored in Excel?

0
Learn how dates are stored sequentially in Excel.

Named Ranges in Excel – Setup, Rules, and Uses

0
Learn how to use Named Ranges in Excel.

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

Pivot Tables

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

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

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.

Latest Tutorials

Year Function

YEAR Function

Delete Multiple Rows of data