Thursday, February 9, 2017

Kursus MS Excel anjuran Nor Shawani (TED)

Data Analytics : Excel 2010|2013 Dashboard Interactive Reports 

Details of the training : 
  1. 27 & 28 Feb 17 | 6 & 7 Mar 17 | 10 & 11 Apr 17
  2. Venue : Binjai 8 , KLCC 
  3. RM 1400 Per Pax


RM 1,400 | per pax
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


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

Adding Interactive Elements

Slicing & Dicing Data
Querying Pivot Reports
Creating Pivot Charts
Chapter 4

Creating Interactive Reports

An Alternative To The VLOOKUP Function
Charting Tricks
Showing Positive & Negative indicators

Variance Analysis Dashboard

Returning A Value Based On User Selection
Incorporating Form Controls
Incorporating Hyperlinks

Chapter 5

Automating Dashboards With Functions

Offset Function
CountA Function
Structuring Your Data
Linked Textbox
Named Formulas
Creating Gauge / Speedometer Charts

Chapter 6

Visual Basic For Applications

What Is VBA?
Basics of VBA & Macros
Executing A Procedure
Converting A Workbook To A Macro Enabled Workbook

Microsoft Excel VBA (Macro Programming) For Non Programmers

RM 1400 per pax
Dates : 22 & 23 Feb 17 | 13 & 14 Mar 17 | 6 & 7 Apr 17 
Venue : Binjai 8 , KLCC

Joining in usage of both Microsoft Excel and VBA are to increase your productivity, become more powerful and flexibility to spreadsheets, automating processes and improving user interaction.
Students are required knowledge from Intermediate to Advanced of Microsoft Excel before joining this course. Students are not required programming knowledge background.
Microsoft Excel VBA training course increase user productivity thru automated and worksheets process by using the inbuilt programming language. It will benefits students with the automated worksheet in MS Excel built in programming language.   
Course Objectives
Upon completion of this Microsoft Excel VBA training course, participants should have learned Microsoft Excel VBA sufficiently to be able to:
  • Create recorded macros in Microsoft Excel
  • Use the macro recorder to create a variety of macros
  • Understand the Microsoft Excel object model and VBA concepts
  • Create command procedures
  • Create and use variables
  • Write code to manipulate Microsoft Excel objects
  • Use a range of common programming techniques

Course content

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

Understanding VBA

  • VBA terminology
  • About objects
  • Accessing the Microsoft Excel object model
  • Using the immediate window
  • Working with object collections
  • Setting property values
  • Working with worksheets
  • Using the object browser

Using the VBA editor

  • The VBA editor
  • Opening and closing the editor
  • Working with the project explorer
  • Working with the properties window
  • Working with a code module
  • Stepping through a procedure


  • About procedures
  • Creating a command procedure
  • Making sense of intellisense
  • Using the edit toolbar
  • Commenting statements
  • Indenting code

Using variables

  • Understanding variables
  • Creating and using variables
  • The scope of variables
  • Procedure level scoping
  • Module level scoping
  • Passing variables by reference
  • Passing variables by value
  • Data types
  • Declaring data types
Day 2

Using Microsoft Excel objects

  • Application methods and properties
  • Workbook methods and properties
  • Viewing Microsoft Excel and the editor together
  • Using workbook objects
  • Worksheets methods and properties
  • Using worksheet objects
  • Range methods and properties
  • Using range objects
  • Using objects in a procedure

Programming techniques

  • The msgbox function
  • Sending messages to the user
  • Inputbox techniques
  • Using the inputbox function
  • Using if for multiple conditions
  • Looping with known or specified iterations
  • The do...loop statement
  • Looping with unknown iterations
With Regards , 
Nor Shawani (TED)
Tel : 03-2386 7788 | 03-2742 1828
Email : 

No comments: