Microsoft Excel, Word, PowerPoint
Previous | 7 / 10 | Next |
This is 3-Day Microsoft Office (Excel, Word, and PowerPoint) intermediate level training suitable for people who want to work better with numbers and data in Excel 2019, improve PowerPoint presentation skills, and create professional documents in Word 2019.
Objective:
At the end of the training, participants are able to:
Outline:
'Day 1: Excel 2019
Objective:
At the end of the training, participants are able to:
- Create Excel Formulas
- Create Excel Charts
- Insert SmartArt and images to a spreadsheet
- Create Excel Table
- Use Mail Merge in word document
- Format Text and Paragraph
- Format document to Print
- Insert Table and images to word document
- Create Table of Content in word document
- Add Multimedia to a presentation
- Enhance presentation with animation and transition
- Setup the slide show to Present
Outline:
-
Chapter 1: Formulas and Functions
- Entering Formulas
- Excel Arithmetic Operators
- Using AutoFill Options
- Using Commonly Used Functions
-
Chapter 2: Organizing Worksheet and Table Data
- Create and Modify Tables
- Sorting and Filtering Data in a Table
- Getting Summary Information in a Table
-
Chapter 3: Working with Charts
- Summarizing Data Using Charts
- Customizing Chart Data
- Format Chart Legend and Titles
- Creating a Pie Chart
-
Chapter 4: Working with Graphics
- Adding Pictures into a Worksheet
- Customizing Pictures and Objects
- Adding Drawing Objects
- Adding SmartArt into a Worksheet
-
Chapter 5: Managing Large Workbook
- Managing Large Workbooks
- Printing Worksheets
- Setting Page Setup Options
-
Chapter 6: Customizing & Enhancing Workbooks
- Customizing Excel to Your Work
- Creating Hyperlinks
- Customizing Quick Access Toolbar
Day 2: Word 2019
-
Chapter 1: Formatting Text & Paragraphs
- Setting Tab Stops
- Organizing List Information
-
Chapter 2: Formatting Documents to print
- Using Headers & Footers
- Proofing Preparing for Print
-
Chapter 3: Using Tables
- Inserting Tables
- Modifying Tables
- Sorting Lists
-
Chapter 4: Working with Illustrations
- Inserting Pictures
- Manipulating Images
- Wrapping Text around a Picture
-
Chapter 5: Creating Mass Mailing Documents
- How do I merge?
- Setting Rules for Merging
- Creating Simple Mailing Documents
-
Chapter 6: Referencing Information
- Creating an Index
- Creating a Table of Contents
Day 3 : PowerPoint 2019
-
Chapter 1: Working with Text
- Using an Outline Adding Text
- Modifying Text on a Slide
- Using Bullets and Numbering
- Formatting Text and Paragraphs
- Using Text Boxes
- Using WordArt
-
Chapter 2: Adding Multimedia Elements
- Using Multimedia Elements
- Working with Pictures
- Inserting & Modifying Hyperlinks
- Inserting Action Buttons
- Working with SmartArt
-
Chapter 3: Enhancing Presentations
- Adding Audio and Video Media
- Using Slide Transitions
- Using Animations
-
Chapter 4: Preparing the Slide Show
- Reviewing Presentations
- Customizing the Presentation
- Proofing a Presentation
- Setting up a Slide Show
- Using Presentation Tools
- Rehearsing a Presentation
- Presenting the Slide Show
Durations:
3 days (21 hours)
Target Audience:
This course is designed for those who want to understand the concepts of documents, spreadsheets and presentations, and would like to demonstrate the ability to use Microsoft Excel, PowerPoint and Word on a personal computer.
Methodology:
Methodology:
Demonstration, practical learning, and exercises
Prerequisite(s) or equivalent knowledge:
Basic knowledge of computers, using keyboard, mouse and Windows is required.
Prerequisite(s) or equivalent knowledge:
Basic knowledge of computers, using keyboard, mouse and Windows is required.