Microsoft: Excel

Scheduled Training Courses

 13/06/2012  16/07/2012  13/08/2012  13/09/2012  12/10/2012  13/11/2012  13/12/2012

This training course can also be run on request as a One to One or a Classroom Booking.

Overview

This stage assumes no prior knowledge of Excel. The course would be ideal for beginners or for people who are self taught and just wish to brush up on their existing skills. The course begins with an overview of the program, navigation of the screen and an introduction to the terminology. This then leads into setting up spreadsheets and starting to use basic calculations (Adding, Subtracting, Dividing and Multiplying) and then an introduction to Formulas i.e. Sum, Average, Count, Minimum, and Maximum. By the end of this course students will be in a position to produce formatted information for printing, use basic formulas, and create simple graphs.

(Courses Overview)

Scheduled Training Courses

 14/06/2012  17/07/2012  14/08/2012  14/09/2012  15/10/2012  14/11/2012  14/12/2012

This training course can also be run on request as a One to One or a Classroom Booking.

Overview

One of the hardest problems users face in Excel is Percentages (Finding, Adding and Deducting). Stage 2 shows some simple steps of how to conquer this problem allowing users to create more complicated spreadsheets that they can trust and use effectively. In addition, linking spreadsheets is one of the easiest ways to improve your readable data with the introduction of some new formulas i.e. Today, Median, Mode and Absolute Cell Referencing. Delegate’s confidence will quickly grow allowing them to start learning filtering and subtotal functions.

(Courses Overview)