Career & Professional
Development Centre

Data Analysis Using Microsoft Office Excel 365

Key Information

No of Hours

7

This training is designed to enable participants to apply intermediate and advanced functions of Microsoft Excel to increase productivity, enhance spreadsheets with charts & formulas and streamline their work. It is designed to provide the participants with comprehensive knowledge and hands-on practice.The training covers reasonably in depth which includes creating and formatting spreadsheets, using formulas and functions, and working with charts and graphs. The participants will also learn advanced features of Excel, including data validation, pivot tables, and conditional formatting. 

  • Solve simple mathematics problems using Microsoft Excel 365.
  • Apply Microsoft Excel 365 filters and functions for data analysis.
  • Generate tables and charts for data visualisation.
  • Analyse and interpret data using statistical analysis tools in Microsoft Excel 365.