Excel Intermediate with AI

Jun 7, 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