Welcome to Microsoft Office 365, Excel Beginners. On this page, you will see a summary of what to expect in our PDF pack. This content is developed in alignment with unit standard 116937: Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets.
The Pack Contains: Learner Guide, Facilitator Guide, Assessment Guide
People accredited with this Unit Standard are able to:
- Demonstrate an understanding of the principles of spreadsheets
- Create, open and save spreadsheets
- Produce a spreadsheet from a given specification
- Edit a spreadsheet
- Format a spreadsheet
- Check spelling in a spreadsheet
- Print a spreadsheet using features specific to spreadsheets.
Microsoft 365 Excel Beginners – Content List
Spreadsheet principles
- What is a spreadsheet?
- Why use a spreadsheet application?
- What are the names of some spreadsheet programmes?
- Starting with spreadsheets
Starting the programme
- Understanding the screen
- Using the mouse
- Using the keyboard to move around the screen
- Entering data on a spreadsheet
- Editing data on a spreadsheet
- Entering data using the automatic fill
Working with file commands
- Saving a workbook
- Closing a workbook
- Opening an existing workbook
- Starting a new blank workbook
- Saving changes to a workbook
- Saving a workbook with a different Name
- Saving an Excel file in a different file format
- Deleting an Excel workbook file
- Exit the spreadsheet programme
Formatting spreadsheets
- Selecting cells for changes
- Formatting columns
- Formatting rows
- The Alignment command group
- The Number command group
- The Font command group
- Setting borders
Producing spreadsheets with formulas
- Entering formulas
- Filling formulas
- Using functions
- Checking your work
Editing spreadsheets
- Using the Cells command group
- Using the Clipboard command group
More features
- Check your spelling
- Using AutoCorrect
- Finding and replacing
- Getting help
Printing a worksheet
- Previewing the worksheet
- Using page layout
