Data Analytics with Excel
About This Course
Unleash the power of Excel in data analytics with our comprehensive, WSQ-endorsed course. From basic data manipulation and formulas to advanced techniques like pivot tables and data visualization, this course offers a full spectrum of skills. Practical exercises and real-world case studies ensure that your learning is rooted in applicability, equipping you with the tools to analyze large datasets and generate actionable insights.
By the end of this course, you’ll be proficient in using Excel for various data analytics tasks. You'll know how to clean, analyze, and visualize data, and you'll be adept at using Excel's advanced features to streamline your analytics process. Whether you're a business analyst, a data enthusiast, or someone aiming to make better data-driven decisions, this course prepares you for the challenges of today’s data-centric world.
What You'll Learn
- extract and validate data using Excel and Power Query
- apply basic data analytical techniques using Excel
- generate reports to identify trend and risk using Excel
- apply advanced data analytical tools available in Excel
- perform hypothesis testing using Excel
Course Outline:
Topic 1 Getting Started with Excel
- Explore Excel user interface
- Enter and validate data for analysis using Excel Power Query
- Data management with Excel
- Use formulas and functions
Topic 2 Basic Data Analysis using Excel
- Use LOOKUP and REFERENCE functions to integrate information
- Use IF functions to analyse data
- Basic statistics and use statistical functions
Topic 3 Basic Data Visualisation using Excel
- Create chart and reports to identify trends in data
- What is regression?
- Create reports on regression and risk analysis
Topic 4 Advanced Data Analysis using Excel
- Use PivotTables and PivotCharts to identify patterns across multiple datasets
- Perform what-if analysis using Scenario Manager, Goal Seek and Data Table
- Data governance and security with Excel
Topic 5 Hypothesis Testing with Excel
- What is hypothesis testing?
- Apply hypothesis testing techniques in Excel
Entry Requirements
Knowledge and Skills
• Able to operate using computer functions
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
• Positive Learning Attitude
• Enthusiastic Learner
Experience
• Minimum of 1 year of working experience.