ProfBurnett.com - Master a Skill / Learn for Life

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

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

    Session 1

    • Course Overview Presentation
    • Chapter 6: Advanced Workbook Formatting
    • Chapter 7: Date Functions and Conditional Formatting

    Session 2

    • Chapter 8: Financial Functions and What-If Analysis
    • Chapter 9: Text Functions, Conditional Functions, and Formula Auditing
    • Chapter 10: Lookup Functions and Outlines

    In-Class Material:


    Colleges and Universities