Module Microsoft Excel – Expert – UK Microsoft End-user trainingen 10 Hoofdstukken Module Materials Oefenbestanden: completed activities completed lesson labs excel_expert_fotos starting files for activities starting files for lesson labs Hoofdstukken Expand All | Collapse All ABOUT THIS COURSE LESSON 1: AUTOMATING WORKSHEET FUNCTIONALITY 4 Paragrafen TOPIC A: Update Workbook Properties TOPIC B: Create and Edit a Macro TOPIC C: Apply Conditional Formatting TOPIC D: Add Data Validation Criteria LESSON 2: AUDITING WORKSHEETS 4 Paragrafen TOPIC A: Trace Cells TOPIC B: Troubleshoot Invalid Data and Formula Errors TOPIC C: Watch and Evaluate Formulas TOPIC D: Create a Data List Outline LESSON 3: ANALYZING AND PRESENTING DATA 5 Paragrafen TOPIC A: Create Sparklines TOPIC B: Create Scenarios TOPIC C: Perform a What-If Analysis TOPIC D: Perform a Statistical Analysis with the Analysis ToolPak TOPIC E: Create Interactive Data with Power View LESSON 4: WORKING WITH MULTIPLE WORKBOOKS 3 Paragrafen TOPIC A: Consolidate Data TOPIC B: Link Cells in Different Workbooks TOPIC C: Merge Workbooks LESSON 5: EXPORTING EXCEL DATA 4 Paragrafen TOPIC A: Export Excel Data TOPIC B: Import a Delimited Text File TOPIC C: Integrate Excel Data with the Web TOPIC D: Create a Web Query LESSON 6: ADVANCED DATA MANAGEMENT CONCEPTS 2 Paragrafen TOPIC A: Import and Export XML Data TOPIC B: Create Excel Forms LESSON LABS 6 Paragrafen Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Lesson 6 COURSE WRAP-UP 1 Paragraaf Post-Course Assessment APPENDICES 1 Paragraaf Keyboard Shortcut Quick Reference Sheet