There are no items in your cart
MS-Excel

Microsoft Office Excel


A one day intensive course to help you learn about this versatile productivity tool. At the end of the day you will have an understanding of the most popular time saving and job assisting tools.
$399.00  

Lesson 1: Performing Calculations

  • Create Basic Formulas 
  • Calculate with Functions 
  • Copy Formulas and Functions 

Lesson 2: Modifying a Worksheet

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

Lesson 3: Formatting a Worksheet

  • Modify Fonts 
  • Add Borders and Color to Cells 
  • Change Column Width and Row Height 
  • Apply Number Formats 
  • Position Cell Contents 
  • Apply Cell Styles 

Lesson 4: Printing Workbook Contents

  • Print Workbook Contents Using Default Print Options
  • Set Print Options
  • Set Page Breaks

Lesson 5: Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets in a Workbook
  • Manage the View of Large Worksheets

Lesson 6: Calculating Data with Advanced Formulas

  • Manage Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Lesson 7: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Calculate Data in a Table or Worksheet

Lesson 8: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Lesson 9: Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes I
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Lesson 10: Collaborating with Others

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access

Lesson 11: Working with Multiple Workbooks

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Lesson 12: Importing and Exporting Data

  • Export Excel Data
  • Import a Delimited Text File

You must be logged in to review a product
  • Back to top