A course for users who want more advanced functions and to import into and export from Excel using various applications.
Versions: 2003, 2007 and 2010
Duration
1 day (for groups, minimum of 6 people)
Outcomes
The delegate will be able to use advanced functions, pivot tables and export and import files.
Unit Standards
There are no unit standards available for this course.
Prerequisites
The student must have used Excel intermediate and advanced features
Course content
- Importing files from other applications
- Hyperlinks
- Using AutoShapes or Pictures as Link Buttons
- Styles
- To create a style for a number format
- To merge styles from an existing document
- Add-ins
- To load an add-in if a full installation of excel was installed on your computer
- Available add-inns:
- List/database features
- List/database functions
- Pivot tables
- Updating a pivot table
- Creating a second pivot table in the same workbook
- Arrays
- Enter an array formula
- Using advanced functions
- Advanced count and sum functions
- =countblank
- =counta
- =sumproduct
- =match and index
- Information functions
- =cell
- =error.type
- =info
- Is functions
- Macros
- Using mouse actions to create a macro (overview)
- Assigning a Macro to a Button on a Toolbar (Overview)
- Assigning a Macro to a Button on a Worksheet (Overview)
- Creating a Relative Macro
- Assigning a Macro to Menu Bar Option
- Create a New Menu Option
- Deleting a Macro Menu Option from the Menu
- Deleting a Macro from the Personal Macro Workbook
- Linking to PowerPoint
- Linking Excel Data for Charts in PowerPoint
- Linking to Access
- Importing Excel Worksheets into Access
- Linking Excel Worksheets into Access
- Word (Merging)
- Importing from other Spreadsheet/Accounting Programmes
