Skip to main content
Toggle navigation
SIGN IN
REGISTER
You’re offline. This is a read only version of the page.
Skill Details
Essential Skill Information
View Skill (Open Access)
Skill Details
Skill Name
*
*
Skill Category
*
Creative Skills
Health and Beauty
Business
Children and Education
Communication Skills
Construction & Trade Skills
Customer Services
Manufacturing & Engineering
Events and Security
Finance & Accounting
Functional Skills
GDPR and Data Protection
Green Skills
Health and Safety
Health and Social Care
Health and Wellbeing
Hospitality and Catering
Human Resources
IT & Computer Skills
Leadership and Management
Office Management and Administration
Project Management
Legal, Quality & Assurance
Sales and Marketing
Transport and Logistics
Is Accredited
*
Is Accredited
No
Is Accredited
Yes
Is Apprenticeship
*
Is Apprenticeship
No
Is Apprenticeship
Yes
Skill Overview
*
*
If you know the basics of Excel and want to start using some of the more advanced features then this is the course for you. On this 1 day Advanced Excel course you will learn about Pivot Tables, templates, data control, drop downs, Vlookups, Macros, conditional formatting and other essential features on this Advanced Excel course. The course covers Excel 2010/2013/2016/2019 & 365 (Also Excel 2011 for Mac). Get to grips with Excel with tuition from a leading trainer from M Training. Our courses are limited to 6 delegates so you can ask questions and get personal support throughout the course.
Learning Objectives
*
*
On this 5 star rated course you will learn to use some of Excel's more advanced and complex features. The course will show you how and when to use these features and functions to help you get the most of your data efficiently. Topics include: Cell Styles, Tables & Conditional Formatting; Protecting cells and workbooks; Controlling user permissions; When to use templates; Creating and editing templates; Control data that can be entered; Create drop down lists; Creating and using Vlookups; Creating and using Pivot tables; What are Macros; Creating and using Macros
Funding Option
*
Fully funded
Part funded / Co-invested
Commercial
Funding Eligibility
*
Skill Price ex VAT (£)
*
*
Skill Length
*
1 Hour or less
1 Day or Less
2 Days to 1 Week
2 to 6 Weeks
7 Weeks +
Skill Level
*
Beginner
Intermediate
Advanced
Skill Timings
*
Course is delivered anytime between Mon-Fri 9am-5pm
Evening
Weekend
Flexible
Delivery Method
*
Physical location
eLearning
Virtual classroom
Blended
Flexible
Skill Eligibility (Prerequisites for skill/software requirements)
*
This is an advanced course so you should have a good understanding of the basic Excel skills. Need to brush up on your basic Excel? Check out our Introduction to Excel course.
Last Application Date
*
Skill Enrolment
*
Weekly
Monthly
Based on Demand
Skill Status
Pending
Live
Rejected
Finished
Skill Enquiry Details
First Name
*
*
Last Name
*
*
Email
*
*
*
Telephone
*
*
Postcode
*
*
Are you a company owner or senior decision maker?
*
Are you a company owner or senior decision maker?
No
Are you a company owner or senior decision maker?
Yes
No. of Delegates
*
*
What is your company name?
*
Would you like to explore skills support for your organisation through GM Business Growth Hub?
Would you like to explore skills support for your organisation through GM Business Growth Hub?
No
Would you like to explore skills support for your organisation through GM Business Growth Hub?
Yes
I accept the Terms and Conditions and Privacy Policy
*
I accept the Terms and Conditions and Privacy Policy
No
I accept the Terms and Conditions and Privacy Policy
Yes
Skill
*
Clear lookup field
Launch lookup modal
Lookup records
×
Close
We're sorry, an error has occurred.
There are no records to display.
You don't have permissions to view these records.
Error completing request.
Loading...
Error
×
Close
We're sorry, an error has occurred.
