Track, analyze, and then forecast efficiently and accurately using Microsoft Excel.
This course focuses on essential features and best practices that forecasting professionals can use. Learn how to import your sales data into Excel. Then, see how to clean up that data by removing redundancies, fixing incorrect information, and applying formatting. Next, step through the various methods of analysing data in Excel, from filtering and sorting to using Quick Analysis and slicers.
Additionally, explore how to create a leaderboard, spot trends, forecast sales, create dashboards.
The aim of this course is to provide targeted MS Excel tuition to meet the requirements of a job in Sales, Account Management, Business Development, Human Resource or Marketing.
The course focuses on how to use Excel, to effectively save man-power shortages, increase productivity, improve job efficiency, reduce expenses on costly 3rd party software such as inventory system, sales forecasting, data analysis, account and more.
0900-1300
Module 1: Productive Features in Excel
a) Understanding Named Ranges with Examples
b) Creating Dynamic Reference with Named Ranges
c) Working with Functions You Have Never Worked With
d) Useful Short-cuts, Productive Tricks and Navigating Efficiently in Excel
e) Practice 1
Module 2: Advanced Data Importing and Cleaning
a) Introduction of Concept of E.T.L. in Power Query
b) Showing and hiding outline details
c) Grouping data
d) Creating, editing subtotals
e) Removing outlining and grouping
f) Grouping and ungrouping data
g) Expanding and collapsing data
h) Sorting, filtering data
i) Practice 2
1300-1400 Lunch Break
1400-1700
Module 3: Analysing Data with PivotTable
a) Analysing Data with PivotTable,
b) Slicer and Pivot Charts
c) Create a PivotTable
d) Start with Questions End with Structure
e) Create PivotTable Dialog Box
f) PivotTable Fields Pane
g) Summarize Data in a PivotTable
h) Show Values as Functionality of a PivotTable
i) Filter Data by Using Slicer
j) Slicers
k) Insert Slicers Dialog Box
l) Analysing Data with PivotChart
m) Creating PivotChart
n) Applying a Style to a PivotChart
o) Practice 3
0900-1300
Module 4: Understanding Array Formulas
a) What is an array in Excel?
b) What is an array formula?
c) How to enter an array formula (CTRL+SHIFT+ENTER)
d) How to evaluate portions of an array formula (F9 key)
e) Single-cell and multi-cell array formulas in Excel
f) Excel array constants
g) AND & OR operators in array formulas
h) Double unary operator in array formulas
i) Practice 4
Module 5: LOOKUP AND REFERENCE FORMULAS
a) Advanced Data Lookups Techniques
b) Limitation of VLOOKUP
c) Replacing VLOOKUP with INDEX and MATCH Functions for Data Lookups
d) Using XLOOKUP (Available only for Version 2021 and 365)
e) Practice 5
1300-1400 Lunch Break
1400-1700
Module 6: Advanced Data Analysis
a) Data Validation with Formulas
b) Conditional Formatting with Formulas
c) Understanding Number Formatting in Excel
d) Practice 6
MODULE 7: Automation With Macros
a) Introduction to Macro Programming
b) Recording and Running Macros
c) Editing and Debugging Macros
d) Creating Task Automation Examples
e) Conditional Statements and Loops
f) Creating User Forms and Dialog Boxes
g) Error Handling Techniques
h) Practice 7
For Details About The Course
TFG Bliss Innovations is an HRD Corp-registered, corporate training provider based in Kuala Lumpur, specialising in Communication, Business Language, and Digital Transformation program for Malaysian organisations.
At TFG Bliss Innovations, we don’t just train – we empower businesses to thrive in an evolving corporate landscape
