Microsoft Word & Excel Training (Beginning, Intermediate, & Advanced)

back to Computer Technologies

 

 

Tuition Includes
Microsoft Office Certification Testing

Microsoft Word Beginning

  • Word Processing
  • User Preferences
  • Commands
  • Working with Toolbars
  • Formatting
  • Selecting Fonts
  • Color Features
  • Inserting and Deleting Text
  • Saving Document
  • Using Bullets
  • Spell Check, Grammar, etc.

 

 

 

Microsoft Word Intermediate

  • Short Cuts
  • Copy Formatting
  • Tab Settings
  • Section Breaks
  • Page Numbering
  • Auto Correct
  • Word Count
  • Date & Time
  • Outlines
  • Print Layout
  • End Notes & Foot Notes
  • Headers & Footers
  • Creating Tables
  • Gridlines, Borders
  • Keyboarding

Microsoft Word Advanced

  • Review of Beginning & Intermediate
  • Using Templates, Wizards, Graphics, Style, Clip Art
  • Moving & Resizing Graphics, Shapes, Diagrams,
  • Watermarks, Word Art, Insertion of Pictures and Clip Art
  • Mail Merge, Mailing Labels, Envelopes
  • Outlook, Emailing, Attachments
  • Tutorials
  • Creating Business Letters, Memorandums,Resumes, and Other Correspondence

Microsoft Excel Beginning

  • Creating Worksheets
  • Starting & Closing Excel
  • Parts of Excel Screen
  • Toolbars
  • Entering data
  • Changing an Active Cell
  • Selecting Cells
  • Scrolling through Document
  • Creating Folders and Saving Files,
  • Naming/re-naming worksheets
  • Editing, Deleting
  • Adding/Deleting rows and columns
  • Changing Row Height, etc.
  • Changing Column Width
  • Changing Fonts
  • Formatting
  • Preview and Printing

Microsoft Excel Intermediate

  • Setting up a Spreadsheet
  • Inserting Times & Dates
  • Using Auto Complete
  • Using Cell & Range Names
  • Selecting Range of Cells
  • Protecting Cells
  • Using a DAT List
  • Sorting & Filtering Data
  • Introduction to Formula and Functions
  • Perform common calculations
  • Copy & Paste
  • Checking for Errors
  • Help Key

Microsoft Excel Advanced

  • Creating Charts
  • Adding Graphics
  • Using the Wizard to Create a Chart
  • Moving & Resizing
  • Formatting Chart Elements
  • Deleting a Chart
  • Adding Data to a Chart
  • Adding AutoShape to a Worksheet
  • Using Textbox
  • Adding Pictures, Graphics, Clip Art
  • Adding Headers & Footers
  • Changing the Margins
  • Page Breaks
  • Repeating Rows & Columns
  • Customization
  • Using Microsoft WEB site for Help
  • Tutorials