Topic outline

• About the Course

  Collapse all Expand all

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

  • 

    Forum

    Announcements Forum

• Lesson 1 (Getting Started with Excel)

  Introduction

  Excel is a spreadsheet program that allows you to store, organize, 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.

  
  

  • Mark as done

    Watch Video: Getting Started with Excel

     

     
    

  • 

    File

    Notes File

    View

    Getting Started with Excel

  • 

    File

    Exercise 1 File

    View

    Test your knowledge

• Lesson 2( Understanding One Drive)

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

  • 

    File

    Notes File

    View

    Understanding 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

  • Mark as done

    Watch the video : Creating and opening Workbooks

     

     
    

  • 

    File

    Notes File

    View

    Creating and opening workbooks

  • 

    File

    Exercise 2 File

    View

    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

  • Mark as done

    Watch Video: Saving and Sharing Workbooks

     

     
    

  • 

    File

    Notes File

    View

    saving and Sharing Workbooks

  • 

    File

    Exercise 3 File

    Mark as done

    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

  • 

    File

    Practice Workbook File

    View

    Download our practice workbook. You will need it for exercise 4

  • Mark as done

    Watch Video: A faster way to use the fill handle

     

     
    

    
    

  • 

    File

    Notes File

    View

    Cell Basics

  • 

    File

    Exercise 4 File

    View

    Test your knowledge

• 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

  • 

    File

    Practice Workbook File

    View

    Download our practice workbook. You will need it for Exercise 5

  • 

    File

    Notes File

    View

    Modifying columns, rows, and cells.

  • 

    File

    Exercise 5 File

    View

    Test your knowledge

• 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

  • 

    File

    Practice Workbook File

    View

    Download our practice workbook. You will need it for Exercise 6

  • 

    File

    Notes File

    View

    Formatting Cells

  • 

    File

    Exercise 6 File

    View

    Test your knowledge

• 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

  • 

    File

    Practice Workbook File

    View

    Download our workbook. You will need it for Exercise 7

  • 

    File

    Notes File

    View

    Understanding Number Formats

  • 

    File

    Exercise 7 File

    View

    Test your knowledge

• 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

  • 

    File

    Practice Workbook File

    View

    Download our practice workbook. You will need it to do Exercise 8

  • 

    File

    Notes File

    View

    Working with worksheets

  • 

    File

    Exercise 8 File

    View

• 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

  • 

    File

    Practice Workbook File

    View

    Download our practice workbook. You will need it to do Exercise 9

  • 

    File

    Notes File

    View

    Using find and replace

  • 

    File

    Exercise 9 File

    View

    Test your knowledge

• Lesson 11 (Checking spelling)

  In this lesson the topic to be covered will be:

  • Checking spelling in Excel

  • 

    File

    Practice Workbook File

    View

    Download our practice workbook, You will need it to a do Exercise 10

  • 

    File

    Notes File

    View

    Check Spelling

  • 

    File

    Exercise 10 File

    View

    Test your knowledge

• 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

  • 

    File

    Practice Workbook File

    View

    Download our practice workbook. You will need it to do Exercise 11

  • 

    File

    Notes File

    View

    Page Layout & Printing

  • 

    File

    Exercise 11 File

    View

    Test your knowledge

• Post Course Evaluation

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

  
  

  • 

    Feedback

    Click to answer questions Feedback

    View Submit feedback