Advanced Excel

Microsoft Excel is one of the most popular office productivity applications found in many workplaces. This course sets out the advanced skills that can be used to gather and manage data prior to analysis. Learners will be able to perform complex mathematical and statistical calculations, as well as to apply built-in analysis features in Excel to produce high quality management information and to use the advanced features in a spreadsheet application to improve productivity. Learners will also be able to create impactful visualizations for reporting purposes.

Learning Outcomes

By the end of this course, learners will be able to:

1. Import, categorise and enhance quality of data;

2. Prepare worksheets for data entry and calculations;

3. Manage data and navigate cells effectively;

4. Perform efficient analysis of data;

5. Perform advanced calculations with Excel functions;

6. Collaborate and review workbooks.

Mode of Delivery

Trainings are conducted in-person at 150 Orchard Road #06-14 Orchard Plaza Singapore 238841.

For more information on course details, please contact the training provider directly at enquiry@jci.edu.sg.