Microsoft Excel Advanced Course – Classroom
Master and make the most of Excel by automating repetitive tasks and creating complex formulas with conditional logic to process large data sets efficiently.
- All Courses
- Microsoft Office
- Microsoft Excel
- Microsoft Excel Advanced Course – Classroom
Course Overview
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.
This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.
Price
Duration
1 Day
Training Options
Classroom
Microsoft Excel Advanced Course Content:
Lesson 1: Working with Multiple Worksheets and Workbooks
- Topic A: Use Links and External References
- Topic B: Use 3-D 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: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
Lesson 4: Using Lookup Functions, Dynamic Arrays, and Formula Auditing
- Topic A: Use Lookup Functions
- Topic B: Use Dynamic Arrays and Dynamic Array Functions
- Topic C: Trace Cells
- Topic D: Watch and Evaluate Formulas
Lesson 5: Forecasting Data
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecast Data Trends
Lesson 6: Creating Sparklines and Mapping Data
- Topic A: Create Sparklines
- Topic B: Map Data
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
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
- Professional Microsoft Certified Trainer
- 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
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £89 per person
This course is intended for students who are experienced Excel users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.
To ensure success, students should have practical, real-world experience creating and analysing datasets using Excel. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customising the Excel environment.
To meet this prerequisite, you can take any one or more of the following courses:
- Microsoft Excel Introduction
- Microsoft Excel Intermediate
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Choose Your Date & Location
Testimonials
Gerard Cahill Commercial Accountant from Capital One
Khalid Tai Ecotricity (Stroud)
Steve Large Director from Large Creative
Lisa Dunstan Payroll Manager from Decathlon UK
Michael Sexton
John Clarke
Sarah Harvey Assistant Accountant from QD Commercial Group Holdings
Harry Frost Marketing Assistant from Babcock International Group
Emily North
Sam Fletcher
Take Yourself Further With Infero
Top Microsoft Excel FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm