Event details

What are the benefits?

• This course explains about the count function, how to name cells and use them in calculations.
• It covers how to track data with Conditional Formatting and how to sort, filter data and convert a range of data to a Table.
• Charts and an understanding of how to print exactly what is needed are also included.

Topics covered include:

More functions
• Counta, Count, Countblank and CountIF
• IF Function

Cell and Range Names
• Creating named ranges
• Using & Managing Named Ranges

Lookups
• VLOOKUP and HLOOKUP Functions

Working with Data
• Conditional Formatting including with formulas
• Sorting and Filtering Data

Charting
• Creating Charts
• Chart Formatting Options
• Sparklines

Printing
• Printing options
• Setting up Print Areas

Who should attend?

This course is aimed at those who have a basic knowledge of MS Excel and know how to modify data and formulas. They should understand which order calculations are performed in and the difference between relative and absolute formulas.