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
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
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.
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.
No pre-course work required.
All delegates who successfully complete this course will receive an electronic certificate of attendance.
We deliver our Microsoft Excel Advanced course throughout the UK and beyond. We can facilitate onsite at your premises, as a virtual training option for those who are working from home or at any number of venues in Belfast, Glasgow, Edinburgh, Aberdeen, Inverness, Newcastle, Manchester, Leeds, Birmingham, Cardiff or London. Contact Us for more information or click the green button below to see when we are next running this as an open course anyone can attend.
Chat with us via Whatsapp