Microsoft Excel Advance

• Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets
• Use functions such as those associated with logical, statistical, financial and mathematical operations
• Create charts and apply advanced chart formatting
• Work with tables and lists to analyse, filter and sort data as well as create and use scenarios for different business situations
• Validate and audit spreadsheet data in Microsoft Excel using more functionality and addressing features
• Enhance productivity by working with named cell ranges and macros as well as to use linking, embedding and importing features to integrate data purposefully
• Perform collaborate editing such as to compare and merge spreadsheets as well as to apply spreadsheet security features effectively

What You'll Learn

This course aims to achieve the following learning outcomes:

• Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets
• Use functions such as those associated with logical, statistical, financial and mathematical operations
• Create charts and apply advanced chart formatting
• Work with tables and lists to analyse, filter and sort data. Create and use scenarios
• Validate and audit spreadsheet data
• Enhance productivity by working with named cell ranges and macros
• Use linking, embedding and importing features to integrate data
• Compare and merge spreadsheets
• Apply spreadsheet security features

Minimum Entry Requirement

This course is intended for participants with who have started using Microsoft Excel for some time or with very limited use of Microsoft Excel as well as for computer users who would like to learn Microsoft Excel from a basic to an advance level.