Excel Spreadsheets - Level 3 Part-time
Course
In Leamington Spa
Description
-
Type
Course
-
Location
Leamington spa
-
Start date
Different dates available
A candidate who successfully completes this module will be able to design and create spreadsheets for other users, to use spreadsheets to import data and produce simple abstracts, and to summarise data with charts.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Excel
- IT
- Design
- Part Time
- Import
- MS Excel
Course programme
- Analyse user requirements and design multi-page spreadsheets to meet them
- Use standard tools in problem solving
- Import and process data supplied in text files
- Use named cells and ranges in functions
- Use mathematical functions, eg PI(), RAND, INT, ROUND, SUM
- Use statistical functions, eg COUNT, AVERAGE, STDEV, VARIANCE, MEDIAN, MODE,PERCENTILE, •use
- Financial functions, eg FV, PV, IRR, INTRATE
- Use logical functions, eg AND, OR, NOT, IF and compounded IF eg IF(AND), IF(OR)
- Use text functions, eg CONCATENATE, LEN, MID, LEFT, RIGHT, TRIM
- Record macro’s
- Use error functions
Excel Spreadsheets - Level 3 Part-time