|
|
| Course Description | ||
| Students will learn various advanced techniques for analysing and manipulating data in Excel . | ||
| Course Content | Prerequisites |
|
| Lesson 1: Customizing the Work Area Working with Built-in Toolbars Using Custom Toolbars Creating and Using Styles Using Templates Lesson 2: Advanced Formula Construction Using Names Using the IF Function Using the VLOOKUP Function Using IS Functions and the Auditing Features Lesson 3: Using Pivot Tables Creating Pivot Tables Modifying Pivot Tables Grouping and Summarizing Data in a Pivot Table Creating Interactive Pivot Tables for the Web Lesson 4: Working with Multiple Worksheets Working with Workbooks Linking Cells in Different Workbooks Workbook Versus Links and Workspaces Sharing and Merging Workbooks Lesson 5: Consolidating and Analyzing Data Consolidating Data from More Than One Worksheet Using the Goal Seek and Solver Utilities Using Scenario Manager to View a Worksheet with Different Input Values Lesson 6: Using Protection and Display Options Using Comments Protecting Workbooks Using Custom Views Lesson 7: Introduction to Macros Running Macros Recording a Macro Viewing and Editing VBA Code Lesson 8: Working with Interactive Excel Web Documents Saving Excel Worksheets as Web Documents Spreadsheet Web Components |
Excel Level 2 | |
| or equivalent knowledge. | ||
| Course Duration | ||
| 7.5 hours | ||
| Study Methods Available | ||
| aIndividual Tuition | ||
| aGroup Training | ||
| x Distance Learning | ||
| Follow-on Courses | ||
| ECDL | ||
| All Courses | ||
| Click here to see all our courses | ||
