Please enter a date range below to find available courses
From to
Provider: 1816
Excel 2007 Intermediate
Course aim
This is a hands-on training course covering the intermediate features and the analytical techniques and efficiencies of Excel.
Course outline
ADVANCED FILE TASKS - Using My Computer within Excel - Saving your Files - Using Templates
WORKING WITH FUNCTIONS AND FORMULAS - Using Formulas in Excel - Exploring Excel Functions - Using Functions in Excel - Working with Names and Ranges - Working with Array Formulas
MANAGING TABLES - Working with Tables - Working with Records and Fields - Working with Tables and Filters - Using Excel as a Database
ENHANCING YOUR WORKBOOK - Customising your Workbook - Working with Text Boxes - WordArt - ClipArt - Using Objects
FINALISING YOUR WORKBOOK - Protecting your Workbook - Finishing Your Workbook - Using Excel in Word - Using Excel and Access - Using Excel With other Programs and Files
Pre-requisites
This intermediate level course is for people who have attended the Introduction course or possess equivalent practical experience. A working knowledge of the Windows operating system and basic mouse and keyboard skills are also required.
