Microsoft Excel Advanced
Who is the course for?
This is a task based, practical course designed for professional Excel users who need to acquire advanced skills and to customise Excel. Participants will explore the capabilities of some of the powerful calculation and anaylsis functions
Is this course suitable for me?
Take the Skills quiz
Pre-requisites
To attend this course you must to able to select non-adjacent ranges (such as data from columns A, D and F), use logical and lookup functions, create and manage linked formulas, sort and filter data in lists, and create and modify charts.
What are the objectives of the course?
By the end of the course, you will be able to:
Use modelling and analysis tools
Save views, scenarios and report settings to print compound reports quickly
Create, protect and use workbook templates
Share workbooks with other users and maintain a history of changes
Customise Excel to suit your way of working
Record and run a macro to automate repetitive tasks
What does the course cover?
Data analysis and modelling tools: Finding an answer with Goal Seek; using Solver; setting up a data table; compare and summarise results with scenarios; saving different solutions
Views and reports: Defining and saving different views of the same workbook; saving scenarios and solver solutions as views; preparing a composite report; showing views; printing reports
Sharing a workbook: Saving and updating changes; keeping a change history; viewing and reviewing changes; merging copies of the same workbook; preparing copies of a workbook to be reviewed; troubleshooting merged workbooks
Creating templates: Why use templates?; what a template can contain; where templates are sorted; special templates, such as Book.XLT and SHEET.XLT; special locations for templates; creating formatting styles to store with a template
Customising Excel: Customising toolbars and menus; adding and removing commands from toolbars; creating a new toolbar; Excel options; calculation options
Automating repetitive tasks: Preparing to record a macro; naming a macro; recording commands; assigning a macro to a keyboard shortcut or toolbar button; recording relative or absolute references; editing a macro; making macros more efficient
How long does the course last?
1 day
