_edited.png)
MICROSOFT EXCEL
Microsoft Excel is a great tool essential for managing and presenting data in today’s working environment. In this Introduction to Microsoft Excel training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually and present summary information in a consumable and professional format.
MICROSOFT EXCEL BEGINNER

Focus: This course has been curated for those with little or no knowledge of Microsoft Excel. Learn the basics of Excel.
Objective: By the end of this course, you will be able to;
-
Create worksheets and workbooks
-
Navigate through worksheets
-
Work with formulas, charts, formatting
-
Use command shortcuts and printing
The skills you take away from this course will give you the confidence to take on more advanced topics in Excel and Microsoft Power BI.
Pre-requisites: Windows PC, Microsoft Excel application (free), an email account and internet access.
Applicable Roles: Business Analyst, Financial Analyst, consumer of Excel workbooks.
MICROSOFT EXCEL INTERMEDIATE

Focus: This course is great for those who have some familiarity with Microsoft Excel or have taken our Microsoft Excel Basics class and would like to expand into Excel Intermediate skills with more robust functions and data manipulation techniques.
Objective: By the end of this course, you will be able to;
-
Extract data from databases using functions such as VLOOKUP
-
Organize and analyze raw data with Pivot Tables.
-
Use IF statement formulas as an advanced technique for data analysis.
-
Create dynamic report with Excel formulas
The skills learned in this course are what many employers expect.
Pre-requisites: Windows PC, Microsoft Excel application (free), an email account and internet access.
Applicable Roles: Metrics Analyst, Business Analyst, Financial Analyst etc.
ADVANCED MICROSOFT EXCEL

Focus: This course is great for those who have working experience in Excel or have completed our Microsoft Excel Basics and Intermediate courses and would like to learn the advanced features and functions of Excel.
Objective: By the end of this course, you will be able to;
-
Manipulate text with functions
-
How to work with filters and functions, pivot tables, pivot charts, power pivots
-
Record basic Excel macros to automate your actions
-
Create custom conditional formatting rules based on formulas
-
Use values across various spreadsheets
The skills learned in this course are what many employers expect.
Pre-requisites: Windows PC, Microsoft Excel application (free), an email account and internet access.
Applicable Roles: Metrics analyst, Advanced business analyst, Data Analyst Excel SME, Financial Analyst.
DATA TO VISUALIZATIONS WITH MICROSOFT EXCEL

Focus: The activities throughout the lesson would result in your first metrics dashboard/ visualization in Excel.
Objective: By the end of this course, you will be able to;
-
Profile your data in Excel
-
Transform your data, including changing data types and splitting data across columns
-
Manage data relationships between sets of data using VLOOKUP
-
Craft visuals and stories around your data using charts provided in Excel
Pre-requisites: Windows PC, Microsoft Excel application (free), an email account and internet access.
Applicable Roles: Metrics analyst, business analyst, data analyst who needs to build dashboards to support informed decision making.