Overview
This hands-on Intermediate Excel course lays the foundations for building a stronger, more advanced understanding of Microsoft Excel and will coach you to be confident with Microsoft Excel functions commonly used in the workplace. Learn how to identify ranges with names, use workbooks with multiple sheets, protect worksheets and files, link worksheets, audit files and create templates. Work interactively with functions such as IF and VLOOKUP.
To benefit from this short course, you should be a confident user of Microsoft Excel. This course 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.
If you are experienced in creating and modifying spreadsheets, and can work with basic formulas and functions, the Intermediate Excel training course will help you to build additional skills in the software.
Who Will Benefit
This course enables participants to improve their efficiency by learning ways to better analyse, organise and present data using Excel spreadsheets.
This course is particularly useful if you need to:
- Use more complex formulas and functions
- Use sophisticated formatting techniques in worksheets
- Filtering, sorting, and grouping data or subsets of data
- Work interactively with IF and VLOOKUP functions
- Link worksheets or work with multiple worksheets
- Present concise visual reports of complex data
Content
The Intermediate Excel course offers the following training 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
After completion of the Intermediate Excel course participants will 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.
