A range of 1-day training courses, aimed at a variety of levels, to give you all of the Microsoft Excel XP skills needed to operate effectively in today's demanding and rapidly changing business world.
Microsoft Excel XP - introduction course
Explore the potential of spreadsheets and develop the basic skills to use them effectively.
The Excel Desktop * Create, Open, Save, Print a Spreadsheet * Entering data * Create simple formulas * Use AutoSum * Use of Autofill * Improve the appearance of a spreadsheet * Format numbers * Copy or move cells * Page Settings * Page breaks * Keep Headings in View
Microsoft Excel XP - intermediate course
Add to basic knowledge to produce more complex spreadsheets.
Work with Ranges * Create Range Names and use the Name box * Statistical Functions * the IF function * Absolute cell referencing * Lookup Functions * Conditional Formatting * Locking and Protecting a spreadsheet * Multiple worksheets * 3-D formulas * Grouping Worksheets * Create a chart * Fine tuning a chart * Editing a chart * Add a line graph * Excel as a database * Autofilter * Sub totalling
Microsoft Excel XP - advanced course
Discover how to use the advanced features to produce powerful spreadsheets
Record Macros * Edit macros * Use the Personal Workbook * Assign macros to short cut keys and toolbars * Managing and Auditing a spreadsheet * Add Comments * Create and modify Pivot Tables * Data Consolidation by position and category * Use the View Manager * Create and select Scenarios * Use Goal Seek * Use Solver
Microsoft Excel XP - workshop course
A combination of problem-solving and training using "real" data and systems.
Best carried out in 1:1 or small groups - for more experienced users * Can either use your own data or supplied examples of real systems * Can combine any topics from the above courses