January bitesize Workshops

Join us at desktop training for one of our 90-minute bitesize training sessions. Quickly pick up a new skill and put what you learn into use the same day.

The cost is £45 (plus VAT) per workshop.

Here is the line-up for January

Thursday 28 January

Recording Simple Macros in Excel

If you've ever thought "there must be a better, faster way" to handle repetitive tasks in Excel, then join our Recording Excel Macros workshop. Excel Macros are one of the most powerful, yet least understood and most underused tools, in Excel. This hands-on session will show you how to start increasing your efficiency with Microsoft's number one spreadsheet program.

08:00–09:30

Excel Pivot Tables: get a handle on your data

Excel's Pivot Tables enable you to quickly create concise reports from large data sets, spot trends by consolidating information and display results for multiple variable questions - plus you can easily create Pivot Charts to visually represent your data. Stop writing complicated formulas, creating multiple worksheets, and using Sort and Filter commands – and make Pivot Tables do the work for you!

10:00–11:30

Excel Formulae AND Functions

This workshop is for anyone that wants to get more done in less time when working with Excel. The ability to carry out calculations in Excel gives you the power to really get the job done. In this bite-sized workshop you'll learn how to create simple formulas and how to use simple preset functions. Once you have mastered formulae and functions in Excel, you'll never go back to a calculator!

13:00–14:30

Mastering Advanced Excel Functions

Excel's functions are many and various… and sometimes confusing! Get to grips with IF, LOOKUP and the DATE functions, discover the benefits of range names, ways of validating your data results and even how to design custom functions specific to your data.

15:00–16:30