Return to homepage
Training Needs Analysis - MS Excel Advanced

Please enter your name  and your e-mail

MS Excel Advanced Competent Some Knowledge No Knowledge
Add header/footers
Amending Templates
Change colours in a chart
Creating a Database Within Excel
Creating Hyperlinks to other Applications
Edit Macros
Function Keys/Shortcut Keys
Grouping and Outlining
Import/Export data from other applications
Linking Workbooks/Embedding Workbooks
Managing Worksheets/Grouping Worksheets
Naming Ranges
Pivot Tables/Analysis Data with Pivot Tables
Print a spreadsheet/complete workbook
Protecting Cell/Worksheets
Reformatting a Chart
Sending Excel Files Via E-Mail/Lotus Notes/Outlook
Setting up Macros/Running Macros
Sorting Data in lists/Managing Lists
The IF Functions
Tracing Precedents and Dependants
Use Keyboard Shortcuts
Use slides for charts
Use the Autofill Function
Using Advanced Filters
Using Goal Seek
Using The Auditing Toolbar/Auditing Data
Using the Visual Basic Toolbar/Create
Using Visual Basic with Macros
Variance analysis/Progress lines
VLookUp Functions
Where does information come from?
Work with several sheets at the one time
Working with Menus & Toolbars/Customizing Toolbars
Working with Multiple Files
Working with Subtotals
Workspaces and Multiple files
Using AutoFilter Commands
 

For more information: tel 028 7136 1696  fax 028 7136 1696  email