ProfBurnett.com

ITI 305 MS Excel 2016 Level III

Course Outline:

Work with advanced formulas, lookup functions. Learn data validation; how to import/ export data. Work with PivotTables and PivotCharts. Use analytical features -Goal Seek and Analysis tool, run and record macros. Students pursuing the Microsoft Office Specialist Certification must take MS Excel I, II and II.

Prerequisites:

MS Excel-Level II or equivalent experience.

Required Textbook & Materials

  • Title:   Excel 2016 Level 3
  • ISBN:   978-1-943248-58-2
  • 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:   6/12/2018 - 6/14/2018
  • Number of Sessions:   2
  • Time:   09:00 AM - 03:30 PM
  • Location:   GBTC - 408
  • Lesson Plan:

    Session I

    • Course Overview Presentation
    • Chapter 1: Logical and Lookup Functions
    • Chapter 2: Advanced Formulas
    • Chapter 3: Special functions

    Session II

    • Chapter 4: Importing and Exporting
    • Chapter 5: Analysis
    • Chapter 6: Macros and Forms

    In-Class Material: