Training Courses For Microsoft Excel
Excel training
Probably the most used, and useful, application used in any organisation today, Excel empowers you to quickly and efficiently analyse data. We'll show you how to organise large amounts of data, produce professional charts and graphs, perform calculations with speed and with ease.
All Microsoft Excel training courses are instructor-led at your site or scheduled (contact us for more information) and include PC Hire, course notes and exercises PLUS six months' post-course support. All courses can be customised to your needs at no extra cost.
All Microsoft Excel training courses are instructor-led at your site or scheduled (contact us for more information) and include PC Hire, course notes and exercises PLUS six months' post-course support. All courses can be customised to your needs at no extra cost.
For further information, choose a level:
Introductory course
Learn how to create Excel spreadsheets in the comfort of your work place on site. We'll help you to understand how to perform calculations and use Excel's many built in features. See how to manage references and turn your sheets into robust working tools. Make sheets that look great when on screen and in print. Learn valuable tips and tricks for productivity.
Course contents
- Spreadsheet design
- Using formulae
- Understanding functions
- Relative references
- Absolute references
- Page setup
- Printing
- Keyboard shortcuts
Intermediate course
Learn how to make Excel perform calculations and formatting dependent on what your data says. Discover how to use Excel as a simple database, how add graphs and charts, the secrets of connecting your sheets together and how to organise your workbooks efficiently.
Course contents
- IF formulas
- Conditional formatting
- VLOOKUP formulas
- Linking sheets
- Sorting
- Filtering
- Sub totals
- Pivot tables
- Named ranges
- Charts
Advanced course
Learn advanced techniques for formulas, include complex logic and error handling in your sheets. Discover how to manipulate text in Excel. Expand your ability process large volumes of data. Learn how to get the most from Excel through customisation.
Course contents
- Nested formulas
- IF, AND, OR, IFERROR
- Error prevention
- Text functions
- Working with large sheets
- Convert text from one to multiple columns
- Remove duplicates
- Automation
- Macros
- Advanced customisation
- Customising ribbons and toolbars
- Adding macros to custom ribbons