This course is ideal for anyone who wants to learn the more advanced uses of Excel and has some basic knowledge of this application. This course will provide further tools to complete more difficult tasks and reduce time in their completion. The course will include: - Key elements from introductory excel course - Cell naming - Database functions - Sorting spreadsheets and subtotals - Pivot tables (cross tab views) - Recording and editing macros - Creating and using spreadsheet templates - Recording macros and getting to know Visual Basic programming language - Creating validation lists