MS Office Training

MS Excel - Basic

Lesson 1: Getting Started with Microsoft Excel 2010

• Identify the Elements of the Excel Interface
• Create a Basic Worksheet
• Use the Help System

Lesson 2: Performing Calculations

• Create Formulas in a Worksheet
• Insert Functions in a Worksheet
• Reuse Formulas

Lesson 3: Modifying a Worksheet

• Manipulate Data
• Insert, Manipulate, and Delete Cells, Columns, and Rows
• Search for and Replace Data
• Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

• Modify Fonts
• Add Borders and Color to Cells
• Apply Number Formats
• Align Cell Contents
• Apply Cell Styles

Lesson 5: Printing Workbook Contents

• Define the Basic Page Layout for a Workbook
• Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks

• Format Worksheet Tabs
• Manage Worksheets
• Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment

• Customize General and Language Options
• Customize Formula Options
• Customize Proofing and Save Options
• Customize the Ribbon and Quick Access Toolbar
• Customize the Functionality of Excel by Enabling Add-Ins
• Customize Advanced and Trust Center Options.

MS Excel – Intermediate

Excel 2010 – Level 2 (Intermediate)

Lesson 1: Creating Advanced Formulas

• Apply Range Names
• Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions

• Leverage Questions and Testing to Write Formulas
• Use Logical and Lookup Functions to Find Answers to Questions

Lesson 3: Organizing Worksheet Data with Tables

• Create and Modify Tables
• Sort and Filter Data
• Use Summary and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Charts

• Create Charts
• Modify and Format Charts • Create a Trendline
• Create Advanced Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

• Create a PivotTable
• Filter Data Using Slicers
• Analyze Data Using Pivot Charts

Lesson 6: Inserting Graphics

• Insert and Modify Graphic Objects
• Layer and Group Graphic Objects
• Incorporate SmartArt

Lesson 7: Enhancing Workbooks

• Customize Workbooks
• Manage ThemesCreate and Use Templates
• Protect Files

MS Excel - Advance Level

Lesson 1: Automating Worksheet Functionality

• Update Workbook Properties
• Create and Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria

Lesson 2: Auditing Worksheets

• Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Create a Data List Outline

Lesson 3: Analyzing Data

• Create Spark lines
• Create Scenarios
• Perform a What-If Analysis
• Perform a Statistical Analysis with the Analysis Tool Pack

Lesson 4: Working with Multiple Workbooks

• Create a Workspace
• Consolidate Data
• Link Cells In Different Workbooks
• Merge Workbooks

Lesson 5: Building a PivotTable

• Insert a PivotTable
• Create a PivotTable Based on External Data
• Categorize PivotTable Data
• Customize a PivotTable

Lesson 6: Analyzing Data Using Pivot Tables
Create Custom Calculations in a PivotTable • Restructure a PivotTable

Lesson 7: Presenting PivotTable Data Visually

• Format a PivotTable
• Present a PivotTable in a Pivot Chart
• Print PivotTables and Pivot Charts

Lesson 8: Exporting Excel Data

• Export Excel Data
• Import a Delimited Text File
• Integrate Excel Data with the Web
• Create a Web Query

Lesson 9: Examining Data Using Math Functions
Analyze Sales Data Using Math Functions

Lesson 10: Manipulating Data Using Text and Information Functions

• Manipulate Data Using Text Functions
• Validate Data Using Information Functions

Lesson 11: Working with Templates and Charts

• Create Advanced Templates
• Create Advanced Charts

Lesson 12: Managing Data in Workbooks

• Retrieve and Paste Data
• Clean Data in Workbooks

MS Word - Basic

Lesson 1: Getting started
The Word window New documents Word Help

Lesson 2: Navigation and selection techniques
Document navigation Selection techniques

Lesson 3: Editing text

• Working with text
• Using Undo and Redo
• Cutting, copying, and pasting text

Lesson 4: Formatting text

• Character formatting
• Tab settings
• Paragraph formatting Paragraph spacing and indents Automatic formatting

Lesson 5: Tables

• Creating tables
• Working with table content Changing the table structure

Lesson 6: Page layout

• Headers and footers Margins
• Page breaks

Lesson 7: Proofing and printing documents

• Checking spelling and grammar Using Auto Correct
• Finding and replacing text Printing documents
• PDF and XPS documents

Lesson 8: Graphics
Adding graphics and clip art Working with graphics.

MS Words 2013 - Advance

Lesson 1: Styles and outlines
Examining formatting Creating styles Modifying styles Working with outlines

Lesson 2: Sections and columns
Creating and formatting sections Working with columns

Lesson 3: Formatting tables

• Table formatting basics Borders and shading Table data
• Table styles

Lesson 4: Printing labels and envelopes
Labels Envelopes

Lesson 5: Templates and building blocks
Template basics Building blocks Document properties

Lesson 6: Graphics

• Creating diagrams
• Using the Drawing tools Formatting text graphically

Lesson 7: Managing document revisions
Tracking changes Working with comments

Lesson 8: Web features
Web pages Hyperlinks

MS Power Point – Basic

Lesson 1: Getting Started with PowerPoint

• Navigate the PowerPoint Environment
• Create and Save a PowerPoint Presentation
• Use Help

Lesson 2: Developing a PowerPoint Presentation

• Select a Presentation Type
• View and Navigate a Presentation
• Edit Text
• Build a Presentation

Lesson 3: Performing Advanced Text Editing

• Format Characters
• Format Paragraphs
• Format Text Boxes

Lesson 4: Adding Graphical Elements to Your Presentation

• Insert Clip Art and Images
• Insert Shapes

Lesson 5: Modifying Objects in Your Presentation

• Edit Objects
• Format Objects
• Group Objects
• Arrange Objects
• Animate Objects

Lesson 6: Adding Tables to Your Presentation

• Create a Table
• Format a Table
• Insert a Table from Other Microsoft Office Applications

Lesson 7: Adding Charts to Your Presentation

• Create a Chart
• Format a Chart
• Insert a Chart from Microsoft Excel

Lesson 8: Preparing to Deliver Your Presentation

• Review Your Presentation
• Apply Transitions
• Print Your Presentation
• Deliver Your Presentation

MS Power Point - Advance

Lesson 1: Modifying the PowerPoint Environment

• Customize the User Interface
• Set PowerPoint 2010 Options

Lesson 2: Customizing Design Templates

• Modify Slide Masters and Slide Layouts
• Add Headers and Footers
• Modify the Notes Master and the Handout Master

Lesson 3: Adding SmartArt to a Presentation

• Create SmartArt
• Modify SmartArt

Lesson 4: Working with Media and Animations

• Add Audio to a Presentation
• Add Video to a Presentation
• Customize Animations and Transitions

Lesson 5: Collaborating on a Presentation

• Review a Presentation
• Publish Slides to a Slide Library
• Share a Presentation on the Web

Lesson 6: Customizing a Slide Show

• Annotate a Presentation
• Set Up a Slide Show
• Create a Custom Slide Show
• Add Hyperlinks and Action Buttons
• Record a Presentation

Lesson 7: Securing and Distributing a Presentation
Secure a Presentation

MS Outlook - Basic

Lesson 1: Getting started
The program window Outlook Today Getting help

Lesson 2: E-mail

• Reading messages
• Creating and sending messages Working with messages Handling attachments

Lesson 3: E-mail management

• Setting message options Managing junk e-mail
• Using Search folders
• Printing messages and attachments

Lesson 4: Contacts
Working with contacts Using contact groups Using the People Pane

Lesson 5: Tasks
Working with tasks Managing tasks

Lesson 6: Appointments and events

• Creating and sending appointments Modifying appointments
• Working with events
• Using Calendar views

Lesson 7: Meeting requests and responses
Scheduling meetings Managing meetings

MS Outlook – Advance

Lesson 1: Customizing Outlook

• The Outlook environment General options
• Language and keyboard options Quick Steps
• The Navigation pane

Lesson 2: Working with contacts
Address books Contact groups

Lesson 3: Customizing messages

• Message appearance Signatures
• Voting buttons Out-of-office messages

Lesson 4: Organizing items
Folders Searching Filters Categories

Lesson 5: Organizing Mail
Organizing the Inbox folder Setting rules