Excel 2003 - effective use of
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
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 2003 - effective use of