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:   Feb 23, 2021 - Mar 04, 2021
  • Number of Sessions:   4
  • Time:   09:00 AM - 12:00 PM
  • Location:   Online
  • Lesson Plan:

    Session 1

    • Course Overview Presentation
    • Chapter 6: Advanced Workbook Formatting

    Session 2

    • Chapter 7: Date Functions and Conditional Formatting

    Session 3

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

    Session 4

    • Chapter 10: Lookup Functions and Outlines

    In-Class Material:

    LinkedIn Microsoft Office Specialist Certifications

    LinkedIn Microsoft Office Specialist for Office 2019 and Office 365 & Excel Certification Program
    Level Course
    Certification Overview Microsoft Office Specialist for Office 2019 and Office 365
    Associate Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019 and Office 365
    Expert Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

    Colleges and Universities