Microsoft Office 2016 Excel Beginners

Course details

Unit 1: Introducing Microsoft Excel

• About Microsoft Excel
• Start Microsoft Excel 2016
• Quit Microsoft Excel 2016
• The Excel 2016 environment

Unit 2: Saving, Closing and Opening Workbooks

• Start a new workbook
• Save a new workbook
• Save changes to an existing workbook
• Create a new folder
• Rename an existing folder
• Save an existing workbook with a new name and/or in a new location
• Save an Excel file as a PDF
• Open an existing workbook
• Close a workbook

Unit 3: Entering and Editing Data

• Enter text and numbers in a worksheet
• Edit text and numbers in a worksheet
• Find and replace text
• Move and copy data
• Check spelling
• Navigate and select cells and ranges

Unit 4: Basic Formulas

• About formulas
• Insert a formula
• Work with operators and order of operations
• Copy formulas using AutoFill
• Copy formulas with Relative and Absolute cell references

Unit 5: Using Functions

• About functions
• Ranges as arguments
• Insert simple functions
• Basic functions SUM(), AVERAGE(), MAX(), MIN(), COUNT()

Unit 6: Formatting a Worksheet

• Format text
• Work with cell alignment
• Format numbers
• Change cell fills
• Change cell borders
• Copy cell formats
• Insert, delete, hide and show columns, rows and cells

Unit 7: Working with Workbooks and Worksheets

• Switch between open workbooks
• Insert and delete worksheets
• Move and copy worksheets
• Change the colour of sheet tabs
• Hide and unhide worksheets
• View different parts of a worksheet
• View multiple workbooks or worksheets at the same time

Unit 8: Page Setup and Printing

• Print preview a worksheet
• Set up paper size, orientation and margins
• Insert headers and footers
• Set horizontal and vertical print titles
• Adjust page breaks
• Adjust print settings
• Set and clear a print area
• Print your worksheet, workbook or selection Updated on 08 February, 2023