Microsoft Excel Advanced
About
Following on from the Beginners and Intermediate course, the Advanced course will further your knowledge in Microsoft Excel. You will gain an understanding of how to create Excel workbooks and worksheets and navigate around them. You will also learn how to use some of Excel’s time-saving exercises such as Autosum and Autofill and how to create simple formulae and format worksheets.
Start
29 October 2021
Duration
1 day, 9 am – 4.30 pm
Location
Queens Road Campus
Fees
£75 + VAT
Overview & Modules
The course will look at a variety of topics area including:
- Functions
- Using one-input or two-input data tables / What-if tables
- A first look at pivot tables
- Scenarios
- Auditing
- Macros
How will I be assessed?
Assessment is by portfolio of work.
Entry requirements
Delegates must have attended the Intermediate course or evidence an ability approved by our tutor.
Continue your studies
Enhance your skill set with Getting started with Microsoft 365 or Google workspace.