Excel - Intermediate
Course
Inhouse
Description
-
Type
Workshop
-
Methodology
Inhouse
-
Duration
1 Day
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. Suitable 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.
About this course
A proficiency in setting up basic spreadsheets is assumed, as is familiarity with the Windows environment.
Reviews
Teachers and trainers (1)
Joan Temple
Tutor
Course programme
In-House & Bespoke Training Programmes offer the ideal forum to learn new skills by targeting training to the specific needs of a group of employees. We can design content to meet your development and training requirements. Also, and very importantly, the cost per person is often less than booking the same people on an open course session if you have 8+ delegates. This is a very cost-effective way to take advantage of, and benefit from, our powerful training opportunities.
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
Excel - Intermediate