Search courses 👉
Corporate Training for Teams

Microsoft Excel Advanced

Infero Training Ltd, Online (+1 locations)
Length
1 day
Price
198 GBP excl. VAT
Next course start
Enquire for Live Virtual Classroom dates (+3 start dates)
Course delivery
In Company, Virtual Classroom
Length
1 day
Price
198 GBP excl. VAT
Next course start
Enquire for Live Virtual Classroom dates (+3 start dates)
Course delivery
In Company, Virtual Classroom
Leave your details so the provider can get in touch

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

Choose between 3 start dates

Enquire for more information

  • In Company
  • United Kingdom

Enquire for Training at Your Company's site

  • In Company
  • Online

Enquire for Live Virtual Classroom dates

  • Virtual Classroom
  • Online

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

Get Inspired! Watch the Video

Request info

Contact form

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
If you want us to recommend other suitable courses, please fill out all fields below and check the box beside "Please recommend similar options"
Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Ads