Microsoft Excel Intermediate Training
-
I took the Excel Intermediate course and I can say now that it was good to learn more about Excel - I'm not afraid of the undo button anymore!
← | →
-
The trainer - Gill - was amazing and very knowledgeable on Excel.
← | →
-
The course content was well organised and presented. I still cannot believe how interactive this course was, I first thought it was going to be kind of hard. There was a lot of opportunity to ask questions. Excellent teacher!
← | →
Short course
In Nottingham and Timperley
Understand the importance of well-organized data!
-
Type
Short course
-
Level
Intermediate
-
Location
-
Duration
1 Day
-
Start date
Different dates available
Would you like to improve your skills and techniques in Microsoft Excel? With a little experience of Microsoft Excel or similar software, this course gives you a fast-paced introduction to the power of Excel's core features, giving you the knowledge to design and produce more efficient, better presented spreadsheets.
If you want to enjoy all these advantages, contact us through emagister.co.uk so we can give you the most relevant information about this course.
Facilities
Location
Start date
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 Excel to structure and analyse your data.
Extend the functionality of your spreadsheets by using more complex calculations.
Use Conditional Formatting on your worksheets.
Understand and apply Data Validation to control input.
Create Excel charts and control their formatting.
Manipulate database style lists of data with simple Pivot Tables and database functions.
Who is this course for?
With a little experience of Microsoft Excel or similar software, this course gives you a fast-paced introduction to the power of Excel's core features, giving you the knowledge to design and produce more efficient, better presented spreadsheets.
What do I need to know before attending?
It is assumed only that you have a skill level equivalent to that gained through attending the Excel Introductory Course.
vantage training ltd certificate of attendance
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.
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
-
I took the Excel Intermediate course and I can say now that it was good to learn more about Excel - I'm not afraid of the undo button anymore!
← | →
-
The trainer - Gill - was amazing and very knowledgeable on Excel.
← | →
-
The course content was well organised and presented. I still cannot believe how interactive this course was, I first thought it was going to be kind of hard. There was a lot of opportunity to ask questions. Excellent teacher!
← | →
Course rating
Recommended
Centre rating
Former Student
John Thomas
Joe Johnston
Camille Borland
Former Student
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
- Microsoft Excel
- Chart analysis
- Data Management
- Data Collection
- Microsoft Office
- Excel Formula
- Excel Sheet
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
Re-capping the Basics
The Excel Screen, the ribbon and other toolbars.
Basic formula entry and editing.
Standard Formatting
Formatting cells, Format painting, Autofill, Flash Fill, copy and paste.
Themes and Styles.
Taking Formulae Further
Absolute Cell References.
The IF() Function.
Lookup Functions.
Introducing Text Functions.
Taking Formatting Further
Conditional Formatting.
Extended Formats and Formulas.
Data Validation.
Using Comments.
Useful Tools and Features
Ranges of cells and using range names.
Smart Tags.
Checking Spelling, Find and Replace.
Charts & Graphs
Sparklines.
Creating and editing chart.
Saving a chart template.
Choosing from suggested charts.
Printing
Using Page Set-up and Print Preview.
Using page breaks.
Using automatic page numbering, headers and footers.
Database Functionality
Recapping the basics of sorting and filtering data.
Creating Excel Tables.
Using the Timeline slicer.
Introducing Pivot Tables and Pivot Charts.
Microsoft Excel Intermediate Training