Kursus MS Excel anjuran MEDUKAS SDN BHD

MS Excel 2013|2010 : Excel Dashboards & Interactive Reports 
RM 1,400 per pax (HRDF CLAIMABLE)
course duration : 22 & 23 February 2017 |  21 & 22 April 2017 
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
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
MS Excel : VBA (Macro Programming) For Non Programmers
RM 1,400 / per pax (HRDF CLAIMABLE)
course duration :  20 & 21 March 2017   
Duration 2 days
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

Procedures

• · 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

MS Excel 2013|2010 : Pivot Tables 
13 February 2017 
RM 900 per pax (HRDF CLAIMABLE)
Introduction
A Pivot Table is essentially a dynamic summary report generated from a database.
The database can reside in an Excel worksheet (in the form of a table) or in an external data file.
You can organise and summarise your data, perform comparisons, and extract meaningful information that can be invaluable to you and organisation.
Also, a Pivot Table can help transform endless rows and columns of numbers into a meaningful presentation of the data.
At Course Completion
At the end of the course, participants will be able to gain the knowledge of:

• · Creating PivotTables
• · Modifying PivotTable Calculations
• · Using VLOOKUP with the Pivot Tables
• · Advanced Pivot Table Options
• · Creating a PivotTable based on External Data
• · Creating Pivot Charts
• · Working Pivot Table with Macro

Pre-requisites
Completion of Microsoft Excel (Advanced Level) course or equivalent knowledge

Do not hesitate to inquire the following subject;
Manipulating Big Data with Power Query & Power Pivot  2 days 
MS Excel 2013/2010 ( Basic & Intermediate ) 2 days 
MS Excel 2013/2010 ( Advanced )  2 days 
MS PowerPoint 2013/2010 ( Basic - Advanced ) 2 days
MS Word 2013 / 2010 ( Basic - Advanced ) 2 days 
MS Projects
Adobe Courses
SQL Server 
Looking forward to serve you!

Sincerely, 
Kelvin
014 392 0889
Business Manager

MEDUKAS SDN BHD
Level 23, NU Tower 2,
Jalan Tun Sambanthan,
Kuala Lumpur Sentral, 
50470 Kuala Lumpur, Malaysia.
Tel : 03 - 2727 1622  Fax : 03 - 2727 1623
WWW.MEDUKAS.COM