Excel - Intermediate
Course Summary
This one-day course is for the reasonably
experienced user of Excel who wishes to develop more complex spreadsheets,
use more advanced formulae and develop skills in data analysis
techniques. A proficiency in setting up basic spreadsheets is assumed, as
is familiarity with the Windows environment.
What you will learn
Formatting
worksheets
Relative and absolute cell references in formulae
Building
functions using the Insert Function feature
Using IF, SUMIF, COUNTIF
and other logical functions
Statistical functions
Financial functions
Using
multiple worksheets
Linking workbooks
Database management and
facilities
Pivot Tables
Creating and formatting charts
Useful
shortcuts
Workshop Timetable
9.15am Welcome and
coffee
9.30am Session start
Delegate introductions and
explanation of day
Excel formatting exercise with useful shortcuts.
Pivot
tables
11.00am Break
11.15am Developing multipage spreadsheets
using sheet
grouping and linking techniques.
Relative and absolute
cell references in Excel
Basic statistical and financial functions -
AVERAGE,
COUNT, MAX, MIN, SUBTOTAL
12.30pm Lunch
1.15pm Using the IF,
SUMIF and COUNTIF functions
3.00pm Break
3.15pm Database
management in Excel - Auto filtering,
sorting and the use of subtotals.
Excel
charting
4.30pm Close
