ProfBurnett.com - Master a Skill / Learn for Life

Microsoft Excel 2019 & 365: 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

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:   3/3/2020 - 3/5/2020
  • Number of Sessions:   2
  • Time:   09:00 AM - 03:30 PM
  • Location:   GBTC - 408
  • Lesson Plan:

    Session 1

    • Course Overview Presentation
    • Chapter 10: Lookup Functions and Outline
    • Chapter 11: Working with Tables
    • Chapter 12: PivotTables and PivotCharts

    Session 2

    • Chapter 13: Working with Macros
    • Chapter 14: Data Management for Business
    • Chapter 15: Workbook Completion

    In-Class Material:


    Colleges and Universities