– Master Data Interpretation & become expert data analyst using Microsoft Excel 2016/2019/365 Users
Data Analysis is the process of systematically inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information and conclusions, as well as supporting decision-making. Microsoft Excel 2016/2019/365 Users provides useful tools needed in doing data cleansing, transforming and analyzing such as Text to Columns, remove duplicates, Flash Fill, Quick Analysis and many more.
This 2-days course will train participants how to prepare source data for effective data analysis, use AutoFill to generate data series, use Text to Columns Wizard to convert dates, create dynamic tables and charts that can be updated automatically using a button, lookup and extract data from a table, consolidate multiple set of data into a summary worksheet, apply conditional rules to format data, perform What-if Analysis with Scenario Manager, Goal Seek and Data Table, using new features such as Forecast Sheet, Quick Analysis, Flash Fill, Recommended Charts and new Charting Tools.
This course will equip participants with essential skills they need for data analysis using Microsoft Excel 2016/2019/365 Users. Participants will learn how to use Excel features more effectively and wisely to analyze their company data quickly and more efficiently.
Preparing Data for Analysis
Using Quick Analysis Tools
Using Conditional Formatting
Using Sparklines to Show Data Trend
Using Excel Table for Data Analysis
Using Functions for Data Analysis
Adding Automatic Subtotals and Outline
Using Data Consolidate
Using Data Validation and Protection
“Course is in good pace and I learnt many useful features which I can apply to my work quickly.”
~ NEA
“Valene is an effective trainer who highlights the key points and illustrate using good examples.”
~ FairPrice
Classroom based demonstration with hands-on Exercises using Microsoft Excel 2016/2019/365 Users.
Valene Ang is an experienced certified IT trainer with over 19 years of experience in training professionals from various organisations. She received her degree in Business Computing from the University of Southern Queensland, Australia. Her Professional qualifications including Advanced Certificate in Training and Assessment (ACTA) and Master Instructor for Microsoft Office Specialist (MOS).
Valene has extensive training and course development experience. She customized many Microsoft Office training courses for corporate clients, assist them in business data analysis and provide dynamic report solutions. Her training focuses on 100% hands-on exercises as well as providing practical solutions to real life Excel related problems.
Valene conducted many Microsoft Excel, PowerPoint and Word training in Singapore, Malaysia and China. Her corporate clients include CPF, PUB, MOM, PSA, IRAS, DFS, MOE, NEA, DHL, SingTel, Singapore Expo, Changi Airport Group, SPRING, FairPrice and many more.