Training/course: Excel 2007/2010 Advanced
Course Description
You have a broad experience with Excel and you have mastered the formulas and functions. So now you want to fathom the ins and outs of Excel's advanced functions.
During this training the advanced subjects found below will be covered in detail. If you already use these functions but have occasional problems with certain issues then we can still help you. By emailing us your particular situation before the course we can then ensure that our trainer can go through the solutions with you during the training sessions.
Course Content
As well as the following subjects other related subjects may be covered on request.
- Data Tables
- Creating and comparing Scenarios
- Searching inputted data using Goal Seek
- Sorting
- Using the Auto-filter and the Extensive filter
- Calculating sub-totals
- Use of Criteria
- Making and amending a Pivot table
- Creating Macros and amending the menu
- Tailoring a Macro to you requirements
- Creating your own function
Course Prerequisites
Excel Intermediate training or the equivalent. To attend this course it is essential that you are complete happy with Excel's SUM, AVERAGE and IF functions. You must also be able to work with absolute and relative cell-changes.
Comments
This Excel training course is given in tutorial form in a class of MS Office students. This means that students will work on their own course and at their own pace under the careful and diligent guidance of a tutor, rather than using a classical lesson with the teacher presenting to everyone at the same time. Only MS Office subjects are dealt with during the Office tutorial class. The tutor will help explain the theory and show you how to work through the course. He or she will be on hand to help you with any problems, give you practical tips and answer your questions. This class-based tutorial system has been tried and tested by us for many years and proves to be a satisfying and rewarding teaching method.
This system has many advantages. Not only does it allow you to learn at your own pace but it also gives you the opportunity to bring with you practical applications for Excel from your own workplace. It is better if you can send these to Learnit before the course by email. Otherwise you can bring it with you on a USB or cd-rom.
All MS Office training courses are given using recent versions of MS Office. Most versions are as good as identical to each other, but the teacher will explain exactly any differences between versions. If you want to take the course using a particular version, you can bring this to our attention on the registration form.
