| |
| Aim of Course | To provide the experienced user with knowledge to use more advanced functions within Microsoft Excel 2000 |
| Target Audience | Users of Excel who have existing knowledge and need to expand their uses within the package. |
| Structure of Course | The participant is given exercises that offer hands-on practical experience to enable successful and efficient use of the program.
Training will take place in one of 3 fully equipped training suites delivered by professional lecturers. Up to date multimedia and interactive software/smartboards. Free on-line back-up support after training. |
| Course Content | Shortcuts Quick Navigation Managing Worksheets Function Keys/Shortcut Keys Working with Multiple Files Changing Number Formats Import/Linking and Embedding Workbooks Using References Naming Ranges String Manipulation Using Text Functions LookUp Functions/Working with Scenarios Protecting Cell/Worksheet Using The Auditing Toolbar Tracing Precedents and Dependants Data Validation/Goal Seek/Solver Creating Templates Change Data Defaults for New Workbooks Creating a Database Within Excel Using AutoFilter Commands Sort Data/Using Advanced Filters Using Subtotals and Consolidation Working with Pivot Tables Using Macros/Running Macros Creating Hyperlinks to other Applications Sending Excel Files Via E-Mail/Lotus Notes/Outlook Introduction to Using Excel with the Internet |
