Excel - Intermediate

This hands-on 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.

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.

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.