Excel 2002 (xp) - effective use of
Short course
In London
Description
-
Type
Short course
-
Location
London
-
Duration
1 Day
create formulae with excel functions, including conditional and nested functions. produce a variety of reports and models including what if analysis and pivot tables. manipulate and analyse data using list management techniques. create and manage shared workbooks. create and use custom templates. prevent unauthorised changes to spreadsheets. automate repetitive tasks. use keyboard shortcuts where appropr
Facilities
Location
Start date
Start date
Reviews
Course programme
after completing this course, participants will be able to:
- create formulae with excel functions, including conditional and nested functions
- produce a variety of reports and models including what if analysis and pivot tables
- manipulate and analyse data using list management techniques
- create and manage shared workbooks
- create and use custom templates
- prevent unauthorised changes to spreadsheets
- automate repetitive tasks
- use keyboard shortcuts where appropriate
topic
- review excel essentials-relative & absolute references, range finder, range names, paste function, logical functions
- formatting-format painter, conditional formats, number formats, custom formatting, protection - protect cell contents, password protection
- functions & formulae-logical, vlookup & hlookup, financial, reference, statistical, multiple conditions, nested functions
- data analysis-working with arrays, data tables, goal seek, scenario manager, goto special, custom views, report manager, pivot tables
- list management-sort data, autofilter, custom filter, advanced filter, subtotals, pivot table, data validation
- shared workbooks-create a shared workbook, view changes, manage conflicts, view change history
- workbook templates-custom template, worksheet protection, new default templates
- automation-macros, record, run, relative & absolute macros, customise toolbars
Excel 2002 (xp) - effective use of