Welcome to the Module called Microsoft Excel 365 Intermediate which is based on the unit standards:
116940 Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem (6 Credits) Level 3
258879 Change the appearance of a spreadsheet (3 credits) Level 3
The total credits for this module is 9 credits. You should therefore spend approximately 90 notional hours on this Unit. Notional hours are the total number of hours that you could spend on this module and could combine learning, practicing, self-evaluation, exercises and applying what you have learnt in your own work environment.
The Pack Contains: Learner Guide, Facilitator Guide, Assessment Guide
People accredited with this Unit Standard are able to:
- Prepare and produce a spreadsheet to provide a solution to a given problem
- Adjust settings to customise the view and preferences of the spreadsheet application
- Work with multiple worksheets
- Apply formulae to worksheets to provide alternative solutions to a problem.
- Apply simple built-in functions of the spreadsheet application to the given problem
- Apply formatting to a spreadsheet applicable to the given problem
- Use special effects to improve the presentation of the spreadsheet
- Evaluate a spreadsheet
- Outlining data in a spreadsheet.
- Modifying the display of spreadsheet data
- Applying conditional formatting to data
- Creating and use templates
- Working with comments
Microsoft Excel 365 Intermediate – Content List
- Prepare and produce a spreadsheet
- Planning and designing the spreadsheet
- Customise the view and preferences
- Minimising the Ribbon
- Customising the Quick Access Toolbar
- Changing the size of the screen display
- Freezing panes
- Splitting the screen
- Change the default file location
- Setting document properties
- Create a spreadsheet using a template
- Create a template from an existing spreadsheet
- Work with Multiple Worksheets
- Multiple Sheets
- Renaming Sheets
- Insert and Delete Sheets
- Copy and Move Sheets
- Worksheet Groups
- Using the Clipboard Group
- Using Paste Special
- Apply formulas to worksheets
- Entering Formulas
- Relative or Absolute Cell Addressing
- Link Formulas between worksheets
- Interpret and Correct Formula Error Messages
- Auditing Commands
- Error Checking
- Apply built-in functions
- What is a built-in function
- Creating Formulas Using Functions
- Date and Time Functions
- Financial Functions
- Statistical Functions
- Math and Trig Functions
- Apply formatting to a spreadsheet
- Formatting Rows and Columns
- Format Styles
- Format as Table
- Copy formats
- Conditional Formatting
- Protection
- Comments & Notes
- Print a Spreadsheet
- Previewing the spreadsheet
- Using the Page Break Preview
- Page Layout
- Printing a worksheet
- Working with Data
- Sorting data
- Filtering data
- Creating subtotals
- Outlining
- Evaluate a Spreadsheet
- Previewing the worksheet
- Using page layout
