Spreadsheeting (using Microsoft Excel)
Introductory/Intermediate course:
This is the essential course for anyone wishing to learn the most productive aspects of Microsoft Excel. Our course has been constantly refined since 1986, by a specialist with over 25 year’s spreadsheet experience.
This course will benefit the beginner because of its structured approach, and also current users of Excel because of the many shortcuts revealed. This course WILL save the current user time and money!
¤ Learn quick construction techniques and the best ways to organise and format your work
¤ Move, copy and edit your spreadsheets in quick, easy steps
¤ Build formulas quickly and effectively and find the formulas that best suit your needs
¤ Improve the appearance of spreadsheets with great formatting techniques
¤ Use Excel to easily produce complex forms
¤ Discover tricks and techniques to produce vibrant charts
¤ Learn to print any size spreadsheet and to view them easily on screen
¤ Sort, filter or total lists quickly and efficiently
¤ Introduce graphics and diagrams to enhance your spreadsheets
¤ Analyse and select data in lists, and link formulas between your spreadsheets
¤ Pay for your course quickly via shortcuts revealed |
Advanced course:
If you have used Excel for a while and want to improve your skills, this course is for you. You may be self-taught or you may have completed a course at some stage, and you now wish to tap into the power of this excellent program.
¤ Explore the many formulas inbuilt in Excel and learn better ways to use them
¤ Master the many uses of the IF function and learn how to nest functions
¤ Safeguard your investment in complex workbooks
¤ Exchange data between sheets, workbooks and other applications
¤ Effectively use lists, filters, pivot tables and pivot charts
¤ Use data analysis tools such as goal seeking, lookups and arrays
¤ Work with templates and macros to improve user performance
¤ Build and maintain macros that are easily accessible to basic users
¤ Learn advanced techniques to improve you knowledge of charts
¤ Use controls to activate buttons, check boxes, scroll bars, etc
¤ Learn keyboard shortcuts that will pay for the course many times over |
Techniques taught in each of these 12-hour courses are via hands-on examples
and are contained in the comprehensive training manuals provided
