Overview
This program provides you with further skills in Microsoft Excel. You will learn how to identify ranges with names, protect worksheets and files, apply functions, link worksheets, audit files and create templates.
Content
- Use Excel time savers
- Create advanced charts and sparklines
- Attach comments to cells
- Create efficient formulas with functions, relative and fixed cell references and range names
- Troubleshoot formulas with worksheet auditing
- Use data validation for data accuracy
- Work with multiple worksheets
- Create calculations across worksheets and workbooks
- Protect cells, worksheets and workbooks
- Create worksheet templates.
Learning Outcomes
Participants should be able to:
- Develop worksheets using specialised features and commands
- Trace cells using worksheet auditing
- Develop and modify multiple sheets
- Link data from different files
- Lock cells and protect an entire workbook
- Create worksheet templates.