Think Business Training
IN PARTNERSHIP WITH THE AAP

There are no items in your cart
Microsoft Office 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

Customers who viewed this product ultimately purchased

Stay in the loop

Spam-free insight direct to your inbox.

Name

CCAPA Certification from Think Training in Partnership with the AAP

THINK TRAINING

IN PARTNERSHIP WITH THE AAP

Certification

Overview

Courses

Pricing

FAQ