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
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
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  

To Inquire About Future Classes

Request a class date

if one is not scheduled.