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!
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!
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.
The Microsoft Excel certification course and labs thoroughly cover the MO-200 exam objectives and provide the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually.
This is an ideal course for users who desires to manage data, sort and filter, analyze data, and learn to automate some common Excel tasks.
MS PowerPoint course is offered by SIRIM Academy. SIRIM Academy - which focuses on technology training, personnel certification, talent, and vendor development, ESG and people skills.
Microsoft PowerPoint course is offered by Akademi Suria. At the heart of Akademi Suria is our dedicated team of highly experienced trainers and staff members. They bring a wealth of knowledge and expertise to our training programs.
A successful database is efficient, quick, accurate, and easy to use. This course covers how to create such a database with MS Excel.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy