Microsoft Excel - Essentials

Learn how to use Microsoft Excel to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. This course is intended for students who wish to gain the foundational understanding of Microsoft Excel.

Description

After completing this excel course, you will know how to:

  • Enter and edit text and values; use AutoFill; enter formulas and examine the order of operations; save and update a workbook; and save a workbook in different file formats.
  • Use the SUM function, AutoSum, and the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations in a worksheet.
  • Create, format, modify, and print charts based on worksheet data; work with various chart elements; and apply chart types and chart styles.
  • Check spelling; find and replace text and data; preview and print a worksheet; set page orientation and margins; create and format headers and footers; and print gridlines.
  • Recognise spreadsheet terminology; start Microsoft Excel and identify the components of the Excel interface; create a blank workbook; navigate.

Prerequisites

You should be comfortable with the Windows environment.

Target Audience

New Microsoft Excel users or those wanting to cement their foundational knowledge.

?