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.
Re-capping the Basics
The Excel Screen, the ribbon and other toolbars.
Basic formula entry and editing.
Formatting cells, Format painting, Autofill, Flash Fill, copy and paste.
Themes and Styles.
Taking Formulae Further
Absolute Cell References.
The IF() Function.
Introducing Text Functions.
Taking Formatting Further
Extended Formats and Formulas.
Useful Tools and Features
Ranges of cells and using range names.
Checking Spelling, Find and Replace.
Charts & Graphs
Creating and editing chart.
Saving a chart template.
Choosing from suggested charts.
Using Page Set-up and Print Preview.
Using page breaks.
Using automatic page numbering, headers and footers.
Recapping the basics of sorting and filtering data.
Creating Excel Tables.
Using the Timeline slicer.
Introducing Pivot Tables and Pivot Charts.
It is assumed only that you have a skill level equivalent to that gained through attending the Excel Introductory Course.
This course has been specifically designed for companies training their employees.
Where do you want to study this course?
Altrincham, WA14 1TD, Nottingham, NG13 8PF, Can be taught anywhere in Central England, North West England, Yorkshire And Humberside
During the day or In the evening
Customised to suit your needs
Certificate of Attendance
This course currently has no reviews.Write a review
Ask a question