Microsoft Office (Word, Excel & PowerPoint)
Course Description
Funding available for this course We use MS Word, MS Excel and MS PowerPoint on day to day basis. This is a fundamental course which covers fonts and formats, creating a table and few other basic functions. Besides that, formulas can be used for sorting a table or formatting. It also helps the people to use the various layouts, do slide formatting, provide special effects or select customized designs of templates for their presentation.
Course Objective
Participant will be able to pick up on the Microsoft Excel, Word & PowerPoint which are simple office productivity tools from Microsoft.
Training Methodologies
- Training is hands-on using easy-to-follow step-by-step instructions.
- Instructor-Led Training (ILT) on live exercises of each topic.
Trainer
Training will be conducted by our experienced local trainer who has more than 10 years of experience with relevant certification.
Course Content
Microsoft Word
Lesson 1: Getting Started with Microsoft Word
- Explore the User Interface and the Ribbon
- Quick Access Toolbar
- Creating Documents
Lesson 2: Editing Documents
- Selecting Text
- Deleting Text
- Moving and Copying Text
- Undoing and Redoing Changes
- Finding and Replacing Text
Lesson 3: Formatting Documents
- Formatting Text
- Changing the Font and Font Size
- Changing the Font Color and Highlighting Text
- Applying Font Styles and Effects
- Clearing Formatting
- Copying Formatting
- Formatting Paragraphs
- Changing Paragraph Alignment
- Changing Line and Paragraph Spacing
- Changing Paragraph Indentation
- Setting Tab Stops
- Adding Borders and Shading
- Creating Bulleted and Numbered Lists
- Applying Styles
- Formatting Headings
Lesson 4: Working with Tables
- Inserting Tables
- Navigating Tables
- Selecting Table Parts
- Adding Borders and Shading
- Inserting Rows and Columns
- Resizing Rows and Columns
Lesson 5: Working with Headers and Footers
- Insert Headers and Footers
- Insert the date or time into a header or footer
- Inserting Page Numbers
- Changing the Page Layout
- Changing the Page Margins
- Changing the Page Orientation
- Changing the Page Size
Lesson 6: Using the Mail Merge Wizard
- Use the Mail Merge Feature
Lesson 7: Printing Word Documents, Getting Help and Exiting Word Document
- Printing and Previewing a Work Document
- Getting Help
- Exiting Word
Microsoft PowerPoint
Lesson 1: Getting Started with Microsoft PowerPoint
- Explore the User Interface and the Ribbon
- Quick Access Toolbar
- Create a New Presentation
- Using Templates
- Saving Presentations
- Slide Basics
- Working with Text
- Add a Text Box
Lesson 2: Adding Multimedia Elements
- Using Multimedia Elements
- Working with Pictures
- Applying Styles & Effects
- Modifying Hyperlinks
- Working with SmartArt
Lesson 3: Enhancing Presentations
- Insert Audio from a File
- Insert a Video from a File
- Using Animation
- Applying Transitions
Lesson 4: Managing and Preparing the Slide Show
- Create Slide Sections
- Presenting a Slide Show
- Presentation Tools and Features
- Presenter View
Microsoft Excel
Lesson 1: Getting Started with Microsoft Excel
- Explore the User Interface and the Ribbon
Lesson 2: Overview of Workbooks
- Creating Workbooks
- Saving Workbooks
- Closing Workbooks
- Opening Workbooks
- Selecting Cells, Rows, and Columns
- Using Templates
Lesson 3: Modifying a Worksheet
- Entering Data
- Editing Data
- Moving and Copying Cells
- Using Paste Special
- Clearing Cells
- Undoing and Redoing Changes
Lesson 4: Working with Rows and Columns
- Inserting Rows and Columns
- Deleting Rows and Columns
- Changing Row Heights
- Changing Column Widths
- Hiding and Unhiding Rows and Columns
Lesson 5: Formatting Worksheet
- Changing the Font and Font Size
- Changing the Font Color and Fill Color
- Applying Font Styles
- Adding Cell Borders
- Formatting Numbers
- Positioning Cell Contents
- Copying Cell Formatting
- Applying Cell Styles
Lesson 6: Performing Calculation
- Using Formulas and Functions
- Using Cell References in Formulas
- Entering Formulas
- Displaying Formulas
- Using Functions in Formulas
- Using the AutoSum Button
- Inserting Functions
- Using Formula AutoComplete
Lesson 7: Visualizing Data with Charts
- Creating Charts
- Selecting Chart Elements
- Changing the Chart Type
Lesson 8: Getting Help and Exiting Excel Document
- Getting Help
- Exiting Excel
Related Courses:
Microsoft Excel Basic
Microsoft Excel Intermediate
Microsoft Excel Advanced