We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

Learn how to explore and analyze your data by creating an interactive dashboard in Excel using pivot tables and Visual Basic. In this course, you will learn how to create a dynamic template to generate business reports for customers and to better understand your own data. You'll learn how to import external data, design a template using pivot tables, and add slicers, macros, and action buttons to make the template more interactive.

Topics include:

  • Defining your requirements
  • Setting up data
  • Adding reference tables
  • Creating hierarchy in the layout
  • Choosing colour and typography
  • Importing data
  • Inserting slicers
  • Recording a macro
  • Editing VBA code
  • Improving the user experience
  • Analysing data with Goal Seek and Solver

               HRDF SBL Claimable for Employers Registered with HRDF
For more information regarding this course please visit: 
https://www.tertiarycourses.com.my/excel-dashboards-business-analytics-malaysia.html

Outline

Module 1: Overview on Interactive Dashboard

  • What is Interactive Dashboard
  • Why use Excel for Interactive Dashboard

Module 2 Preparing the data for the dashboard

  • Keeping inputs clean with data validation
  • Mass cleaning data with text manipulating functions 
  • Removing duplicates & highlighting errors with conditional formatting
  • Merging tables with formulas
  • Creating Variables
  • Adding Reference Tables
  • Creating Action Queries

Module 3: Designing Visually Professional Layout for Dashbord

  • Creating a Visual Design
  • Creating a pivot chart
  • Formatting charts
  • Creating Hierarchy in the Template
  • Styling the Layout

Module 4 Create a Report

  • Import data with pivot tables
  • Understanding the 4 quadrants of a pivot table
  • Creating, sorting and filtering pivot tables 
  • Creating interactive data tables with slicers
  • Recoding a macro
  • Editing VBA code
  • Inserting control buttons
  • Goal seek & solver

 

Speaker/s

Ramzan has been conducting training and lectures in the IT industry for the past 18 years. She started her career as a college lecturer teaching NCC Diploma Computer Studies. Due to her in-depth experience and breadth of knowledge, Ramzan was selected by the Malaysian Ministry of Education to conduct training for Government School teachers called Program Latihan Penggunaan Peralatan TMK PPSMI 5. She has since then further forayed into academia training engagements with both public and private tertiary education institutions such as University Malaya, University Teknologi MARA, University Tunku Abdul Rahman (UTAR), University of Nottingham Malaysia and The SEGi Education Group.

Being an effective communicator with proven ability to build strong working relationships and generating results, Ramzan ventured into the corporate training field with her core expertise in productivity software suite training ie: Microsoft Office, IBM Lotus Smart Suites, Google Docs and Open Office applications.

Her corporate training portfolio achievements include training multitude business verticals and industry segments encompassing Government Linked Companies, Corporate Enterprise and Small Medium Businesses. This includes companies such as Khazanah Nasional Berhad, Felda, Petronas, UEM Land, Air Asia, Maybank, CIMB, Standard Charted, Honda, Perodua, BMW, Shell, DHL, Gamuda, Hewlett Packard, Prudential, Maxis, Celcom Axiata Group and others.

Reviews
Be the first to write a review about this course.
Write a Review
Tertiary Courses Malaysia is a HRDF Approved Training Provider in Malaysia. We offers wide range of classroom instructor-led technical training courses for working professionals and executives in Malaysia.

All our courses and trainings are funded by HRDF (Human Resources Development Fund Malaysia). Our courses include Infocomm, Digital Media, Robotics, Semiconductor,Telecommunication, Life Science, Horticulture Industries , and Business Administration . Below are some of our popular courses

  1. Python Programming
  2. R Programming
  3. Tableau
  4. Machine Learning
  5. Raspberry Pi
  6. Arduino
  7. 3D Printing
  8. iOS Apps Development
  9. Android Apps Development
  10. Magento eCommerce
  11. Wordpress
  12. Joomla
  13. Search Engine Optimizatoin
  14. Web Design
  15. Google Analytics
  16. Facebook Marketing
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.