Microsoft Excel (2000, XP, 2003 & 2007)

Our IT training can take several forms including one-to-one, small groups and classroom sessions.

Although these are all useful in their own way, we highly recommend one-to-one coaching at your place of work, which brings several key benefits. You can ask any questions you want, you can work at your level of expertise and your speed, and any improvements we generate are still on the PC when the trainer leaves.

Wherever possible we’ll work with files you use to do your job, and use them as the focal point for the training. For example, if you have an Excel worksheet that isn’t operating effectively we’ll work together to improve it.

What's Excel used for? Excel is part of the Microsoft Office suite of programs. You would use it to input, calculate and display data, for example to monitor and control a company's financial or operational performance.

The ideal delegate is: Someone with little or no experience of using Excel. Alternatively, they've been using Excel for a while but feel they have started off on the wrong tack, and would like to go back to basics. The training will also suit delegates with a working knowledge of Excel, but who have the need to design more complex workbooks. Typically, delegates might need to design workbooks for others to use, or be in the position where financial monitoring and control is paramount.

An extensive range of topics can be covered including: Entering and editing data and formulae Understanding and working with cell references Formatting and customising the worksheet Using Functions Sorting and filtering data IF statements and Lookup tables Conditional formatting Linking data, worksheets and workbooks Exporting to Microsoft Word Customising toolbars Charting (graphs) Please note that this list of topics isn't exhaustive. If there's something not shown that you're interested in please get in touch and we'll do our very best to help.

Cool activities include: Loads of hints, tips and tricks that will save you heaps of time (and therefore money) while you're working with Excel.