Please enter a date range below to find available courses
From to
Provider: 1816
Excel 2007 Advanced
Course aim
This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel to an advanced level
Course outline
ADVANCED TOPICS - Setting Excel Options - Excel and Windows - Using the Excel Viewer
GETTING THE MOST FROM YOUR DATA - Getting the Most from Your Data - PivotTables - More About PivotTables - Exploring Scenarios - What If Analysis
EXCEL AND THE INTERNET - Excel and Hyperlinks - Saving Workbooks as Web Pages - Getting Data from the Internet - Excel and Office Servers
ADVANCED EXCEL TASKS - Creating and Using Shared Workbooks - Using Custom AutoFill Lists - Using the VLOOKUP Function - Linking, Consolidating, and Combining Workbooks
ADD-INS, SMART TAGS AND DIGITAL SECURITY - Add-ins and the Trust Center - Information Rights Management - Digital Signatures -: Smart Tags and XML
MACROS, VBA AND EXCEL PROGRAMMING - Macros - More Macro Tasks - Visual Basic and Macros
EXPERT TOPICS - Form Controls - Advanced Functions - Using SharePoint - User Forms and ActiveX Controls
Pre-requisites
This course is designed for current Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create and save a workbook, create formulas and use functions, and perform simple formatting of the data.
