Course description
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
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 graphs.
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.
Using Slicers and the Timeline Slicer.
Get & Tranform (Query)
Power View.
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.
Protecting Cells.
Protecting Worksheets.
Protecting Workbooks.
What-If Analysis
Goal Seek and Solver.
Scenarios.
Data tables.
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.