Course description
Microsoft Excel Advanced
This course builds on the foundational and intermediate knowledge presented in the Microsoft Excel Introduction and Intermediate courses to help you get the most of your Excel experience.
The ability to collaborate with colleagues, automate repetitive tasks, and use conditional logic to construct and apply complex formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organisation generates.
You can choose either our Classroom training at one of our venues, Your Site or Live, Instructor-led Virtual training from the comfort of your home.
Benefits of Studying Microsoft Excel with Infero Training:
- CPD Accredited Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- 15 Premier Locations, Latest Tech, Refreshments, OR We Come to You
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £89 per person
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
Before taking this course, students are recommended to take the following courses, or have equivalent knowledge:
- Microsoft Excel Introduction
- Microsoft Excel Intermediate
Target Students
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.
Outcome / Qualification etc.
Certification
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
Course Objectives
Upon successful completion of this course, students will be able to:
- Work with multiple worksheets and workbooks simultaneously.
- Share and protect workbooks.
- Automate workbook functionality.
- Apply conditional logic.
- Audit worksheets.
- Use automated analysis tools.
- Present your data visually.
Training Course Content
Microsoft Excel Advanced Course Content
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
- Topic A: Use 3-D References
- Topic B: Use Links and External References
- Topic C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
- Topic A: Apply Data Validation
- Topic B: Work with Forms and Controls
- Topic C: Work with Macros
Lesson 4: Applying Conditional Logic
- Topic A: Use Lookup Functions
- Topic B: Combine Functions
- Topic C: Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
- Topic A: Trace Cells
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Activate and Use the Solver Tool
- Topic E: Analyse Data with Analysis ToolPak Tools
- Topic A: Use Advanced Chart Features
- Topic B: Create Sparklines
Course delivery details
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Why choose Infero Training Ltd
97% Recommend Us from 4000 Corporate Clients
100% Money Back Guarantee
Training at 15 locations, Your Office or Live Virtual
Expenses
Course fee: £198.00 + VAT
Continuing Studies
- Microsoft Excel VBA Introduction
- Microsoft Excel VBA PRO