Course description
Our Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyse worksheet data, utilise data tools, collaborate with others, and create and manage macros.
Upcoming start dates
Suitability - Who should attend?
This course is ideally suited for individuals who have completed the Intermediate level programme and are determined to get the most out of this powerful spreadsheet and database package.
Outcome / Qualification etc.
On completion, delegates will be able to:
- Create pivot tables and charts
- Learn to trace precedents and dependents.
- Convert text and validate and consolidate data.
- Collaborate with others by protecting worksheets and workbooks.
- Create, use, edit, and manage macros
- Import and export data
Training Course Content
Module 1 – Nested IF/Lookups
- IF Functions recap
- Nested IF
- Lookup
- Match/Index
Module 2 – Pivot Tables and Auditing
- Subtotal/Pivot Tables
- Subtotal
- Pivot Tables
- Pivot Charts
- Auditing
- Precedents/Dependants
- Error Checking
- Calculate Formula
- Watch Window
Module 3 – WHAT IF
- Goal Seek
- Solver
- Scenario Manager
- Data Tables
Module 4 – Macros (Optional for In-house delivery)
- Security
- Recording & Running Macros
- Macro Buttons/Toolbars
- Relative References
- Modifying VBA Code
Course delivery details
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.
In addition, the course is also suitable for those looking to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel 2016, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Request info
Cosensa Learning and Development Training Courses
Cosensa Learning & Development offers training courses for professionals and organisations throughout the public, private and third sectors. All Cosensa trainers are highly qualified, with extensive experience in training and coaching. Cosensa's wide range of open courses are delivered throughout...