Courses

About this course

If you can navigate your way around a basic spreadsheet but want to learn how much Excel can actually do for you then join us for this 4-week course. Learn about formatting and page layout options; basic formulae and functions; worksheet linking and how to create charts and basic Pivot Tables.

Materials Required: Course notes provided. Please bring pen and notepad.

NOTE: There is no class on 27th February.

Additional Information: Topics to be covered include:
• various formatting features including conditional formatting and tables
• page layout options, print areas, hide columns
• formulas and functions including IF, COUNTIF, SUMIF, VLOOKUP
• filtering, sorting, grouping
• named ranges
• data validation and lists
• worksheet linking
• charts
• introduction to basic Pivot Tables and Slicers

Upcoming Courses