KT-91171 Custom Excel 2010 Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Custom Excel 2010


Description: 

Unit 1: Entering and editing data

  • Topic A: Entering and editing text and values
  • Topic B: Entering and editing formulas
  • Topic C: Working with pictures
  • Topic D: Saving and updating workbooks

Unit 2: Modifying a worksheet

  • Topic A: Moving and copying data
  • Topic B: Moving and copying formulas
  • Topic C: Absolute and relative references
  • Topic D: Inserting and deleting ranges, rows, and columns

Unit 3: Using functions

  • Topic A: Entering functions
  • Topic B: AutoSum
  • Topic C: Other common functions

Unit 4: Charts

  • Topic A: Chart basics
  • Topic B: Formatting charts

Unit 5: Outlining and subtotals

  • Topic A: Outlining and consolidating data
  • Topic B: Creating subtotals

Unit 6: Tables

  • Topic A: Sorting and filtering data
  • Topic B: Advanced filtering
  • Topic C: Working with tables

Unit 7: Web and sharing features

  • Topic A: Saving workbooks as Web pages
  • Topic B: Using hyperlinks
  • Topic C: Sharing workbooks

Unit 8: Advanced charting

  • Topic A: Chart formatting options
  • Topic B: Combination charts
  • Topic C: Graphical elements

 
     
Prerequisite: 
 
   
     
Duration: 
1 Day  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.