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

    Session 1

    • Course Overview Presentation
    • Overview: Intro to MS Office and Common Features
    • Chapter 1: Tracking Customer Data
    • Chapter 2: Calculating Student Grades Using Formulas

    Session 2

    • Chapter 3: Performing Calculations Using Functions
    • Chapter 4: Data Visualization and Images
    • Chapter 5: Organizing Large Worksheets

    In-Class Material:


    Colleges and Universities