Computer Skills

The certificate program in Microsoft Office consists of five courses that provide a quick review of basic PC and Windows operations followed by detailed instruction on using the three most popular applications of Microsoft Windows; Word, Excel and PowerPoint. The program includes specific instruction for each application including theory and a hands-on project, followed by lessons that teach how to integrate applications like Word with PowerPoint and Word with Excel

Microsoft Office Word- Basics

Sharing and Maintaining Documents

  • Apply different views to a document
    • Selecting zoom options
    • Splitting and arranging windows (View Side by Side, Synchronous Scrolling)
    • Document views (reorganizing a document outline, master documents, subdocuments, web layout, draft)
    • Switching windows
    • Opening a document in a new window
  • Save a Document
    • Using compatibility mode, protected mode
    • Save As options
  • Apply a template to a document
    • Finding templates (locating a template on your disk, finding templates on the web)

Formatting Content

  • Apply font and paragraph attributes
    • Apply character attributes
    • Apply styles
    • Use Format Painter
  • Navigate and search through a document
    • Using the Navigation Pane (headings, pages, results), Go To, Browse by button, and Highlight features
    • Setting Find and Replace options (format, special)
  • Apply indentation and tab settings to paragraphs
    • Applying indents (first line, hanging)
    • Setting tabs
    • Using the Tabs dialog box
    • Setting tabs on the ruler
    • Clearing tabs
    • Setting tab stops
    • Moving tab stops
  • Apply spacing settings to text and paragraphs
    • Line spacing
    • Paragraph spacing
  • Create tables
    • Using the Insert Table dialog box
    • Using Draw Table
    • Inserting a Quick Table
    • Converting text to tables
  • Manipulate tables in a document
    • Sorting content
    • Adding a row to a table
    • Adding a column to a table
    • Splitting, merging, moving, resizing, and deleting a row or column
    • Defining the header ro
    • Converting tables to text
    • Viewing gridlines
  • Apply bullets to a document
    • Applying bullets
    • Selecting a symbol format
    • Defining a picture to be used as a bullet

Applying Page Layout and Reusable Content

  • Apply and manipulate page setup settings
    • Setting margins, non-breaking spaces, hyphenation, and columns
    • Working with breaks
    • Forcing a page break
    • Inserting a section break
    • Inserting a blank page into a document
  • Construct content in a document by using the Quick Parts tool
    • Adding built-in building blocks (quotes, text boxes, headers, footers, cover pages, watermarks, equations)
  • Create and manipulate page backgrounds
    • Formatting a document’s background
    • Setting a colored background
    • Adding a watermark
    • Placing page borders
  • Create and modify headers and footers
    • Inserting and formatting page numbers
    • Inserting the current date and time
    • Inserting a built-in header or footer
    • Adding content to a header or footer (custom dialog box, manual entry)
    • Deleting a header or footer
    • Changing margins
    • Applying a different first page attribute

Including Illustrations and Graphics in a Document

  • Insert and format Pictures in a document
    • Adding captions
    • Applying artistic effects and picture styles
    • Compressing pictures
    • Modifying a shape
    • Adjusting position and siz
    • Inserting screenshots
  • Insert and format shapes, WordArt, and SmartArt , Clip Art
    • Adding text to a shap
    • Mmodifying text on a shape
    • Adding captions
    • Setting shape styles (border, text)
    • Adjusting position and size
  • Apply and manipulate text boxe
    • Format
    • Text box styles
    • Text direction
    • Shadow effects
    • 3-D effects

Proof reading documents

  • Validate content by using spelling and grammar checking options
    • Grammar and style options
  • Configure AutoCorrect settings
    • Add
    • Remove
    • Exceptions
    • AutoCorrect dialog
  • Insert and modify comments in a document
    • Inserting a comment
    • Editing a comment
    • Deleting a comment
    • Viewing a comment (view comments from another user, view comments inline, view comments as balloons)

Microsoft Office Word- Advanced

Applying References and Hyperlinks

  • Apply a hyperlink
    • Hyperlink using text
    • Hyperlink using graphic
    • Headings and bookmarks
    • Create new document
    • E-mail address
  • Create Endnotes and Footnotes in a document
    • Manage footnote and endnote location
    • Configure footnote and endnote format
    • Presentation

Performing Mail Merge Operations

  • Setup mail merge
    • Perform a mail merge using the Mail Merge Wizard
    • Perform a mail merge manually
    • Auto check for errors
  • Execute mail merge
    • Print
    • Preview

Review and collaborating Documents

  • Track changes and set change tracking options
  • View changes, additions and comments
  • Use the Reviewing Pane
  • Choose what changes to show
  • Accept and Reject changes

Comparing and Combining Documents

  • Compare the documents to find out the changes
  • Combine the documents together

Develop Documentation using Macros

  • Record a macro
  • Run the macro
  • View the macros
  • Delete a macro

Random Useful Items

  • Customize the Ribbon
  • Editing pdf documents as MS Word application

Microsoft Office Excel- Basics

Getting Started with Microsoft Excel

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

Performing Calculations

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

Modifying a Worksheet

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

Formatting a Worksheet

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

Printing Workbook Contents

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

Managing Large Workbooks

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

Microsoft Office Excel- Advanced

Working with formula/ Functions

  • Lookup and Reference Functions
  • Logical functions
  • Database functions
  • Date and time functions
  • Information functions
  • Math and Trigonometry functions
  • Statistical Functions
  • Text functions

Working with Conditional Formatting

  • Finding cells with conditional formatting
  • Use customized rules in conditional formatting
  • Clear conditional formatting

Data Sorting and Filtering

  • Custom sort order
  • Using autofilter
  • Creating the advanced filter
  • Applying multiple criteria
  • Using complex criteria

Data Validation

  • Allow a cell as drop down menu
  • Restrict the cell with some inputs only

Pivot Tables and Charts

  • Analyzing data with Pivot tables and charts
  • Creating and manage Scenarios and Summaries
  • Applying pivot table styles
  • Sorting and filtering pivot table data

Introduction of Macro

  • Recording macros
  • Running and deleting recorded macro
  • Working with the Personal macro workbook

Consolidation of worksheets

  • Consolidating data from all the worksheets
  • Apply different views to a workbook
  • Selecting zoom options
  • Splitting and arranging windows (View Side by Side, Synchronous Scrolling)
  • Worksheet views
  • Switching windows
  • Opening a worksheet in a new window

Security and Protection Option

  • Cell protection
  • Workbook Protection
  • Integrate the excel document with some other applications
  • Some Useful tips

Microsoft Office PowerPoint

Presentation Planning

  • Audience and Environmen
  • Design, Content and Layout

Slide Masters and Templates

  • Insert a new slide masterg
  • Edit slide master layouts
  • Working with templates

Graphical Objects

  • Formatting Drawn Objects
  • Formatting Pictures, Images
  • Handling Graphical Objects

Charts and Diagrams

  • Using Charts
    • Format chart title, legend, data labels, axes labels.
    • Change the chart type for a defined data series.
    • Change the gap, overlap between columns, bars in a chart.
    • Format columns, bars, plot area, chart area to display an image
  • Using Diagrams
    • Create using built- in options or other available drawing tools a diagram like: flowchart, cycle, pyramid.
    • Add, move, delete shapes in a diagram

Multimedia

  • Working with Movies and sounds
  • Animations

Enhancing Productivity

  • Linking and embedding Objects
  • Importing and exporting data

Managing Presentations

  • Custom show
  • Slide show settings
  • Slide show Controls

Program Outcomes:

Upon completion of the program, students will be able to:

  1. Demonstrate the fundamental skills needed to use the MS Word word-processing application
  2. Create new Word documents, edit and format existing Word documents, add graphics and tables to Word documents, and merge Word documents
  3. Demonstrate the fundamental skills needed to use the MS Excel spreadsheet application
  4. Use the basic elements of Excel, create and use simple and complex formulas and functions, incorporate useful charts and graphs, add, delete, sort, and lay out table data
  5. Demonstrate the fundamental skills needed to use MS PowerPoint presentation application
  6. Create a PowerPoint presentation, work with PowerPoint tools, tables, and charts, apply Slide Master, shapes, and effects to a presentation, insert hyperlinks, illustration objects, and media clips
  7. Identify the tools used to integrate Word and Excel files
  8. Identify the tools used to integrate Word, Excel, and PowerPoint files

Contact Us

Request more information