Data Analytics with Microsoft MS Excel 365 Level 1
Training Provider: APPS PTE. LTD.
Course Reference: TGS-2024049672
S$240
Original: S$480
Save S$240
About This Course
This course provides learners with a foundational understanding of business statistics and data analytics using Microsoft MS Excel. By the end, learners will be able to apply Excel functions to process, collect and format data. Besides useful Excel formula, learners will explore Excel’s tools for data sorting, filtering, and visualizing with charts and graphs, along with techniques for handling different types of data sources.
What You'll Learn
By the end of the course, learners should be able to do below:
LO1: Understand business statistics in the role of data analytics
LO2: Identify the relevant data needed to analyze and address a problem effectively
LO3: Use Excel for data collection and formatting
Topics covered:
• The data analytics lifecycle
• Importance of data in decision-making
• Role of statistics in data analytics
• Descriptive statistics vs Inferential statistics
• Business statistics: SUM, AVERAGE, MIN, MAX, COUNT, MEDIAN, MODE, STDEV, VAR
• Problem Definition and Data Collection
• Understanding business context and objectives
• Determining key metrics and success criteria
• Excel basic data entry and navigation
• Autofill Data
• Create Formulas in a Worksheet
• Reuse Formulas
• Conditional Formula: IF, SUMIF and COUNTIF
• Data formats and structures
• Working with Lists - Sorting and Filtering
• Formatting cells
• Apply Number Formatting
• Merge Cells and Wrap Text
• Basic Excel formulas and functions
• Data import and export
• Data Segregation using Text to Column
• Deleting Every Other Row
• Insert Text to Column
• Transposing Data
• Apply Page Break, Split and Freeze Panes
• Creating 2D and 3D visualizations: Charts and graphs
• Collecting different types of data: First Party, Second Party and Third Party
LO1: Understand business statistics in the role of data analytics
LO2: Identify the relevant data needed to analyze and address a problem effectively
LO3: Use Excel for data collection and formatting
Topics covered:
• The data analytics lifecycle
• Importance of data in decision-making
• Role of statistics in data analytics
• Descriptive statistics vs Inferential statistics
• Business statistics: SUM, AVERAGE, MIN, MAX, COUNT, MEDIAN, MODE, STDEV, VAR
• Problem Definition and Data Collection
• Understanding business context and objectives
• Determining key metrics and success criteria
• Excel basic data entry and navigation
• Autofill Data
• Create Formulas in a Worksheet
• Reuse Formulas
• Conditional Formula: IF, SUMIF and COUNTIF
• Data formats and structures
• Working with Lists - Sorting and Filtering
• Formatting cells
• Apply Number Formatting
• Merge Cells and Wrap Text
• Basic Excel formulas and functions
• Data import and export
• Data Segregation using Text to Column
• Deleting Every Other Row
• Insert Text to Column
• Transposing Data
• Apply Page Break, Split and Freeze Panes
• Creating 2D and 3D visualizations: Charts and graphs
• Collecting different types of data: First Party, Second Party and Third Party
Entry Requirements
Can understand English
Age group suitable for all
Must have basic computer knowledge
No experience required
Minimum education level: ‘O’ levels or similar level
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 APPS PTE. LTD.
This course provides a structured learning journey for people looking to develop expertise in 3D mod...
1. Write computer program in Python language
2. Identify and employ appropriate statistical algorit...
This course equips participants with the skills to design and develop dynamic websites tailored to v...