ProfBurnett.com - Master a Skill / Learn for Life

Microsoft Excel 2019 & 365: Level I

Course Outline:

Learn the basic functions of Excel 2019. Learn spreadsheet terminology, windows components, help system, navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures, and save. Work with absolute and relative references, and ranges, rows, and columns. Create, modify charts. Basic formatting/ printing. Students pursuing the Microsoft Office Specialist Certification must take MS Excel I, II and III.

Prerequisites:

Computer Basics and Working with Windows or File Management Skills 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 09, 2021 - Feb 18, 2021
  • Number of Sessions:   4
  • Time:   09:00 AM - 12:00 PM
  • Location:   Online
  • Lesson Plan:

    Session 1

    • Course Overview Presentation
    • Overview: Intro to MS Office and Common Features
    • Chapter 1: Tracking Customer Data

    Session 2

    • Chapter 2: Calculating Student Grades Using Formulas

    Session 3

    • Chapter 3: Performing Calculations Using Functions
    • Chapter 4: Data Visualization and Images

    Session 4

    • Chapter 5: Organizing Large Worksheets

    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