Course Information
Till today, MS Excel remains as the most popular and appealing software application for everyone and businesses globally to rely on due to its user friendliness and effectiveness – from managing daily sales, operations, forecasting, monitoring profit & loss, preparing charts & reports, supporting decision-making and more.
Our “Smart Analytics for Startups & Businesses – Excel Track” is specially crafted to help you in mastering MS Excel to maximize your businesses, operations or personal finance! We value add your learning with hands-on business scenarios and analysis.
Tailor for everyone from startups, SMEs, working professionals, aspiring entrepreneurs to individuals and students.
Learning Outcomes
This course is tailored to enable participants a hands-on experience on how to use a variety of MS Excel functions and features to perform business data analysis and gathering insights. Participants will learn commonly used intermediate and advanced functions & features for greater efficiency and supporting decision-making in workplace, business or personal needs.
Course
Schedule
Monday, 9:00 am to 6:00 pm
Date: 18 to 19 June 2020
Time: 9am to 6pm
Lesson Plan
This course consists of 2 modules:
- Combining Multiple Functions
- Utilizing Sort, Filter, Advanced Filter
- Working with Conditional Logic functions (If, Ifs, And, Or, Not)
- Using Conditional Summary Functions (Sumif, Averageif, Countif, Sumifs, Averageifs, Countifs)
- Slicing & Dicing Data with PivotTables (PivotChart, Slicer, Filter, Calculated Field)
- Mastering Lookup functions (Vlookup, Hlookup, Index, Match)
- Getting started with Business Data Analysis Project (teamwork)
- Predicting & Decision-Making with What-If-Analysis (1Variable & 2Variable Data Table, Scenario, Goal Seek, Solver)
- Protecting Worksheets & Workbooks
- Automation with Macros and Button
- Complete and Present your Business Data Analysis Project (teamwork)
Certification
A Certificate of Performance will be awarded to participants who achieve at least 75% attendance and pass assessments.
Course Fees
| Applicants / Eligibility | Fees |
|---|---|
| Singapore Citizens (SC) below the age of 40 years | $202.23 |
| Singapore Citizens (SC) aged 40 and above | $76.23 |
| Singapore Permanent Residents (PR) | $202.23 |
| Enhanced Training Support for SME Scheme (for SC & SPR) | $76.23 |
| Others (and Repeat Students) | $674.10 |
| Full Course Fee (Before GST) | $630.00 |