|
|
Advanced Module 4
Advanced Spreadsheets
Editing
-
Naming a cell range
-
To autoformat a cell range
-
To create a custom number format
-
What is ‘conditional formatting’?
-
To use the paste special command
-
To import text into a worksheet using the text import wizard
Display
-
To freeze/ unfreeze row and column titles at the same time
-
To hide rows/ columns
-
To re-display hidden rows/ columns
-
To hide worksheets
-
To re-display hidden worksheets
-
To create subtotals
-
To use a one input Data Table command
-
To use a two input data table command
Protection
-
To protect /un-protect a worksheet
-
To protect /unprotect cells
Security
-
To specify a password for opening a workbook
-
To specify a password for saving a workbook
-
To use the ‘read-only recommended’ option
-
To use the ‘Always create backup’ option
-
To protect a workbook
-
To un-protect a workbook
-
To remove a password from an Excel workbook
Data Handling
-
Sorting
-
Querying / filtering
-
To link individual cells within a worksheet
-
To link charts to data within a worksheet
-
To link a cell range on one worksheet to another worksheet
-
To link data on one worksheet to a chart in another worksheet
-
To link charts between worksheets
-
To link data from one workbook to another
-
To link a chart from one workbook to another
-
Copying a chart from one workbook to another
-
To embed data (or a chart) from excel into word
-
To paste link selected excel data / chart to word
-
To consolidate data over several worksheets
-
Templates
-
Charts & Graphs
Functions
-
Using Functions
-
Insert Function utility
-
Ways to access the Function Wizard
-
To use the Insert Function to enter a function
-
What are nested functions?
Analysis
-
Pivot tables / dynamic crosstab
-
Scenarios / versions
-
What is the ‘scenario manager’?
-
Auditing
Special Tools
|
|