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 2013 Level 3 Overview


Unit 1: Advanced functions and formulas

  • Topic A: Logical functions
  • Topic B: Conditional functions
  • Topic C: Financial functions
  • Topic D: Text functions
  • Topic E: Date and time functions
  • Topic F: Array formulas
  • Topic G: Calculation options

Unit 2: Lookups and data tables

  • Topic A: Using lookup functions
  • Topic B: Creating data tables

Unit 3: Advanced data management

  • Topic A: Validating cell entries
  • Topic B: Advanced filtering

Unit 4: Advanced charting

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

Unit 5: PivotTables and PivotCharts

  • Topic A: Working with PivotTables
  • Topic B: Modifying PivotTable data
  • Topic C: Formatting PivotTables
  • Topic D: Using PivotCharts
  • Topic E: PowerPivot

Unit 6: Exporting and importing data

  • Topic A: Exporting and importing text files

Unit 7: Analytical tools

  • Topic A: Goal Seek
  • Topic B: Scenarios
  • Topic C: Instant data analysis

Unit 8: Macros and Visual Basic

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

Unit 9: Accessibility and language features

  • Topic A: Accessibility considerations
  • Topic B: Internationalization

 

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.