| Details of the training : |
MS EXCEL 2010|2013 : EXCEL DASHBOARDS & INTERACTIVE REPORTSRM 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.
Users must have basic knowledge of Excel charts, pivot tables, functions and formulas.
DashboardsIntroduction To Dashboards
What Makes Good Dashboard
Using The Proper Visualizations
Dashboard Creation Process
Why Is the Chart Type Important?
Data Visualisation ToolsWhen to Use A Secondary Axis
Combining Two Chart Types
Analysing Data With Pivot ReportsWhat Are Pivot Reports?
Creating A Dynamic Range For Data Expansion
Creating a Pivot Report
Incorporating Visual Analysis With Conditional Formatting
Adding Interactive ElementsSlicing & Dicing Data
Querying Pivot Reports
Creating Pivot Charts
Creating Interactive ReportsAn Alternative To The VLOOKUP Function
Showing Positive & Negative indicators
Variance Analysis DashboardReturning A Value Based On User Selection
Incorporating Form Controls
Automating Dashboards With FunctionsOffset Function
Structuring Your Data
Creating Gauge / Speedometer Charts
Visual Basic For ApplicationsWhat 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
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.
Upon completion of this Microsoft Excel VBA training course, participants should have learned Microsoft Excel VBA sufficiently to be able to:
Course contentThis Microsoft Excel VBA training course covers the following topics:
Using the VBA editor
Using Microsoft Excel objects
Nor Shawani (TED)
Tel : 03-2386 7788 | 03-2742 1828
Email : firstname.lastname@example.org
Thursday, February 9, 2017
Kursus MS Excel anjuran Nor Shawani (TED)
Data Analytics : Excel 2010|2013 Dashboard Interactive Reports