2024 HIKO Excel Intermediate: Next-Level Data Analysis

Why this Course?

Building upon basic knowledge, this course introduces more complex Excel functions such as VLOOKUP, XLOOKUP, and IF functions. It's designed for those who want to
elevate their data analysis capabilities. You'll learn sophisticated techniques for manipulating and interpreting data, crucial for roles such as business analysis, project management, and academic research.

Learning Objectives:
Understand and apply intermediate Excel functions and formulas for data management such as:
■ XLOOKUP & VLOOKUP Functions
■ Using Analyse Data Features
■ SUMIF, COUNTIF & IF formulas
■ Converting Data
■ Combining and Splitting Data
Understand how to leverage AI tools like ChatGPT for predictive analysis and data forecasting in Excel.

If you have any questions, please contact Florida - florida@tuputoa.org.nz 

We can't wait to support and provide digital upskilling for our communities!