 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
ECDL Advanced Spreadsheets with Excel 2000
Course Aims
This courses will teach the reader to use the spreadsheet application Microsoft Excel 2000 with a high level of competence. You will be able to create workbooks incorporating custom and conditional formatting, multiple worksheets and advanced formulae and charts. You will also learn to use data analysis and auditing tools, import and export data, use the reviewing tool to collaborate on editing tasks with other users and create macros to automate tasks. You can use this course to prepare for the ECDL Spreadsheets Advanced Syllabus 3.0. |
Assumed Knowledge
Previous experience with Microsoft Excel is required. Users should be able to create, format and print workbooks incorporating basic formulae, borders, shading and graphics, value formatting, headers/footers and charts. |
Course Audience
This course will benefit existing users of Microsoft Excel, especially those who have obtained an ECDL in basic Spreadsheets (using Excel 2000). |
|
Table of Contents
|
Customising Cell Formats
|
Apply Automatic Formatting to a Range
|
|
Create Custom Number Formats
|
|
Copy and Paste Cell Formatting
|
|
|
|
Importing and Exporting Data
|
Object Linking and Embedding
|
|
Import a Delimited Text File into Excel
|
|
|
|
Linking Worksheets and Workbooks
|
Open More Than One Workbook
|
|
Split a Worksheet into Panes
|
|
Link Data Between Worksheets
|
|
Consolidate Data Using 3D References
|
|
Link Data Between Workbooks
|
|
|
|
Customising Charts
|
Modify the Layout of Chart Elements
|
|
Explode Segments of a Pie Chart
|
|
Change the Chart's Source Data
|
|
Create a Combination Chart
|
|
Insert an Image Into a Chart
|
|
|
|
Workbook Templates
|
Create a Workbook Template
|
|
Change the Default Template
|
|
|
|
Auditing a Worksheet
|
Trace Precedent and Dependent Cells
|
|
Display Formulae in Worksheet Cells
|
|
Add and Edit Worksheet Comments
|
|
|
|
Protecting a Worksheet
|
Password Protect a Worksheet
|
|
Password Protect a Workbook
|
|
Hide Rows, Columns and Worksheets
|
|
|
Advanced Formulae
|
Use Date and Time Functions
|
|
Use Mathematical Functions
|
|
Use Statistical Functions
|
|
|
|
|
Lookup and Reference Functions
|
|
|
Data Management
|
Use a Form to Enter and Edit Records
|
|
Summarise Data with Outlines
|
|
|
|
Using Data Analysis Tools
|
Use a Data Table to Perform What-If? Analysis
|
|
Create a Scenario Summary
|
|
|
|
PivotTables
|
Use a PivotTable to Analyse Data
|
|
Modify the Data Source for a PivotTable
|
|
|
|
Workbook Macros
|
Set the Reference Type for Macro Actions
|
|
Assign a Macro to a Toolbar or Menu
|
|
|
|
|
|
