ProfBurnett.com

MMMC MS Excel 2007 Level II

Course Objectives:

Create and use multiple worksheets and workbooks. Work with advanced formatting options, styles, and themes. Create outlines and subtotals, create and apply cell names, work with tables. Save workbooks as Web pages, insert and edit hyperlinks, and share workbooks by email. Auditing and protection are covered.

Prerequisites:

Working with Windows. MS Excel-Level I or equivalent experience.

Required Textbook & Materials

  • Title:   Excel 2007: Intermediate Student Manual
  • ISBN-13:   1423918134
  • SKU:   AX1423918134
  • Publisher:   AXZO ILT

Materials:


Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work.

Meeting Information:

  • Days:   Tuesday & Thursday
  • Dates:   12/13/2016 - 12/15/2016
  • Number of Sessions:   2
  • Time:   1:00 - 04:00 PM
  • Location:   MedStar Montgomery Medical Center - Olney, MD

    • Lesson Plan:

    Session I

    • Course Overview Presentation
    • Relative and Absolute Formulas
    • Chapter 1: Using Multiple Worksheets & Workbooks
    • Chapter 2: Advanced Formatting
    • Chapter 3: Outlining & Subtotals
    • Chapter 4: Cell & Range Names
    • Chapter 5: List & Tables

    Session II

    • Chapter 6: Web & Internet Features
    • Chapter 7: Advanced Charting
    • Chapter 8: Documents & Auditing
    • Chapter 9: Templates & Settings
    • Pivot Tables & PivotCharts

    In-Class Material:

    Student Files

    Instructional Files