Data Analysis using Excel: Power User (SF)
Training Provider: NTUC LEARNINGHUB PTE. LTD.
Course Reference: TGS-2024046414
S$360
Original: S$1,200
Save S$840
About This Course
This course is intended for anyone who wants to stretch their data analysis capabilities using Microsoft Excel starting with a block of data to a table of data, going beyond just functions and formulas, and picking up more advanced capabilities leading to data preparation, data modelling and data visualisation using power query, power pivot, pivot charts, conditional formatting, slicers, timelines and dashboards.
What You'll Learn
• Familiarise with the use of tables in Microsoft Excel
• Find out more about Microsoft Excel’s functions such as the conditional and lookup functions
• Learn the basic concepts of data preparation using Power Query
• Discover useful concepts of data modelling using Excel Data Model
• Create calculated columns and measures using Power Pivot
• Explore data visualisation using Microsoft Excel
• Find out more about Microsoft Excel’s functions such as the conditional and lookup functions
• Learn the basic concepts of data preparation using Power Query
• Discover useful concepts of data modelling using Excel Data Model
• Create calculated columns and measures using Power Pivot
• Explore data visualisation using Microsoft Excel
Entry Requirements
It is recommended that the participant should have used or have basic working knowledge of Microsoft Excel.
Course Details
Back to All Courses
Note: To apply for this course, visit the SkillsFuture website or contact the training provider directly.
More Courses from NTUC LEARNINGHUB PTE. LTD.
• Evaluate organisational requirements and business needs for cloud solutions
• Evaluate new a...
• Evaluate organisational requirements and business needs for cloud solutions
• Evaluate new a...
• Discuss foundation concepts of cybersecurity principles.
• Explain how organizations respond ...