IT Skills Excel Spreadsheet

The Courses:

Basic Excel:

This course will teach you how to design a basic spreadsheet, enhance it with formatting tools, use basic functions and formulae for calculations, and create charts and graphs from the information contained within the spreadsheet.  The morning will deliver the required skills along with practice exercises to consolidate your learning, and the afternoon can be spent with you applying these skills to some of your own workplace applications. 

Areas of study:

• Designing and formatting a spreadsheet
• Using functions and formulae
• Creating charts and graphs

Advanced Excel:

The advanced Excel course will help you develop and build on your knowledge of look-up functions, formulae and macros, teach you how to design and use pivot tables, and format documents to create forms and reports using drop-down lists.   The morning will deliver the required skills along with practice exercises to consolidate your learning, and the afternoon can be spent with you applying these skills to some of your own workplace applications. 

Areas of study:

• Look-up functions, formulae and macros
• Conditional formatting
• Managing and sorting large amounts of data

Dates available:

For details of future course dates, please contact Hartpury Business:

Telephone +44 (0)1452 702154
E-mail: hb@hartpury.ac.uk