MICROSOFT EXCEL – INTERMEDIATE, DATA ANALYSIS & DASHBOARD
HRD Corp Programme Number : 10001186518
If you are looking for Remote Online training for “MICROSOFT EXCEL – INTERMEDIATE, DATA ANALYSIS & DASHBOARD”, please CLICK HERE
INTRODUCTION
Day one – Intermediate Excel course
Students will be able to apply basic-intermediate features of Microsoft Excel to improve their work quality and productivity.
With this 1-day hands-on Microsoft Excel Training under the guidance of an experienced trainer, students can pick-up more easily than going for trial-and-error basis all by themselves in a time consuming manner. By completing this intermediate level of Microsoft Excel course, students will also be able to proceed to the 2nd day of the course i.e. Excel Dashboards
Day Two – Dashboard Storytelling with KPI for Corporate Data
The student will learn hands on with an example database , on how to create a dynamic & interactive Dashboard in their own presentation style.
Click HERE to Download Brochure and Registration Form
Training Dates :
24th – 25th September 2024 (Dorsett Grand Subang, SUBANG JAYA, Selangor, Malaysia)
Requirements
Participants should have a copy of Excel 2016 onwards already installed in their laptops & be familiar with working with files: opening, closing and saving files.To ensure success, each student is expected to have a general knowledge of Microsoft Windows and Microsoft Office concepts & Basic 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 is a Fellow Member (FCMA) of the Chartered Institute of Management Accountants – CIMA since 2004, and a member of Malaysian Institute of Accountants, MIA since 2005.
Sonia has had a long and distinguished career as a Management Accountant in a number of 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 has worked for various Electronics Manufacturing MNCs in Managerial positions handling a wide range of portfolios from Corporate Reporting , Costing, Budgeting & Forecasting , Performance improvement . She had also actively led her team into the new MRP migration & W-desk Setup for Sox Compliance in her company conducting in-house training for the same.
She has hands on experience on MS Office Suite & is a Certified MS office specialist for MS Excel 2016 & is always working to update herself with the latest requirements of the profession.
Sonia is an HRD Corp Certified Trainer having obtained this certification in June 2018.
You must be logged in to post a comment.