Data Analytics with Microsoft MS Excel 365 Level 2
About This Course
This course provides learners with a deeper understanding of business statistics and data analytics using Microsoft MS Excel. By the end, learners will be able to apply Excel functions to analyse, interpret and clean data. Besides useful Excel formula, learners will explore powerful Excel’s tools like Pivot Table, Solver, Goal Seek and VLOOKUP, XLOOKUP for data analysis and interpretation. They will also learn how to clean data using functionalities like Data Validation, Conditional Formatting and text formula.
for data sorting, filtering, and visualizing with charts and graphs, along with techniques for handling different types of data sources.
What You'll Learn
LO1: Explain advanced business statistics in the role of data analytics
LO2: Interpret relevant data to locate process improvement opportunities
LO3: Use Excel to clean data
Topics covered:
• Recap of the data analytics lifecycle
• Importance of cleaning data in decision-making
• Role of advanced statistics in data analytics
• Business statistics and Related functions for statistics: SUMIF, COUNTIF, IF, VLOOKUP, HLOOKUP, XLOOKUP, RAND, RANDBETWEEN
• Using the VLOOKUP HLOOKUP, XLOOKUP
• Using formula RAND, RANDBETWEEN
• Financial Functions
• Using Logical Functions
• More complicated uses of Conditional functions IF, SUMIF and COUNTIF
• Calculate data across worksheets Advanced Functions
• Using Links
• Protecting Sheets
• Working with Charts
• Creating Charts
• Modifying Charts
• Working with Sparklines
• Goal Seek
• Solver
• Pivot Table
• Data Validation
• Creating Range Names
• Modifying Range Names
• Creating Range Names
• Modifying Range Names
• Using Range Names in Formulas
• Text functions TRIM, CONCAT, LEFT, RIGHT, LEN
• Using Text and Date Functions
• MATCH and INDEX Functions
• CHOOSE, SWITCH Functions
• Creating a Custom Format
• Create a custom number format
• Conditional Formatting
• Creating Conditional Formatting
• Modifying Rules
Entry Requirements
Can understand English
Age group suitable for all
Must have some Excel experience, preferably completed Excel Level 1
Minimum education level: ‘O’ levels or similar level