Skip to main content

Course Content


Topic outline

  • In this Excel 2016 tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.

  • Lesson 1 (Getting Started with Excel)

    Introduction

    Excel is a spreadsheet program that allows you to storeorganize, and analyze information. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.


    • View

      Getting Started with Excel

    • Test your knowledge

  • Lesson 2( Understanding One Drive)

    In this lesson, the student is expected to understand and appreciate OneDrive

  • Lesson 2 (Creating and Opening Workbooks)

    In this lesson the following topics will be looked at:

    • Creating a new workbook
    • Opening an existing workbook
    • Pinning a workbook
    • Create a new workbook from a template

    • View

      Creating and opening workbooks

    • Test your knowledge

  • Lesson 4 (Saving and Sharing Workbooks)

    In this lesson the following topics will be looked at:

    • About OneDrive
    • Saving a workbook
    • Sharing a workbook
    • Auto Recover
    • Exporting a workbook

    • View

      saving and Sharing Workbooks

    • Test your knowledge

  • Lesson 5 (Cell Basics)

    In this lesson we will look at the following topics:

    • Understanding cells
    • Cell content
    • Inserting and deleting cell content
    • Copy and paste cell content
    • Using the fill handle

  • Lesson 6(Modifying Columns,Rows and Cells)

    In this lesson the following topics will be looked at:

    • Modify column width, row, and height
    • Inserting, deleting, moving and hiding columns and rows
    • Wrapping text and merging cells

  • Lesson 7(Formatting Cells)

    In this lesson the following topics will be covered:

    • Changing font size
    • Using Bold.Italic and Underline
    • Cell styles
    • Text Alignment

  • Lesson 8 (Understanding Number Formats)

    in this lesson the following topics will be covered:

    • What are the number formats?
    • Why use number formats?
    • Applying number formats
    • The different number formats in excel

  • Lesson 9(Working with Worksheets)

    In this lesson the following topics will be covered:

    • Inserting a worksheet
    • Copying, renaming and changing a worksheet
    • Deleting and switching between worksheets
    • Grouping and ungrouping worksheets

  • Lesson 10 ( Using find and Replace)

    In this lesson, the following topics will be covered:

    • Using the find function in Excel
    • Using the replace function in Excel

  • Lesson 11 (Checking spelling)

    In this lesson the topic to be covered will be:

    • Checking spelling in Excel

  • Lesson 12 (Page Layout & Printing)

    In this lesson the following topics will be covered:

    • Using the print pane
    • Printing in Excel
    • Page Layout in Excel

  • Post Course Evaluation

    Please take time to answer the following questions truthfully so that we can improve the delivery of our course.