What's In It For Me
Understand what is data analytics and how Microsoft Excel can be used as a data analytical tools in the office.
Course Overview
The main purpose of the course is to give learner the ability to add analysis capabilities to Excel spreadsheets and to provide learner with a foundation to learn about more advanced data analytics with Excel or Power BI.
Who Should Attend
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.
Course Duration
2 Days / 16 Hours (including 2 hrs of assessment)
Course Outline
Reporting in Excel
- Filtering and Formatting Data
- Charts
Excel Tables
- Excel Data Tables
- Summarizing Data
Pivot Tables and Pivot
- Pivot Tables
- Pivot Charts
- Editing Pivot Tables and Pivot Charts
Dashboards
- Creating a Dashboard
- Data Analysis in Excel Pivot Tables
Hierarchies
- Hierarchies
- Time Data
The Excel Data Model
- Using an Excel Data Model
- External Data
Explore an Excel Data Model
- Add Multiple Tables
- Create Relationships
- Add External Data
Mode of Assessment
Written and Practical
Certification Obtained and Conferred by
Awarded NTUC LearningHub Certificate of Completion
Categories
More Information
- (Local Institution) NTUC LearningHub
Add a review