How to use Excel

Learn how to use Excel's logical functions such as IF AND OR and NOT.

When joining text and a number use the TEXT function in Excel to format that number. This page contains many easy to follow TEXT function examples.

If you want to view multiple Excel worksheets at the same time execute the following steps.

Flash fill is a great Excel tool. Learn how to use flash fill to automatically extract data combine data and much more.

Learn more about the Workbook and Worksheet object in Excel VBA. In Excel VBA an object can contain another object and that object can contain another object etc. In other words Excel VBA programming involves working with an object hierarchy. This probably sounds quite confusing but we will make it clear.

Use the shortcut F12 to display the Save As dialog box in Excel. Press CTRL + s to save an existing workbook. It's good practice to periodically save while you are working on your Excel file.

To quickly insert a row in Excel select a row and use the shortcut CTRL SHIFT +. To quickly insert multiple rows select multiple rows and use the same shortcut.

If you're an Excel beginner this is the perfect place to start. Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel.

The RANK function in Excel returns the rank of a number in a list of numbers. Use RANK.AVG to return the average rank if more than one number has the same rank.

Below we will look at a program in Excel VBA that sets the background color of tasks that are on schedule to green and sets the background color of tasks that are behind schedule to red.