Details of the training :
|
MS EXCEL 2010|2013 : EXCEL DASHBOARDS & INTERACTIVE REPORTSRM 1,400 | per paxDashboard 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 1DashboardsIntroduction To DashboardsExcel Dashboards What Makes Good Dashboard Using The Proper Visualizations Dashboard Creation Process Why Is the Chart Type Important? Chapter 2Data Visualisation ToolsWhen to Use A Secondary AxisCombining Two Chart Types Formatting Tricks Chapter 3Analysing Data With Pivot ReportsWhat Are Pivot Reports?Creating A Dynamic Range For Data Expansion Creating a Pivot Report Incorporating Visual Analysis With Conditional Formatting Grouping Data Adding Interactive ElementsSlicing & Dicing DataQuerying Pivot Reports Creating Pivot Charts Chapter 4 Creating Interactive ReportsAn Alternative To The VLOOKUP FunctionCharting Tricks Showing Positive & Negative indicators Variance Analysis DashboardReturning A Value Based On User SelectionIncorporating Form Controls Incorporating Hyperlinks Chapter 5Automating Dashboards With FunctionsOffset FunctionCountA Function Structuring Your Data Linked Textbox Named Formulas Creating Gauge / Speedometer Charts Chapter 6Visual 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. Course Objectives 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:Day 1 Recorded Macros
Understanding VBA
Using the VBA editor
Procedures
Using variables
Using Microsoft Excel objects
Programming techniques
Nor Shawani (TED) Tel : 03-2386 7788 | 03-2742 1828 Email : training@ted.com.my |
Kami TIDAK bertanggungjawab terhadap sebarang kehilangan atau kerosakan atau kerugian yang dialami kerana menggunakan kandungan di dalam blog ini. Pendapat atau bahan yang dikemukakan di dalam blog ini adalah pandangan peribadi semata-mata dan untuk kegunaan peribadi sahaja.
Thursday, February 9, 2017
Kursus MS Excel anjuran Nor Shawani (TED)
Data Analytics : Excel 2010|2013 Dashboard Interactive Reports
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment