Microsoft Excel Advance
About This Course
• 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
• 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
Entry Requirements
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.