Study Learn Grow
Microsoft Excel - Advanced Training

Microsoft Excel - Advanced Training


This course comprises of advanced tools such as Goal Seek, Scenarios, Advanced Filtering, Validating entries, Protection techniques, Pivot Tables and Macros.

Overview

About this Course
The Excel - Advanced Training session follows on from the Intermediate course, but now it's time to step up a gear from formulas and formatting and get into becoming an Advanced User.

This course comprises of advanced tools such as Goal Seek, Scenarios, Advanced Filtering, Validating entries, Protection techniques, Pivot Tables and Macros.

You'll be able to perform calculations for forecasting and predicting, generate reports from multiple sources and create structured, manageable Pivot Table reports for analysing big data sets.

All the files used on the course are available to download and work alongside each video, or in your own time to try out yourself.

Basic knowledge
You'll need Excel 2007, 2010, 2013 or 2016 installed and a desire to want to learn what Excel can really do for you!

Course Information

You'll need Excel 2007, 2010, 2013 or 2016 installed and a desire to want to learn what Excel can really do for you!

What you will learn
You'll be able to learn the advanced tools and features from your desk from a Microsoft Trainer
Take your skills learnt to many different situations and roles
Pick up tips, techniques and shortcuts to make using Excel simple!
You'll learn great tools such as Consolidate, Advanced Filtering, Goal Seek for forecasting data, Pivot Tables, Protecting Sheets and Recording Macros

Anyone who wants to learn more than formulas and enhance their knowledge to become an Advanced user of Excel
Users should have a good understanding of the basics as this is not an introduction level course

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs