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

 

 



 Course Search
Keyword
Course #
State

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


Microsoft Excel 2010 Level 3 Overview


Unit 1: Logical and statistical functions

  • Topic A: Logical functions
  • Topic B: Math and statistical functions

Unit 2: Financial and date functions

  • Topic A: Financial functions
  • Topic B: Date and time functions
  • Topic C: Array formulas
  • Topic D: Displaying and printing formulas

Unit 3: Lookups and data tables

  • Topic A: Using lookup functions
  • Topic B: Using MATCH and INDEX
  • Topic C: Creating data tables

Unit 4: Advanced data management

  • Topic A: Validating cell entries
  • Topic B: Exploring database functions

Unit 5: Exporting and importing

  • Topic A: Exporting and importing text files
  • Topic B: Exporting and importing XML data
  • Topic C: Getting external data

Unit 6: Analytical tools

  • Topic A: Goal Seek and Solver
  • Topic B: The Analysis ToolPak
  • Topic C: Scenarios

Unit 7: Macros and custom functions

  • Topic A: Running and recording a macro
  • Topic B: Working with VBA code
  • Topic C: Creating functions

 

 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 8/8/2017
 $199
Enroll
 8/8/2017
 $199
Enroll
 12/11/2017
 $199
Enroll
 12/11/2017
 $199
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.