Microsoft Excel 2007 training courses
Advanced Microsoft Excel 2007 Training Courses Focussing On Formulas & Functions
The 31 Best of Excel Microsoft Excel 2007 training courses are presented over one day periods ensuring that delegates spend minimum time away from their offices while being able to learn advanced Excel skills effortlessly.
We provide a 100% money back guarantee regarding our Microsoft Excel 2007 training courses and also offer a one month after course support system. If you thus have difficulty with the building of a spreadsheet using the skills learned, you can simply email us with your delegate number and receive professional assistance. The courses are presented at central upmarket venues by a Chartered Accountant with years of experience regarding complex applications of Excel functions, macros, and formula combinations.
We normally begin the Microsoft Excel 2007 training courses with the more basic areas such as ranges, their importance and how to use them; focus on the developer tab and how to use it; working with formula ranges in rows and columns; switching the automatic calculator on or off and locating formula errors; working with dates, and protecting the worksheets.
The second part of the Microsoft Excel 2007 training courses focus on the 31 formulas which one should know to use Excel optimally and how to combine them for best results. The focus falls on logical, lookup, and text formulas as well as formatting of the formulas. In addition, reporting functions including pivot tables and macros receive their fair share of attention. Finally the odd functions and formulas such as minimum and maximum as well as average formulas come under the spotlight.
In the final sessions of the Microsoft Excel 2007 training courses delegates learn how to use the 31 formulas together in power combinations. One for instance, will be able to convert formats, use formulas with pivot tables, and create comprehensive reports. Contact us today for information regarding dates and seat availability and our Microsoft Excel 2007 training courses.
