Excel Analytics

Excel Analytics

Best suited for business users of Microsoft Excel with the need to do basic analyses and visualizations.

Duration:
3 days

Use Excel to make the most of your data.

This module will enable professionals looking to unlock latent value in their data and make the most of a powerful, familiar and intuitive software package.

unsplash-image-1K6IQsQbizI.jpg

Smarter data analysis

Excel is everywhere and often used for quick descriptive and diagnostic analyses. An introductory course for business users to conduct basic data analysis using descriptive methods, and visualization using charts, sparklines, & conditional formatting.

unsplash-image-8xAA0f9yQnE.jpg

Unlocking insights

Using Microsoft Excel, participants will learn the various powerful features of spreadsheets before using them in combination with statistical techniques to explore and discover relationships present in their data.

unsplash-image-eveI7MOcSmw.jpg

Grow analytics skill

Excel for Data Analytics introduces participants with little-to-no statistical or software expertise to basic statistical and visualisation tools using the intuitive and popular features in Microsoft Excel, such as Functions, Charts and PivotTables.

Learning Outcome

Upon completion, participants should be able to demonstrate each of the following;

  1. Use PivotTables and Functions effectively to summarise and augment Data in Microsoft Excel
  2. Visualize Data & create dashboards for reporting with Microsoft Excel
  3. Assess Data distributions and statistical relationships with Microsoft Excel

Learning Path

Data Storytelling is one of the modules under the CADS Enterprise Data Practitioner (EDP) Programme. EDP is an eight-day training program that super-charges Business Intelligence analysts with new skills to analyze and communicate insights effectively. Best suited for business users of Microsoft Excel with the need to do basic analyses and visualizations.

CADS Certification

Each exam in this program certifies job-ready knowledge and skill. Those that pass all are recognized as being able to distil insight from data and communicate its value to a decision-maker. Enter the world of Data Professionals.

MAX AI