This course is a comprehensive guide to creating fully featured pivot tables. Designed for confident Excel users, it looks at customising fields, calculations and many other practical features.
Designed for new users of Excel with little or no experience of working with computers. Run in a relaxed manner, the course takes into account individual delegate needs. Focuses on creating, saving and printing worksheets as well as file management.
This course shows how to construct formulas and functions in Excel.
It is aimed at existing Excel users who can create and amend spreadsheets but find formulas frustrating.
This course shows how macros can be used to automate commonly used commands and processes. It covers recording different types of macro, amending macro code and navigating within the Visual Basic environment.
This course introduces the basic features of Excel such as formulas, editing worksheets, text/number formatting and printing in order to present professional worksheets. Designed for delegates with basic computer skills.
This course is suitable for existing Excel users who need to learn more about the package. It looks at transferring and linking information, automating repetitive tasks with macros and techniques to make spreadsheets easier to use and manage.
Focusing on some of the more advanced features of Excel, this course includes working with databases to summarise, analyse and filter information. Pivot tables are covered to show how to report on data quickly and easily.