Knowing how to write a letter in Word or perform a calculation in Excel does not mean that you have mastered all of the functions of these tools. However, it is unlikely that you will need to know how to use all of these!
DurationKnowing how to write a letter in Word or perform a calculation in Excel does not mean that you have mastered all of the functions of these tools. However, it is unlikely that you will need to know how to use all of these!
Therefore, you should focus on the essentials and on functions that meet your present and future needs.
The ability to operate efficiently will move the business forward and make you an invaluable part of the team, a better co-worker, and a leader in the workplace.
From project management to office coordination, having a better grip on Microsoft Word, Excel, and PowerPoint will have a positive impact on your organization. This includes lesser-known formulas, shortcuts, and capabilities that can help you save your employer time and money.
Target Audience:
This Course Is Designed For Clerks, Officers, Executives, Supervisors, Administrators, Managers Of All levels, And Personnel Who Already Know And Understand And Want To Further Enhance Their Knowledge And Practical Uses Of Microsoft Office
Prerequisites:
Know-Well About Microsoft Word, Excel & PowerPoint
Main Objective:
To Integrate All Microsoft Application To Simplify It With efficiency And accuracy
Standardize Working Process
Module 1:
Excel For Data Management with Pivot
Objectives:
Participants will get the idea and guidance on how to manage data efficiently and more accuratelyly.
Participants will also understand how to work with large amounts of amounts of data and manage to give up-to-date data to management
Lesson 1 : Streamlining Workflow
Conditional Formatting
Data Validation
Lesson 2 : Analyzing Data Using Pivot
What is a pivot table?
Creating a PivotTable
Using the PivotTable Tools Tabs
Adding and Removing Data
Changing the Field List Layout
Pivoting Data
Slicer (2010/2013/2016/2019)
Pivot Charts
Lesson 3 : Excel Dashboard
What is Dashboard in Excel???
Purpose
Lesson 4 : Linking and Embedding
Linking Workbooks
Consolidating Workbooks
Insert Hyperlink
Module 2:
Professional Documentation Using American Psychological Association (APA) Format (Words)
Objectives:
Participants will understand how to produce a professional document such as a report or proposal using standard APA.
Participants also know how to create different page numbering formatsss in one document.
Participants also gain the knowledge to create tables of contents as fast as a second.
How to insert Bibliography using APA format
Lesson 1: APA Format: Cover Page
Standard professional Documents
Lesson 2: Table of Content
Insert Table of Contents
Insert List of Figures
Lesson 3: Inserting Pictures
Inserting Pictures From Drive
Inserting Pictures From Internet
Inserting Screen Clipping/Snapshot
How to edit Pictures
How to label the Pictures
Lesson 4: Inserting Graphs
How to create Graphs
Graphs Layout
How to label the Graphs
Lesson 5:Sections
Objectives to create section
How to create page breaks to create section
Page Numbering with different format
Module 3:
Creating Creative Presentation Using Microsoft PowerPoint
Objectives:
Participants will know how to prepare a good presentation by maximizing all objects by replacing texts.
Animation and transitions will have a greater impact on the current presentation.
Customize Master Slide to fit your presentation
Lesson 1: Adding Diagram to Presentation
How to Create Diagram such as Shapes, Charts and Tables
Modify Diagram
Lesson 2: Working with Images
How to Insert Pictures, Clip Art and Pictures From Web
Screen Clipping
How to remove background of Pictures
Cropping Images
Lesson 3: Inserting Multimedia Objects
Working with Background Music
How to Insert Video into a Slide Presentation
How to trim the music and video to make presentation more presentable
Lesson 4: Smart Art
Choose the best Smart Art to present your idea
Lesson 5: Working with Animation
Types of Animation (Enter, Emphasize, Exit and Draw your animation)
Lesson 6: Inserting Special Effects
Effects for Videos
Effects for Audio
Lesson 7: Slide Transition
Insert animation transition for all slide
Insert animation transition for selected slide
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.
Through completing the introductory Excel 2016 training course, you’ll develop foundational data manipulation knowledge and skills that you can build upon through additional training and use.
In this course, students will learn how to use Microsoft Access to manage your data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.
You’re beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized program help participants increase their data analysis capabilities using Excel 2003, 2007, or 2010—and challenge yourself to new levels of mastery.
Microsoft Excel Basic course is offered by Fajar International College. Fajar International College (FIC) is in business to provide the highest standard of education in Occupational Safety and Health, Business Management, and Accounting Courses.
Effective Guides for Slides with MS PowerPoint 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.
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.
© 2025 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
Saudi Arabia
Egypt
Jordan