Data analysis using spreadsheet software is an essential skills for knowledge workers. It is not only how to arrange data in tabular layout, but also how to do computational analysis and presenting data in visual charts. For this training program, we use Microsoft Office Excel.

 

Generally, we divide the course program into two levels i.e. Basic Level and Advanced Level.

  • Worksheet and Excel table basics
  • Formula and name basics
  • Filtering, sorting, and conditionally formatting data
  • Charts and sparklines
  • Workbook and worksheet element protection
  • Excel tools
  • Advanced Excel formula
  • Summarizing, consolidating, outlining, validating, and import data
  • PivotTable, PivotChart, and slicers
  • What-if analysis

Apart from our standard course topics, we can customize course items based on your specific needs to match your actual use cases.