<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> Advanced Microsoft Excel Syllabus
Back to Technology Professional Development Main Page
Advanced Microsoft Office Excel Syllabus
Prerequisites
  • Intermediate Microsoft Office Excel
  • Using Web Mail
  • Technology Equipment Usage
  • Intermediate Computer Operating Systems

Session 1

Working with Functions

  • Multi Document Functions
  • Text functions

Session 2

Working with Versioning

  • Document Versioning

Session 3

Collaboration

  • Tracking Changes
  • Adding Comments
  • Microsoft Sharepoint Portal Server

Session 4

Working with Charts

  • Creating pivot tables

Session 6

Working with Data

  • Grouping
  • Statistical Analysis

Session 8

Automating Tasks

  • Recording Macros
  • Running Macros

Session 10

Working with Templates

  • Creating Templates
  • Creating Protected sheets and Forms