Formula Errors

In this tutorial I will show you how to identify and fix some of the frequently recurring formula errors in Excel.

continue reading »

How to make an Excel drop-down list

Drop-down lists is a feature of Excel that enables you to have users select an option from a predetermined list instead of them typing their own values. … continue reading »

Printing in Excel

In this lesson I will show you how to print an Excel worksheet and edit all kinds of print settings to meet your Excel printing needs.

continue reading »

How to print an Excel file horizontally

Sometimes you need to print a document in Excel but instead of a vertical orientation, you want your cells to be spread horizontally over your print sheet. … continue reading »

How to print your Excel file on one page

Often times printing Excel files will cause a lot of trouble because it will look different than what you see in your screen. … continue reading »

Find & Select

Excel Find and Select is a feature that enables you to quickly find specific text, and to replace it with other text. This is useful when you’re checking a large spreadsheets or when you need to change certain text repeatedly.

continue reading »

How to encrypt or protect an Excel file

This tutorial will show you how to encrypt an Excel file so that a password is required to be able to open it. … continue reading »

How to save Excel files in 97-2003 Format

If an excel user is running an older version of the program (Excel 2003 or older) they will be unable to view documents in the new .xlsx format. In order to enable users running older versions of Excel to open files that were made in newer versions it is possible to save files in the old 97-2003 .xls format. … continue reading »

How to view two or more workbooks in Excel at the same time

If you have multiple workbooks open and you need to work in two worksheets at the same time, it’s super convenient to be able to see them both next to each other.

continue reading »

Formulas and Functions

If there is one tutorial you must read when learning about Excel, I’d probably say it’s this one about Excel formulas and functions. This topic will introduce you to the most powerful feature Excel has – I promise you, after reading this, your world will never be the same again. … continue reading »