Main learning outcomes

Successful candidates will be able to use enhanced spreadsheet capabilities to produce better reports with deeper data analysis. After passing this module, candidates will feel confident managing complex data with spreadsheets and collaborating with others. They will be able to:

• Understand advanced formatting options, including conditional formatting and customized formatting
• Recognize which functions to use in formulas, and troubleshoot errors
• Identify the correct chart to display a specific data set, and create or edit such a chart
• Know how to analyze, validate, audit, and protect data
• Understand time-saving features such as linking data, paste special, filters, and macros.

Contact us