ProfBurnett.com

ITI 091 MS Excel 2016 Level II

Course Outline:

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. Students pursuing the Microsoft Office Specialist Certification must take MS Excel I, II and III.

Prerequisites:

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

Required Textbook & Materials

  • Title:   Excel 2016 Level 2
  • ISBN-13:   978-1-943248-56-8
  • Publisher:   30Bird Media

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:   9/11/18 - 9/13/18
  • Number of Sessions:   2
  • Time:   9:00 AM - 03:30 PM
  • Location:   GBTC - 407
  • Lesson Plan:

    Session I

    • Course Overview Presentation
    • Chapter 1: Managing workbooks
    • Chapter 2: Named ranges
    • Chapter 3: Tables
    • Chapter 4: Summarizing data

    Session II

    • Chapter 5: PivotTables
    • Chapter 6: Presentation features
    • Chapter 7: Advanced charts
    • Chapter 8: Collaboration

    In-Class Material: