Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

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.

?

Similar courses

Microsoft Excel - Data analysis and reporting

Gain the knowledge and skills to become familiar with advanced data-management features and functionality of Microsoft Excel. You will automate some common Microsoft Excel tasks, apply pivot analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data.

More Information
Microsoft Excel - Charts and pivot tables

This course will provide you with a comprehensive introduction to Microsoft Excel Tables, PivotTables and PivotCharts. Creating a PivotTable from a list of data in Excel is an excellent way to analyse the information collected. This course covers how to create a PivotTable and chart the results within in a PivotChart.

More Information
Microsoft Excel - What’s New!

Find out about excels latest features and how you can use it.

More Information

Press enter to see more results