EXCEL for Data Analysis and Reporting (VIRTUAL LIVE-STREAM)
  • S$720
  • 2-days
  • Intermediate Level

Important Notice for Virtual IT Application Delivery
• Virtual delivery of application courses can be difficult for learners to follow. If they only have a single device using the monitor for one-half IT application, and the Zoom broadcast on the other; will it challenging to both view and practice at the same time.
We strongly recommend that potential leaners have two devices: one to watch from, the other to practice from.
• Some working knowledge of Zoom and basic IT skills is preferred for these types of courses.
• For further information please either: click on this Quick Checklist, or click on the eGuide, or contact us.

About this Virtual Live-Stream Course

Excel is a powerful Data Analysis and Reporting tool that provides all the data crunching power including many new features such as forecasting functions to predict future values, multi-select slicer for data filter, automatic table relationship detection, PivotChart drill-down buttons to zoom into details and etc. The proper use of Excel features can greatly enhance the design of your report and help you to analyze your organization’s data more effectively.

If you find yourself struggling with duplicated data, or require an efficient way to analyze and retrieve your data from Excel table, if you deal with budgets, P&L, Sales or other administrative data and need to display the data using interactive Excel charts and reports, if you need to present your data using impressive report format, this is the right course for you.

At the end of each session, a case study which related to the topics learned will be given. Participants will have chance to discuss the case study scenario and come out with the solution.

Upon confirmation, participants can sign on to our unique integrated learning platform. The course will consist of two distinct parts:

Live-stream broadcast: 2 days of highly practical exercise

Full Online: self-directed material to go through in your own time accessible for 30 days.


Who is this course for?

This is a fast pace Intermediate level course and is not suitable for beginners who only know some basic functions and seldom use Microsoft Excel at work. This course is for frequent Excel users who know how to create simple PivotTable and perform simple data analysis tasks. You MUST have a thorough understanding of spreadsheet fundamentals and be confident creating complex functions and formulas and creating simple charts.

Important Technical Pre-requisites
• It might seem obvious, but you will need Internet access.
• You need to have Zoom installed.
• This course will be running and taught based on the PC Windows software.
This is NOT the Mac version. Check before signing up on compatibility differences from the appropriate vendor sites.
• We will be using the latest Office 365 subscription version. If you have earlier versions or Product Activated versions of 2016 and 2013, then some features will not be available to you. Such as IFS, MINIFS, MAXIFS, XLOOKUP functions. See the Microsoft website for product comparisons.

Please check the Course eBrochure and eGuides for more information regarding the technical pre-requisites

 


 

  • 29-30 Jun 2020
  • 13-14 Aug 2020
  • *SDF for all companies
DAY 1
Preparing Data for Analysis

Participants will learn different ways to prepare data for analysis using Flash Fill and TEXT functions.

Analysing and Filtering Data

Participants will learn how to use database functions (DCOUNT/ DSUM/ DAVERAGE) and conditional logical functions (COUNTIFS/ SUMIFS/ AVERAGEIFS) in data analysis and use Advanced filter to copy records based on criteria.

Finding and Extracting Data for Analysis

Participants will learn how to find and extract data from database using VLOOKUP, INDEX, MATCH and SUNPRODUCT functions.

Applying Data Validation and Protection

Participants will learn how to restrict data entry using Data Validation rules and protect worksheet contents and workbook structure from unauthorize access

DAY 2
Using Quick Analysis

Participants will learn how to apply conditional formatting, create charts, insert table, calculate totals and running totals as well as insert Sparklines to show data trend more quickly using Quick Analysis tools.

Building Dynamic Spreadsheet Report

Participants will learn how to add total row, filter data by colour, sort data by colour, insert calculated columns, create dynamic data range for charts and PivotTables using Table.

Analysing Data with PivotTable

Participants will learn how to analyse, summarize, sort, filter, count, total or average data stored in a database and generate professional-look dynamic report more efficiently using PivotTables.

Visualizing Data with PivotChart

Participants will learn how to create PivotChart, customize PivotChart, insert Slicer and Timeline to filter data as well as connect multiple PivotTables to a Slicer or Timeline
 

About Valene Ang

Valene Ang is a Certified Microsoft Training Specialist who has more than 19 years of training experience and working with companies to improve their data processes.

Her qualifications include a Bachelor’s in Business Computing, Microsoft Certified Trainer (MCT), Certified Instructor of Microsoft Certified Application Specialist (MCAS), and Master Instructor of Microsoft Office Specialist (MOS). Valene also holds an Advanced Certificate in Training and Assessment (ACTA) - a national qualification awarded by WDA (Workforce Development Authority) in Singapore.

She has trained different levels of management executives from small-medium size organisations, government offices and multinational companies such as PSA International, Rio Tinto, SingTel, DFS Galleria Singapore, Canon Singapore, HP Singapore, CPF Board, MOE, HPB, HDB, National Environment Agency (NEA), Public Utility Board (PUB), Inland Revenue Authority of Singapore (IRAS), SPRING Singapore, Temasek Polytechnic, Republic Polytechnic, Nanyang Polytechnic, Singapore Expo, Changi Airport Group, DHL, Barclays Capital, Far East Organizations, Intrack Market Service (Malaysia), DENZA (ShenZhen) and many more.

She has also conducted customized training and one-to one coaching sessions for many companies’ executives on Microsoft Office 2003/2007/2010/2013/2016 versions. She is a much-sought-after trainer, judging by the very good evaluation she received from her past participants.

 

I learnt many useful tips on using Excel for work! I didn’t know the existence of many functions until I came for this course.

Lim Jing Jun, Head, Spring Singapore

A great course that is well-structured and relevant to my work. Definitely opened my eyes to new and better ways of analysis data!

Crystal Lee, Marketing Manager, Singtel

Course notes were comprehensive and Trainer was clear.

Tang Ya Xuan Alissa, Assistant Manager, National Council of Social Service

Unique to this Course

Video Tutorial – Before and after class

Case Study – To practice after class

Free Excel Resources – Shortcut keys, sample charts

30-day Access to Online Platform