| |
| training |
| development |
| technology |
| about us |
| contact |
| links |
| privacy / copyright |
| home |
| MICROSOFT EXCEL |
| Probably the most flexible software within the Office suite, Excel can not only cope with your calculation requirements, but also for presentating and managing data. Our Excel courses span all levels from getting started to data management and VBA training, together with 1/2 day masterclassess for charts, tips and tricks, and Everyday Excel This course gives a quick start to the basics of creating and using a spreadsheet with simple formulae, progressing to using functions and documenting a spreadsheet. You'll also learn how to use your spreadsheet easily to try different sets of figures to see the effect; creating charts is also covered. course outline Excel Intermediate This course covers more advanced topics, yet places them in a day to day context. Beginning with using named ranges, the course builds upon each topic to show how each builds upon the next and the relationship between them. Culminating with pivot tables, use of sub totals and Excel's database facility, the course provides the knowledge required to move up a gear with Excel. course outline Excel Data Analysis Designed for the business user who particularly needs to crunch numerical data, this course covers the data analysis features available in Excel in depth. Creating and manipulating pivot tables, multiple level sub totals, input tables, Scenario Manager and Solver are all brought in to the course. course outline Excel Charts A new half day course focussing on charts and the myriad of options to which they can be used course outline Excel Macros & VBA This course takes you to the level of automating Excel via macros and weaving in use of VBA (Visual Basic for Applications). You'll learn basic programming methods to enhance macros and how to respond to users input in your macros. You'll also learn how to create custom screeens using Excel's forms course outline |
|
Everyday Excel Excel Intermediate Excel Data Analysis Excel Charts Excel Macros & VBA |