Excel Intermediate with AI

Aug 26, 2026

Course Objectives

  • Develop and apply essential data analysis statistical techniques to perform data analysis, identify trends, and make data-driven decisions.
  • Utilise AI powered tool "Analyze Data" to ask questions, generate charts, and find trends and patterns in the data.
  • Identify and manage geographical data types.
  • Utilise "Forecast Sheet" command to forecast future outcomes based on historical data and trends.

Learning Outcomes

  • Manage cell ranges using defined names.
  • Calculate conditional summary statistics and formulas using multiple criteria.
  • Round values and apply date related functions.
  • Split data into multiple columns.
  • Sort, filter and remove duplicate records in a data range.
  • Manage data set using Table.
  • Validate data entry.
  • Create dual axis charts and add linear trendline.

Reward

  • E-Certificate of Completion by Kaplan will be awarded upon completion of the course
Register Here
Share