You
will learn
·
How to create, modify, share and
revise workbooks using templates,
automated procedures and the Web
·
Retrieve, analyse and summarise
data.
====================
Audience
Holders of
ECDL or MOS Core level
Certification.
Anyone wishing to enhance their
employment opportunities..
====================
Duration
7 weeks X 3
hours
====================
Cost
Contact
Westgate
Computer Centre for details
|
|
Skill Sets
IMPORTING AND EXPORTING DATA
-
Import data to Excel
-
Export data from Excel
-
Publish worksheets and workbooks to
the web
|
Auditing Worksheets
-
Audit formulas
-
Locate and resolve errors
-
Identify dependencies in formulas
|
Managing Workbooks
-
Create, edit and apply templates
-
Create workspaces
-
Use Data consolidation
|
Summarise Data
-
Use subtotals with lists and ranges
-
Define and apply filters
-
Add group and outline criteria to
ranges
-
Use data validation
-
Retrieve external data and creat
queries
-
Create XML Web queries
|
Formatting Numbers
-
Create and apply custom number
formats
-
Use conditional formats
|
Working with ranges
-
Use named ranges in formulas
-
Use Lookup and Reference functions
|
Analysing Data
-
Create PivotTables, PivotCharts and
Reports
-
Forecast values with what-if
analysis
-
Create and display scenarios
|
Customising Excel
-
Customise toolbars and munus
-
Create, edit and run macros
|
Workgroup Collaboration
-
Modify passwords, protections and
properties
-
Create a shared workbook
-
Track, accept and reject changes to
workbooks
-
Merge workbooks
|
|
