Request a Quote
  • 100% Money Back Guarantee
  • Free Assessment
  • Post Course Support
Faye Samuda
Faye Samuda
2022-06-09
We (Junkyard Golf) did the Beginner Excel course with Martin and he was amazing. I had little to no knowledge of Excel and I’m not creating my own sheets and formulas to help with my day to day work. Will definitely be looking to complete the intermediate course. Thanks Martin!
Victoria Tyrer
Victoria Tyrer
2022-05-30
Since having my training on the intermediate excel course I have made huge improvements within my role. The training it self was very interactive and simple to follow. I would highly recommend this!
Laura Pirrie
Laura Pirrie
2022-04-28
Loved this Excel training course, learned a lot and have already been able to use my new skills in my day to day role at work. Definitely looking to book onto the more advanced level to further my skills!
Tracey Watson
Tracey Watson
2022-02-10
I took the Microsoft Excel Programming with VBA 3 day course. I learned a lot from our trainer, Martin. The course was well planned and delivered and I have already started to use what I learned.
Alec W
Alec W
2021-12-03
Enjoyed the course – learnt a lot. Small class size meant plenty of opportunity for questions but we did overrun slightly.
Roy Jordan
Roy Jordan
2021-03-11
I attended PRINCE2 Foundation and Practitioner with Suzi in February. I’m really happy with the service I received from start to finish and the course I took was really well presented. I asked to reschedule my date due to child care issues and they were very understanding and accommodating.
aaa slakana
aaa slakana
2021-03-10
ABSOLUTE CON! Avoid at all cost! the worst experience i can imagine . i could not attend my course due to unforseen circumstances and i have still not yet recieved a refund 12 months later. like others i have had to get my solicitors involved and no one has yet contacted from Infero Training.
Tom Vize
Tom Vize
2021-01-26
Booked onto an Excel VBA course, super friendly and helpful Staff and the Trainer (Martin) was incredibly knowledgeable and helpful. Really recommend – fantastic service.
Google rating score: 4.6 of 5, based on 42 reviews

Microsoft Excel Advanced – Virtual

Master and make the most of Excel by automating repetitive tasks and creating complex formulas with conditional logic to process large data sets efficiently.

Awaiting product image

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

£198.00

+ VAT

Duration

1 Day

Training Options

Virtual Classroom

 View Course Details

Microsoft Excel Advanced Course Content:

  • Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
  • Lesson 2: Sharing and Protecting Workbooks
  • Lesson 3: Automating Workbook Functionality
  • Lesson 4: Applying Conditional Logic
  • Lesson 5: Auditing Worksheets
  • Lesson 6: Using Automated Analysis Tools
  • Lesson 7: Presenting Your Data Visually

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, virtual 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:

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.

Don’t know which level you need to enrol?

Take a Free Excel Assessment Quiz

Testimonials

Take Yourself Further With Infero

Free Assessment
or Consultancy

Training
Options

12 Months
Support

100% Money
Back Guarantee

High
Feedback Rate

Interactive &
Hands On

Top Excel FAQs

How do I know which Excel level is right for me?

We offer quick and free Excel assessment which you can find “here”. It would tell you your Excel level, as well as recommend courses you may take. You may also go by course pre-requisites section on each course page.

Will I receive a certificate upon completion?

Yes, all of our courses come with certificate of completion. After you finish the course, we will send you your certificate through e-mail in 2-3 working days.

Can I ask questions or seek clarification during the course?

Of course, we pride ourselves in interactive and hands-on courses, so questions are welcome and encouraged during the course.

Is there ongoing support after completing the Excel course?

Yes, after the course we provide a variety of post-course support documents so you may revisit the content in your own time, as well as providing 12 months support via e-mail.

How experienced are your tutors?

Our company prides itself on quality of our courses, and that would not be possible with exceptional trainers! We employ tutors with both practical and teaching experiences, making sure they have specialist knowledge. We are happy to provide references and their profiles on demand.

Do I need any equipment for the Live Virtual courses?

For Microsoft Office courses you would need a computer with full version of the software you are training in. We also strongly recommend having access to a second screen for the training. This will allow you to do the exercises on your primary laptop or computer and see the virtual whiteboard on a secondary device. That device can be anything from a separate computer screen, to something like a tablet or phone.

Related products

Looking to book some training for your team?

Request a Quote

Courses

Infero

Learning

Resources

Infero Training

Linkedin Facebook Youtube Twitter

Copyright © 2024 Infero Training Ltd. All Rights Reserved.