2 days - Office 365 - Excel 2021 and Data Analytics - level 1
About This Course
This course "2 days – Office 365 – Excel 2021 and Data Analytics – level 1" is designed to provide learners with a solid foundation in using Excel for data analysis. By the end of the course, learner will understand business statistics and how to apply them in decision-making. They will be able to identify relevant datasets, manage and analyze data using Excel’s basic formulas and functions, and collect data from various sources. Learners also gain skills in preparing reports, handling data from different file types, and troubleshooting common errors in Excel.
What You'll Learn
LO1: Able to define Business Statistics and its uses
LO2: Able to identify the Dataset that can provide the necessary information to answer the business questions
LO3: Able to use Excel to manage data, basic formulas and functions to compute results
LO4: Able to collect data, gather data from system and external sources
Topics Covered:
• Data and Information
• Data Analysis Process and its stages
• Business Statistics examples and its uses in decision making – mean, mode, median, range, standard deviation
• Structured and Unstructured Data
• Common Sources of Data
• Qualitative vs Quantitative Data
• Workbook and Worksheet Structure, insert and delete rows, columns, worksheets
• Data Types in Excel, moving around in Excel, different types of mouse pointer, shortcuts
• AutoFill, Ctrl+B,I,U,5 , borders, text alignment, use of format painter for quick formatting
• Basic Statistical Functions – sum, median, mode, max, count, countA, countblank, round
• Cell Referencing, A1, $A$1, A$1, $A1 in Formulae
• vlookup functions
• if functions
• Working with Excel Tables – auto filter, sizing handle, total
• Basic Data Visualization using Conditional Formatting and Graphs
• Freeze pane for long reports, Sorting and Filtering
• Page Layout and Report Output
• Types of Errors
• Data Analysis pipeline
• Get data from Worksheets and other Workbooks
• CSV files, Text Files
• External Files
Entry Requirements
• Minimal education qualification is PSLE with 1 year of relevant working experience
• Speak, listen and read English at a proficiency level not lower than the WPL Level 3, and manipulate numbers at a not lower than the WPN Level 3.