Course description
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.
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.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.