In the face of rapid technological change, your daily routine at the office requires skill in presenting accurate, fast, and engaging reports
DurationIn the face of rapid technological change, your daily routine at the office requires skill in presenting accurate, fast, and engaging reports. For those in the position of decision-making, you need to analyse and explore the various possibilities of helping organizations make decisions that increase profitability and reduce costs.
Objective:
Provides interactive reports that are precise and fast in processing data input
Facilitate data analysis and what-if analysis
Easy to help with presentations and reports
Target Audience:
All positions in helping organizations make decisions, such as senior executive, manager, and director. Individuals who want to make interesting and interactive reports, such as Finance Executive and Human Resources executives, are also private companies
5.0 Pre-Requisite:
has attended Excel Intermediate and Advance Training sessions or is proficient in Microsoft Excel software
Has the ability to use and understand basic functions of the keyboard and mouse
Understand the advantages and disadvantages of each version of Microsoft Office Excel
Course Outline:
Module 1: Basic Decision Making & Analysis Function
Sum, Average, Max, Min, Rank and Count
IndexMatch Lookup & Hyperlink
Module 2: Basic Analysis Graph
Column, Bar, Line, Pie and Donut
Module 3: Pivot Table & Charts
Source of Data: FAT or Range
Rules to apply Name
Rules to apply FAT
Pro’s and Con’s FAT and Range
Destination
Within same sources file or same workbook, a different worksheet
Other workbooks
Pro’s and Con of different workbook
Pivot Environment
Ribbon, Show and Filed List Areas
Slicer and Timeline
Insert Calculation Field
Drill down and Drill up
Pivot Charts
Module 4 : Interactive Dashboard
Human Resources: Analysis employee data, such as Leave and Attendance
Training: Analysis of progression of Training by employee
Sales: Analysis and Performance Sales Person
Warehouse: Analysis Stock
Established in 2009, Knowledge Hub Asia Sdn Bhd is a seasoned and experienced training provider based out of Malaysia. Boasting a diverse portfolio of trainers and programs that aim to cater to every field, we aim to work alongside our clients in developing and executing the perfect training solution for their respective business needs.
We Are Specialists In What We Do
Human capital is the cornerstone of every modern business; from teamwork to leadership, down to technical know-how, it is crucial that your employees are equipped with the necessary tools to remain competitive in an ever-changing business landscape.
With over ten years of industry experience, we aim to provide you with our expertise in creating a bespoke training strategy that best reflects your goals.
Our best-selling courses include PSMB’s Train The Trainer (PSMB TTT) program, Supervisory & Leadership Development Program, Customer Service, Business Communication & Professional Business Writing, Corporate Grooming & Image, Creative Thinking and Problem Solving, Mind Mapping, OSHA, ISO certification, and MS Office Programs, all of which play a pivotal role in shaping and aligning your organization.
We Are Ready To Deliver
We are committed to delivering quality and proven results. Work alongside our seasoned consultants in designing a training itinerary that best reflects your business, and speak to our panel of qualified trainers to gain a better insight on how you can make the most out of your training course of choice.
What’s more, our trainers are certified under Pembangunan Sumber Manusia (PSMB)’s Train the Trainer (TTT) initiative, subject to terms & conditions set by PSMB*.
With proven testimonials from notable clients such as Amway, Shell, UEM Edgenta, Great Eastern Life Assurance, UMW Toyota, Texas Instruments, INTEC Education, University Kuala Lumpur and Sunway University, rest assured that you are in good hands every step of the way.
Our Vision
Knowledge Hub vision is to cultivate a learning culture in the corporate environment as we believe knowledge is power. “An Investment To Knowledge Pays The Best Interest” – By Benjamin Franklin
Our Mission
We strive to become the training partner to our clients to cultivate, build and re-align employees towards achieving business success.
Project Management Fundamentals Tarining Course is offered by New Horizons.We are the authorised learning partner to the top technology providers.
Microsoft Project course is offered by MindMapper Solution Sdn Bhd. Our team has more than 15 years of experience in management and training. We have extensive skills in all aspects of implementation and operation to meet your requirements.
The Professional Scrum Master (PSM) programme takes 5 days to complete, and it probes into the tenets, experimental process, and conceptual underlying of Scrum framework, and the Scrum Master role therein.
The Microsoft Project (Basic to Expert) Program is offered by the International College of Management and Sports (ICMS).
Budgeting course is offered by JTS Trainings. JTS Trainings is one of the leading training and consultancy companies dedicated to providing quality training to boost a feeling of value in employees.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UAE, UK, USA, India and South Africa, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore