Analysis Techniques with Excel

A course covering the use of analysis techniques for those who regularly work with comprehensive sets of figures.

Blah blah blah

Course Outline

The course workbook covers all of these topics. All timings are approximate. Due to time constraints it is not always possible to give this amount of time to each item on the course.

Using Range Names47 mins
Working with Labels in Formulas20 mins
Working with Databases53 mins
Working with the Data Form26 mins
Using AutoFilter16 mins
Working with Advanced Filters39 mins
Importing and Exporting Data46 mins
Creating/Revising Pivot Tables79 mins
Using Conditional and Custom Formats35 mins
Working with Data Series17 mins
Using Advanced Functions76 mins
Using Data Tables16 mins
Solving Problems29 mins

Total approximate teaching time: 8:19

In addition to teaching there is a lunch break and coffee breaks. We aim to complete as much of the course as possible in the available time but it is not always possible to cover all material.

Scheduled Courses

The list below shows courses that have been scheduled within the next three months. If there is no suitable date please EMail us as we may run additional courses subject to demand. If you notify us we can put you onto a reserve list for a course that is fully booked.