- Home
- Training
- Business Productivity Tools
- Data Analytics
- Data Analysis Fundamentals using Excel
Training with Iverson classes
Training is not a commodity – all training centres are not the same. Iverson Associates Sdn Bhd is the most established, the most reputable, and the top professional IT training provider in Malaysia. With a large pool of experienced and certified trainers, state-of-the-art facilities, and well-designed courseware, Iverson offers superior training, a more impactful learning experience and highly effective results.
At Iverson, our focus is on providing high-quality IT training to corporate customers, meeting their learning needs and helping them to achieve their training objectives. Iverson has the flexibility to provide training solutions whether for a single individual or the largest corporation in a well-paced or accelerated training programme.
Our courses continue to evolve along with the fast-changing technological advances. Our instructor-led training services are available on a public and a private (in-company) basis. Some of our courses are also available as online, on demand, and hybrid training.
MS10994B : Data Analysis Fundamentals using Excel
TRAINING ONLY
Overview
The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
Audience Profile
This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.
Prerequisities
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Advanced working knowledge of Excel spreadsheets including formulas.
At Course Completion
After completing this course, students will be able to:
- Create an Excel report
- Create an Excel table
- Create a pivot table and pivot chart
- Create a dashboard and analyze data
- Create Hierarchies
- Create an Excel data model and connect to external data
Course Outline
| Course Information |
|---|
| DURATION 2 Day |
| Schedule |
|---|
30 - 31 Jan 2023 13 - 14 Apr 2023 15 - 16 May 2023 22 - 23 Jun 2023 24 - 25 Aug 2023 26 - 27 Oct 2023 14 - 15 Dec 2023 |
PMP, Project Management Professional (PMP), CAPM, Certified Associate in Project Management (CAPM) are registered marks of the Project Management Institute, Inc.