Workforce Training Consortium

Course Title:            Intermediate Microsoft Excel (201.500)

Course Length:      8 hrs

Prerequisites:  Beginning Excel or basic understanding of Excel

Objective:                     

Session 1

  •  IF statements

  • Inserting, deleting and moving columns & rows

  • Auto Correct

  •  Freezing titles

  • Workbook sheets

  • Naming Ranges

  • Working with Dates

  • Printing rows & columns on multiple pages

Session 2

  • Copying & Paste Special between worksheets

  • Working with multiple worksheets & workbooks

  • Creating a Template

  • Linking Workbooks

  • 3D Formulas

Session 3

  • WHAT-IF tables

  • VLOOKUP & HLOOKUP function

  • Customizing Your Toolbar

  • Protecting worksheets

  • Working with dates

Session 4

  • Database

  • Using Excel as database

  • Sorting

  • Mail Merge

  • Charting

  • Use forms to input

 

This course is designed for experienced Microsoft Excel users.

Course Content:

Equipment Needed:

Microsoft Office software, Lap Top Computers