Module 1: Principles of Spreadsheets

After completing this module, the learner will be able to demonstrate an understanding of the principles of spreadsheets.

• Define spreadsheet in terms of its purpose and use
• Name examples of spreadsheet programs
• Provide examples of spreadsheets that can be produced using a spreadsheet application
• Explain the benefits of using a spreadsheet application for producing and working with spreadsheets
• Identify and describe the properties of a spreadsheet in terms of its purpose and use
• Work within organisational standards and procedures with MS Excel

Module 2: Getting Started with Excel

If you are new to Excel and spreadsheets in general, the vast array of features and controls can seem quite daunting. However, once we cover the workings of a spreadsheet and how to deal with the basics, you will be well on your way to becoming an expert in Excel. 

• Open Microsoft Excel
• Identify the elements of the Excel interface
• Create a basic worksheet § Navigation options
• Save and close spreadsheets and excel
• Use the help system in Microsoft Excel

Module 3: Performing Calculations

One of the most powerful features in Excel is the ability to perform real-time calculations on data within workbooks. Using these powerful features allows you to save time and reduce errors when trying to calculate complex and simple equations.

• Create formulas in a worksheet
• Demonstrate practices to ensure the integrity of the data

Module 4: Modifying a worksheet

One of the most basic and common tasks that you will complete using Excel is modifying the contents of your worksheets. This topic covers various tools that you can use to work with the data in your worksheets in the most efficient ways possible.

• Manipulate data
• Insert, manipulate, and delete cells, columns, and rows
• Search for and replace data

Module 5: Formatting a Worksheet

Excel contains many of the text formatting tools that you might be familiar with from other Microsoft Office applications. In this topic, we will learn about a variety of different font options, as well as how to use the Format Painter, the mini toolbar, and more.

• Modify fonts
• Add borders and colors to cells
• Apply number formats
• Align cell contents
• Apply cell styles

Module 6: Check and print the spreadsheet

It is often the case that printouts of your workbook (or parts of your workbook) will be required for one purpose or another. In this topic, we will explore how to check for spelling and grammar and use the printing functionality in Excel

• Check spelling and grammar in spreadsheet
• Define the basic page layout for a workbook
• Refine the page layout and apply print options

Module 6: Customizing the Excel Environment

In this lesson, you will begin examining how to customize Microsoft Excel 2016 to suit your specific needs.

• Customize general, language, formula, proofing, and saving options
• Use Excel’s version control features
• Customize the ribbon and the Quick Access toolbar
• Customize the functionality of Excel by enabling add-ins
• Customize advanced and Trust Center options