Microsoft Excel VBA (Macro Programming) For Non Programmers

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