Microsoft Excel Advanced Training
-
A great course, surely value for money. The course was very practical, with lots of hands-on experience. The tutor was clearly very knowledgeable with Excel VBA code.
← | →
-
A friendly environment that helped a lot to enjoy the course. In general I liked learning new skills so it was good to signed forn this one and it I think it will genuinly help in my area and also add to my personal skills set in future job roles. Thanks!
← | →
-
Thanks for making our crazy ideas about the cost calculator become a reality! I have really enjoyed the course on Microsoft Excell and would highly recommend it to any of my colleagues.
← | →
Short course
In Nottingham and Timperley
Discover and benefit from all the advanced features of Excel!
-
Type
Short course
-
Level
Advanced
-
Location
-
Duration
1 Day
-
Start date
Different dates available
Do you want to improve your skills in Microsoft Excel?
With basic skills and some experience of Microsoft Excel, the topics covered on this course will enable you to further enhance your spreadsheets and to use some of the more advanced features to streamline your work.
If you want to enjoy all the benefits of the course, contact with us through our website so we can provide you with the most relevant information.
Facilities
Location
Start date
Start date
Start date
Start date
About this course
What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:
Use more Excel functions.
Utilise Excel's database functions.
Control and enhance Excel graphs.
Create simple macros.
Customise your Excel environment.
Who is this course for?
With basic skills and some experience of Microsoft Excel, the topics covered on this course will enable you to further enhance your spreadsheets and to use some of the more advanced features to streamline your work
What do I need to know before attending?
Delegates should have attended the Microsoft Excel Intermediate course or have the equivalent skills and knowledge to that level.
vantage training ltd attendance certificate
Vantage Training Ltd courses, are designed focusing on getting the best of Excel. We have been delivering high quality training to our customers for over 20 years. All course delegates are given 30 days post training support by telephone or email.
After enquiring about our IT courses, we will email you with the relevant course outline, course prices and date options. After agreeing a mutually convenient course date, we will send you a course booking form. When you have completed and returned your course booking form, we will send you your course joining instructions as confirmation of your booking.
After the course we will ring or email you to check that you are happy with your course and then send you your invoice, which is due within 30 day payment term.
Reviews
-
A great course, surely value for money. The course was very practical, with lots of hands-on experience. The tutor was clearly very knowledgeable with Excel VBA code.
← | →
-
A friendly environment that helped a lot to enjoy the course. In general I liked learning new skills so it was good to signed forn this one and it I think it will genuinly help in my area and also add to my personal skills set in future job roles. Thanks!
← | →
-
Thanks for making our crazy ideas about the cost calculator become a reality! I have really enjoyed the course on Microsoft Excell and would highly recommend it to any of my colleagues.
← | →
Course rating
Recommended
Centre rating
Caroline Tate
Krishna J.
Former Student
Former Student
Sven Thompson
Jim Anstey
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 15 years
Subjects
- Excel
- MS Excel
- Microsoft excel training
- Database
- Statistics
- Spreadsheet
- Microsoft Excel
- Graphic representation
- Chart analysis
- Data Management
Teachers and trainers (1)
Brian Roberts
Technical Trainer
20+ years experience of training delivery. Extensive programming experience using Microsoft Office based applications usually requiring Visual Basic programming. Designed, managed, and delivered corporate training roll-outs for several companies, including Barclays, Astra Zenica, and Unilever. Responsible for initial training needs analysis, training delivery, through to effective evaluation and post training support. Providing training solutions for a variety of industries, public sector, and educational establishments.
Course programme
Content
Advanced Spreadsheets
- Working with range names.
- Working with and consolidating multiple sheets.
- Further use of Excel functions such as conditional IF and Lookup.
Working with Text
- Text Functions and Text Import.
Graphs and Charts
- Different graph styles, creating, enhancing and editing graph.
- Printing independently or as part of the spreadsheet.
Database Functions
- Creating Excel databases.
- Accessing data by sorting and filtering data.
- Producing summary statistics.
- Cross tabulation using Pivot tables.
- Specific database functions.
Introducing Macros
- Recording commands in macros to simplify routines.
- Editing macros and assigning to objects.
Object Linking & Embedding
- Embedded Objects and Linking Objects.
Security Features
- Protecting Files, Cells, Worksheets and Workbooks.
Templates
- Creating & editing templates.
- XLSTART Directory.
- Understanding AutoTemplates.
What-If Analysis
- Goal Seek and Solver.
- Scenarios.
- Data tables.
Customising Excel
- Changing Microsoft Excel's default settings.
- Customising menus and toolbars and assigning macros to new buttons.
Microsoft Excel Advanced Training