Conditional Formatting

You can use something called Conditional Formatting in your Excel spreadsheets. Conditional Formatting allows you to change the appearance of a cell, depending on certain conditions. What we'll do is to colour the Overall Averages on our Student Exam spreadsheet, depending on the grade. 

Pivot Tables

A Pivot Table is way to present information in a report format. The idea is that you can click drop down lists and change the data that is being displayed. For example, choose just one student from a drop down list and view only his or her scores. 

Pivot tables are a lot easier to grasp when you see them in action. 

Excel String Functions

Excel has an abundance of string functions that can be used to manipulate data. In this article we will look at how to convert somebody’s full name into their initial and surname. So for example Mark Doppler becomes M Doppler.

Hlookup Function

HLOOKUP is kin to VLOOKUP. VLOOKUP looks up a value from a Vertical list and HLOOKUP looks up a value from a Horizontal list. Go figure. Here is a quick tutorial on the HLOOKUP function.

Vlookup Function

One of the popular Excel tutorial requests is how do you look up a value on one Excel worksheet and use it on another Excel worksheet. For example, you need to translate a product number into a product name. One of my favorite Excel functions is the VLOOKUP function and it can help with this task.