MICROSOFT EXCEL – INTERMEDIATE, DATA ANALYSIS & DASHBOARD (Remote Online)
HRD Corp Programme Number : 10001186518
Day one – Intermediate Excel course
In order to improve their work quality and productivity, students will be able to apply basic-intermediate features of Microsoft Excel.
This first day hands-on Microsoft Excel Training, led by an experienced trainer, offers a more efficient learning experience compared to the time-consuming trial-and-error method. Upon successful completion of this intermediate-level Microsoft Excel course, students will be prepared to progress to the second day, which focuses on Excel Dashboards.
Day Two – Dashboard Storytelling with KPI for Corporate Data
Through hands-on practice with an example database, students will learn how to create dynamic & interactive dashboards, allowing them to personalize their presentation style.
Click HERE to Download Brochure and Registration Form
Training Dates :
27th – 28th November 2024
Prerequisites
- Software: Participants should ideally have a copy of Microsoft Excel 2016 or later installed on their laptops.
- Basic Skills: Familiarity with working with files, including opening, closing, and saving, is required.
- Computer Literacy: In addition, a general understanding of Microsoft Windows and Microsoft Office concepts is beneficial.
- Prior Knowledge: To build upon their existing skills, students should have a basic grasp of Microsoft Excel.
LEARNING OUTCOME :
By the end of this training, the participants should be able to
- Customise and Enhance Workbooks in the Excel Environment
- Use common Functions and Formulas
- Work with Pivot Tables
- Present Data Using Charts
- Apply Conditional Formatting
- Create Dashboards
WHO SHOULD ATTEND
- User of Excel, who would like to improve their application of Excel, and how to analyze data, prepare powerful presentations, monitor KPI.
- Managers and Executives who have subordinates using Excel
- Employees who wish to improve Efficiency
METHODOLODY
This “MICROSOFT EXCEL – INTERMEDIATE, DATA ANALYSIS & DASHBOARD” workshop’s methodology is a combination of expert input, examples & hands-on practical exercises.
COURSE CONTENT
DAY 1
MODULE 1: CREATING & CUSTOMISING WORKBOOKS , FORMATTING DATA
- Create & customizing an excel workbook
- Linking Tabs
- Formatting data & Tables;
- Conditional Formatting
- Managing Rules
- Formulas
- Converting text to numbers
- Templates & practical uses and etc
MODULE 2: ANALYSING DATA IN THE TABLE
- Filtering data, Custom Auto filter
- Sorting data
- Logical functions IF, AND , OR
- Sumif, Countif, Nested ifs, Average A,
- Grouping, subtotals
- Sparklines
- Pivot Tables
- Vlookup, Hlookup
- Range Names
MODULE 3: OTHER FEATURES OF EXCEL
- Printing & Formatting
- Header & Footers
- Grouping Tabs
- Hyperlinks in the workbooks & outlook email
- Save an Excel workbook in earlier versions of Excel
- Worksheet & workbook protection
DAY 2
MODULE 4: CREATING & MODIFYING CHARTS
- Creating various charts
- Formatting charts
- Modifying charts & adding elements
- Additional Data series
- Changing Chart types
- Using Quick Analysis Tools
MODULE 5 : PREPARATION OF WORKBOOK FOR DASHBOARD
- Pivot table
- Charts
MODULE 6: CREATING THE DASHBOARD
- Linking dashboard information to workings
- Presenting Data using Dashboard
Ms. Sonia Ram CA(M), ACMA, CGMA, AAIA
PSMB Train-The-Trainer certificate no: TTT/20697
Click HERE to download Sonia Ram profile in PDF format
Sonia Ram, a Fellow Member (FCMA) of the Chartered Institute of Management Accountants (CIMA) since 2004 and a member of the Malaysian Institute of Accountants (MIA) since 2005, has had a long and distinguished career as a Management Accountant in well-known Malaysian and International companies.
She started her career in Finance as an auditor. Among her achievements are winning awards as a student , CIMA– 4th Place worldwide prize winner– Financial Reporting (IAS) Paper, & for AIA – Bronze Medal Winner – Statistics & Data Processing Paper.
From 1996-2002 she worked as a Lecturer in a Local College lecturing in Accounting, Statistics for Diploma & Undergraduate students of various disciplines.
Subsequently, from 2002 till 2019, she held managerial positions in various multinational corporations within the electronics manufacturing sector, handling a wide range of portfolios from Corporate Reporting, Costing, Budgeting & Forecasting, Performance improvement . She also spearheaded her team’s successful implementation of the new MRP system and W-desk setup to ensure Sox compliance, even conducting in-house training for the team.
Sonia possesses hands-on experience with the MS Office Suite and is a Certified MS Office Specialist for MS Excel 2016. She demonstrates a strong commitment to continuous learning by actively staying updated with the latest industry requirements.
In addition to her technical expertise, Sonia is also an HRD Corp Certified Trainer, qualified to deliver training programs
Comments from past participants :
“The trainer (Ms Sonia) was awesome. The course was well delivered and achieved the objective. I like the most on the Pivot table creation and the Dashboard Creation. Maybe the duration of the training should be 3 days instead of 2 days training” – Ms. Rubeena Binti Mohamad Sabidi, Assistant Manager, IT Budget Payment Management, Bank Muamalat Malaysia Berhad
“‘Ms Sonia is very helpful when asked questions; therefore, it was engaging and a very encouraging trainer. The dashboard building practice, which I think would be very useful for reporting” – Ms Masuyana Edris @ Eddy J.Tabak, QC Engineer, Steel Industry Sabah Sdn. Bhd.
You must be logged in to post a comment.