Intermediate Excel is designed as a follow up for people who have completed the introductory excel course and wish to consolidate their skills before enrolling in an advanced level class.
This course will cover:
- revision of skills taught in introductory class
- formatting cells
- using autofill/ Flash Fill
- introduction to writing formulas
- using complex formulas
- relative and absolute cell references
- using functions like: sum, count, values etc
- freezing columns and rows/ hiding columns and rows
- devising charts and using sparklines
- formatting pages
- creating tabs for additional pages
The class is 3 hours a week for 10 weeks.
There are 4 intakes every year.