Excel 2007 - advanced
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
create custom templates to be more productive. automate repetitive and/or complex tasks using macros. summarise data using pivot tables. analyse and extrapolate data using scenarios and solver. create complex formulae using combinations of functions like vlookup and match. use array formulae to speed up spreadsheet development
Facilities
Location
Start date
Start date
Reviews
Course programme
after completing this course, participants will be able to:
- create custom templates to be more productive
- automate repetitive and/or complex tasks using macros
- summarise data using pivot tables
- analyse and extrapolate data using scenarios and solver
- create complex formulae using combinations of functions like vlookup and match
- use array formulae to speed up spreadsheet development
topic
- hyperlinks-save as html, make data interactive - pivots, formulas
- automation-macros, record, run, relative & absolute, assign to buttons, customise toolbars, edit vba code
- workbook templates-new default templates
- get external data
- array formulas
- data analysis-pivot tables, data tables, solver
- advanced functions-statistical, dates, text, financial, lookup, counta, edate, upper, pmt, match, countblank, eomonth, lower, fv, index, countif, proper, lookup, sum using names, vlookup & match, split first & last name
Excel 2007 - advanced