Welcome to the Module called Microsoft Excel 365 Advanced 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, practising, 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:
- Import and export text files.
- Consolidate and link data within spreadsheets.
- Apply filters and use forms in a spreadsheet.
- Create and using macros.
- Combine and compare large sets of data in a spreadsheet.
- Create and edit a graph/chart.
- Load data from an external data source to produce a given spreadsheet result.
- Insert and edit objects in a spreadsheet.
Microsoft Excel 365 Advanced – Content List
- Work With Multiple Worksheets
- Multiple Sheets
- Renaming Sheets
- Insert and Delete Sheets
- Copy and Move Sheets
- Worksheet Groups
- Applying formulas across sheets
- Prepare And Produce A Spreadsheet
- Naming ranges
- Working with named ranges
- Deleting a named range
- Creating names from a selection
- Using the Clipboard Group
- Using Paste Special
- Working with Links
- Editing Links
- Worksheet Protection
- Data Commands
- Sorting and filtering data
- Validation
- Subtotals
- Grouping and Outlining
- Using the Consolidate command
- Working with Advanced Filters
- Working with External Data
- Importing data from a text file
- Working with a data form
- Advanced Functions
- Database Functions
- Lookup Functions
- Logical Functions
- Text Functions
- CUSTOMISING MICROSOFT EXCEL
- Setting Excel Options
- Excel Add-ins
- Customising the Quick Access toolbar
- Pivot Tables
- Understanding Pivot tables
- Creating a Pivot table
- Add, copy, rearrange, and remove fields
- Add a calculated field
- Using the Pivot table filters
- Changing Pivot table data
- Modifying the Pivot Table placement
- Change Active Field settings
- Change Pivot Table options
- Change the Pivot Table layout
- Change the Pivot Table design
- Change the Pivot Table Tools design style options
- Insert Slicers for your Pivot table
- Creating Pivot Charts
- Working With Charts
- Why do we use charts/graphs?
- Chart terminology
- Creating a chart
- Setting or changing the chart type
- Chart Titles
- Chart Location
- Moving, Resizing and Deleting charts as Objects
- Formatting a chart
- Printing charts
- Working with Sparklines
- Using the Drawing Tools and Pictures
- Macros
- Understanding Macros
- Developer Tab
- Macro Security levels
- Trusted locations
- Recording a macro
- Running Macros
- Assigning Macros to Objects
