Excel Level 3
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 analysis facilities.
To attend this course you must be able to select non-adjacent ranges (such as data from column 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.
- 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
Data Analysis and Modelling Tools:
Finding an answer with ‘Goal Seek’; using solver; setting up a data table; comparing and summarising 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, updating and reviewing changes; keeping a change history; merging copies of the same workbook; preparing copies of a workbook to be reviewed; troubleshooting merged workbooks.
Conditions and benefits of templates; where templates are stored; special templates (such as BOOK.XLT and SHEET.XLT); special locations for templates; setting format styles within templates.
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/editing a macro; recording commands; assigning a macro to a keyboard shortcut or toolbar button; recording relative or absolute references.