Excel formulas and functions - intensive
Short course
In London
£ 225
+ VAT
Description
-
Type
Short course
-
Location
London
-
Duration
1 Day
Facilities
Location
Start date
London
See map
210 Borough High St, SE1 1JX
Start date
On request
Reviews
Have you taken this course?
Course programme
course description
topic
- review of basic functions using paste function sum, max, min, average, count functions
- displaying formulas and exploring the calculation tab in tool options
- using information functions to evaluate the contents of cells including error values
- using date functions to display date/time information and to perform date/time calculations
- using text functions to extract part of the contents of a cell or to convert data
- using functions from the financial functions category to perform a range of tasks linked to loans, payments and interest rates
- an introduction to the statistical functions available in excel
- installing the analysis toolpak
- using functions from the analysis toolpak
Excel formulas and functions - intensive
£ 225
+ VAT