Microsoft Excel VBA (Macro Programming) For Non Programmers
RM 1400 Per Pax | 30 & 31 March 2016 | 21 & 22 April 2016
Feel Free to enquire for in-house training| It is HRDF fully Claimable
This Microsoft Excel VBA training course covers the following topics:
Day 1
Recorded Macros
Understanding Microsoft Excel macros
Setting macro security
Saving a workbook as a macro enabled workbook
Recording a simple macro
Running a recorded macro
Viewing a macro
Editing a macro
Running a macro from the toolbar
Assigning a keyboard shortcut to a macro
Tips for developing macros
Recorder workshop
Preparing data for an application
Recording a macro that updates opening balances
Recording a macro to open text files
Creating objects to run macros
Assigning a macro to an object
Course Contents
Chapter 1
Dashboards
Introduction To Dashboards
Excel Dashboards
What Makes Good Dashboard
Using The Proper Visualizations
Dashboard Creation Process
Why Is the Chart Type Important?
Chapter 2
Data Visualisation Tools
When to Use A Secondary Axis
Combining Two Chart Types
Formatting Tricks
Chapter 3
Analysing Data With Pivot Reports
What Are Pivot Reports?
Creating A Dynamic Range For Data Expansion
Creating a Pivot Report
Incorporating Visual Analysis With Conditional Formatting
Grouping Data
MS EXCEL 2010 ? EXCEL DASHBOARDS & INTERACTIVE REPORTS
RM 1,400 / per pax | 7 & 8 March 2016 | 7 & 8 April 2016 | 23 & 24 May 2016
Feel Free to enquire about in-house training | HRDF Fully claimable
Dashboard popularity is continuing to grow as organizations look for easier ways to access information within large data sets and to analyze that information in hopes of managing performance, making better decisions and lowering overall costs.
Dashboard reports allow managers to get high-level overview of the business. Essentially, a dashboard report is a way to visually present critical data in summary form so that you can make quick and effective decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.
A dashboard is a business tool that displays a set of PIs (performance indicators), KPIs (key performance indicators), and any other relevant information to a business user. Dashboard data is often displayed in real-time after retrieval from one or more data sources in a business. Dashboards are interactive, allowing an executive to drill into particular aspects of the display or switch between facets or views of the data.
Basic Requirements
Users must have basic knowledge of Excel charts, pivot tables, functions and formulas.
Course Contents
Chapter 1
Dashboards
Introduction To Dashboards
Excel Dashboards
What Makes Good Dashboard
Using The Proper Visualizations
Dashboard Creation Process
Why Is the Chart Type Important?
Chapter 2
Data Visualisation Tools
When to Use A Secondary Axis
Combining Two Chart Types
Formatting Tricks
Chapter 3
Analysing Data With Pivot Reports
What Are Pivot Reports?
Creating A Dynamic Range For Data Expansion
Creating a Pivot Report
Incorporating Visual Analysis With Conditional Formatting
Grouping Data
Regards ,
Noor Shawani
Senior Sales Executive
03-2742 1878 | 03-2386 7788
training@ted.com.my