Introduction
Knowing how to write a letter in Word, or to 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 essential 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, 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 Efficient And Accurate
- Standardize Working Process
Module 1 :
Excel For Data Management with Pivot
Objectives:
- Participants will get the idea and guide how to manage data efficiently and more accurate.
- Participants will also understand how to work with large data and manage to give up-to-date data to management
Lesson 1 : Streamlining Workflow
- Conditional Formatting
- Data Validation
Lesson 2 : Analysing Data Using Pivot
- What is a PivotTable?
- 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 Report and Proposal with effective using standard APA.
- Participants also know how to create different page numbering format in one document.
- Participants also get knowledge to create Table Of Content as fast as a second.
- How to insert Bibliography using APA format style
Lesson 1: APA Format – Cover Page
- Standard Profesional 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
Lesson 7: Bibliography / References
Module 3 :
Creating Creative Presentation Using Microsoft PowerPoint
Objectives:
- Participants will know how to prepare a good presentation with maximizing all objects by replacing texts.
- Animation and transition will give more impact to 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 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 (Entry, 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
Lesson 8: Slide Master
Lesson 9 : Integration
-
- Hyperlink between Application
- Mail Merge
– Letter
– Report
– Certificate
– Envelope
-
- How to create Master Slide
– Presentation with Efficient and Accurate.