GRAB 3 FREE 1 !!! EXCEL DASHBOARDS AND REPORTS (14 - 15 Jan 2025)

Please call 012-588 2728

 email to pearl-otc@outlook.com

 

HYBRID PUBLIC PROGRAM

EXCEL DASHBOARDS AND REPORTS   

(** Choose either Zoom OR Physical Session)

Remote Online Training (Via Zoom)  &

OTC Training Centre Sdn Bhd Subang, Selangor (Physical)

  (SBL Khas / HRD Corp Claimable Course)

Date : 14 Jan 2025 (Tue)   |  9am – 5pm                             By Siti

 15 Jan 2025 (Wed)  |  9am – 5pm                            

                       .

OVERVIEW:

What’s the use of putting out reports that no one reads? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool! How cool? You’ll find out when you see the dazzling examples in Excel Dashboards & Reports. And, before long, everyone’s eyes will be riveted to your dashboards and reports too!

 

This revolutionary guide shows you how to turn Excel into your own personal Business Intelligence tool. You’ll learn the fundamentals of using Excel to go beyond simple tables to creating dashboard-studded reports that wow management. Get ready to catch dashboard fever as you find out how to use basic analysis techniques, build advanced dashboard components, implement advanced reporting techniques, and import external date into your Excel reports. Discover how to:

 

Unleash the power of Excel as a business intelligence tool

Create dashboards that communicate and get noticed

Think about your data in a new way

Present data more effectively and increase the value of your reports

Create dynamic labels that support visualization

Represent time and seasonal trending

Group and bucket data

Display and measure values versus goals

Implement macro-charged reporting

 

NOT FOR BEGINNERS

This course is not for Excel beginners, because the fast pace could be overwhelming. Lots of material is covered, very quickly. It is designed for Excel users who are beyond the basics, and who enjoy learning by seeing a demo, then practising the new skills.

 

 

OUTLINE OF WORKSHOP

Part I Making the Move to Dashboards

Is all about helping you think about your data in terms of creating effective dashboards and reports.

Chapter 1 Getting in the Dashboard State of Mind

Þ Introduces you to the topic of dashboards and reports, giving you some of the fundamentals and basic ground rules for creating effective dashboards and reports.

Chapter 2 Building a Super Model

Þ Shows you a few concepts around data structure and layout. In this chapter, will demonstrate the impact of a poorly planned data set and show you the best practices for setting up the source data for your dashboards and reports.

 

Part II Building Basic Dashboard Components

You take an in-depth look at some of the basic dashboard components you can create using Excel.

Chapter 3 The Pivotal Pivot Table

Þ Introduce you to pivot tables and discuss how a pivot table can play an integral role in              Excel-based dashboards.

Chapter 4 Excel Charts for the Uninitiated

Þ Provides a primer on building charts in Excel, giving beginners a solid understanding of how  Excel charts work.

Chapter 5 The New World of Conditional Formatting

Þ Introduces you to the new and improved conditional formatting functionality found in Excel. In this chapter, will present several ideas for using the new conditional formatting tools in        dashboards and reports.

Chapter 6 The Art of Dynamic Labeling

Þ You explore the various techniques that can be used to create dynamic labels, allowing for the creation of a whole new layer of visualization.

 

Part III Building Advanced Dashboard Components

You go beyond the basics to look at some of the advanced components you can create with Excel. This part consists of three chapters.

Chapter 7 Components That Show Trending

Þ In which will demonstrate how to represent time trending, seasonal trending, moving averages, and other types of trending in dashboards. You are also introduced to Sparklines in this chapter.

Chapter 8 Components That Group and Bucket Data

Þ You explore the many methods used to bucket data or put data into groups for reporting.

Chapter 9 Components That Display Performance against a Target

Þ Demonstrates some of charting techniques that help you display and measure values versus goals.

 

Part IV Advanced Reporting Techniques

Focuses on techniques that help you automate your reporting processes and give your users an interactive user interface.

Chapter 10 Macro-Charged Reporting

Þ Provides a clear understanding of how macros can be leveraged to supercharge and  automate your reporting systems.

Chapter 11 Giving Users an Interactive Interface

Þ Illustrates how you can provide your clients with a simple interface, allowing them to easily navigate through and interact with their reporting systems.

 

Part V Working with the Outside World

Is importing and exporting information to and from Excel.

Chapter 12 Using External Data for Your Dashboards and Reports

Þ Explores some of the ways to incorporate data that does not originate in Excel. In this chapter, will show you how to import data from external sources as well as how to   create systems that allow for dynamic refreshing of external data sources.

Chapter 13 Sharing Your Work with the Outside World

Þ Wraps up this look on Excel dashboards and reports by showing you the various ways to distribute and present your work.

 

Part VI The Part of Tens

Is the classic Part of Tens section. The chapters found here each present ten or more pearls of wisdom, delivered in bite-sized pieces.

Chapter 14 Ten Chart Design Principles

Þ Ten or so chart-building best practices, helping you design more effective charts.

Chapter 15 Ten Questions to Ask Before Distributing Your Dashboard

Þ Checklist of questions you should ask yourself before sharing your Excel dashboards and reports.

 

 

 

** Certificate of attendance will be awarded for those who completed the course

 

ABOUT THE FACILITATOR

 

Siti

Microsoft Office Specialist (MOS)

Siti started her career as an Information Technology Lecturer in few local colleges and universities back in year 1999. In her 8 years’ experience as a lecturer, she picks up various discipline in IT related subjects. She also involved in giving Microsoft Office Applications training to various companies.

 

Since 20 March 2006 till present, Siti decided for a career change. She moved to IT related training. As a Training Consultant, she focused more on Microsoft Office Applications training. She has facilitated training programs in link with broad-ranging groups of training institutes and clients. She is familiar and proficient with Microsoft Office Applications and during her training she will address the day to day issues faced by employees in today’s corporate environment.

 

In year 2007 till 2008 Siti had been appointed as one of the Master Trainer for The Teaching and Learning of Science and Mathematics in English (Pengajaran dan Pembelajaran Sainsdan Matematik Dalam Bahasa Inggeris - PPSMI). Her role as a Master Trainer was to give training to all the trainers representing different states around Malaysia on how to deliver the training to all the teachers in various schools in Malaysia.

 

Aside to giving training, Microsoft Malaysia has engaged her to share her expertise on how to fully maximize the usage of Microsoft Office Applications since year 2008 till current. She had done many workshops around Malaysia for major Microsoft Malaysia customers mostly focusing on the Tips and Tricks and also best practices.

 

Siti was involved as a Handyman in Handyman Project under Shell Global Solutions, Malaysia since 2008 till 2011. To be given the opportunity to give One-to-one consultation with the client by looking, asking and solve problem related to the data provided by the clients.


Examples of topics covered for Handyman sessions are E-mail and Calendar, Standard & Mobile Office, Archiving & Back-ups, NetMeeting, Livelink, Live Meeting? and Microsoft
Office Applications.

 

Nov 2010 to Feb 2011 she was being given another golden opportunity by ExxonMobil Malaysia to be the lead trainer in the Migration from XME to GME project to train almost 3000 staffs. This training also includes Microsoft Office 2010 and Windows 7.

 

Academic Qualification

1999 – Bachelor of Computer Science (Honours) · Computing (Single Major) - USM

2001 – Master of Science · Distributed Computing - UPM

 

Working Experience

Cybernetics International College of Technology · Lecturer · (June 1999 to May 2002)

MARA University of Technology (UiTM Seri Iskandar) · Lecturer · (June 2002 to July 2003)

Cosmopoint College of Technology · Lecturer · (September 2005 to March 2006)

Iverson Associates SdnBhd · Senior Training Consultant · (March 2006 to February 2011)

Info TrekSdnBhd · Senior Training Consultant· (February 2011 to April 2017)

Fulltime Senior Training Consultant · (May 2017 to present)

 

Professional Certification

Microsoft Certified Application Specialist for Office Excel 2007

Microsoft Certified Application Specialist for Office PowerPoint 2007

Microsoft Certified Application Specialist for Office Word 2007

Microsoft Office Specialist for Office Excel 2016

Microsoft Office Specialist for Office Word 2016

PSMB Certified Trainer

 

 

(SBL Khas / HRD Corp Claimable Course)

TRAINING FEE

14 hours Remote Online Training (Via Zoom)

RM 1,296.00/pax     (excluded 8% SST)

2 days Face-to-Face Training (Physical Training)

RM 1,850.00/pax     (excluded 8% SST)

Group Registration: Register 3 participants from the same organization, the 4th participant is FREE.
(Buy 3 Get 1 Free) if
Register before 7 Jan 2025. Please act fast to grab your favourite training program!

  

We hope you find it informative and interesting and we look forward to seeing you soon.

Please act fast to grab your favorite training program! Please call 012-588 2728

or email to pearl-otc@outlook.com

 

Do forward this email to all your friends and colleagues who might be interested to attend these programs

 

If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type Unsubscribe in the subject area.

We will remove your name from the list and you will not receive any additional e-mail

 

 

Thanks 

Regards

Pearl


by "pearl@otcmsb.com.my" <pearl@otcmsb.com.my> - 03:54 - 12 Dec 2024