Webinars

Who is it for? Managing data and creating summaries can be confusing. This session will provide a basic overview of how to create a data summary with filter options and basic charts. No previous Excel knowledge is required. What will I learn? How to use tables to manage data and summarise data in a pivot…

Who is it for? Automating manual process can save you time and reduce human error. You should ideally have an understanding of relative and absolute references. What will I learn? How to record a macro to automatically do basic tasks. How will it help me? This introduction to macros will allow you to create some…

Who is it for? Want to bring data in from another table or file automatically? Excel Lookup functions are a great way to do just that and If you need to add more control to what users can enter then data validation is a must! You should have a basic understanding of what a function…

Who is it for? Anyone who needs to do more than just display data in a spreadsheet. It would be helpful if you understand relative, absolute and mixed references and basic formulas prior to attending. What will I learn? How to use the IF function to determine what happens to the cell content and how…

Who is it for? Styles can be used to create a standard look for documents and templates. You should have a good understanding of font and paragraph formatting. What will I learn? How to create and apply styles, create templates with styles included and force the use of styles within a document. How will it…

Who is it for? Anyone from beginners who have never used Word to those who want to tidy up documents and avoid common problems with the look and feel of a document. What will I learn? How to use the Font formatting options on the ribbon and how to use tabs, line and paragraph spacing,…

Who is it for? Anyone who would like to see what changes have been made to documents that others have edited and choose whether to keep them or not. What will I learn? How to set up track changes, review any changes made, and see who made them, and choose whether to incorporate them into…

Who is it for? Anyone who would like to send a mass communication with a personal touch. What will I learn? How to use the information you have to send a more personalised e-mail or letter, create address labels or even individual certificates to a group of people without having to edit each one. How…

Who is it for? Anyone who manages, updates or creates spreadsheets. It would be helpful if you understand relative, absolute and mixed references prior to attending. What will I learn? How to use number formatting to display your data correctly, from keeping leading zeros to why dates aren’t actually dates and a few functions for…

Who is it for? Anyone! Even if you have never used Excel before. What will I learn? How, and more importantly why, to use basic functions like Sum, Average, Round and Count as well as what relative, absolute and mixed references mean. How will it help me? Using functions and formulas effectively will improve the…