Module Microsoft Excel – Advanced – UK Microsoft End-user trainingen 11 Hoofdstukken Module Materials Oefenbestanden:Â Completed Activities Completed Lesson Labs Starting Files for Activities Starting Files for Lesson Labs Hoofdstukken Expand All | Collapse All ABOUT THIS COURSE LESSON 1: CREATING ADVANCED FORMULAS 2 Paragrafen TOPIC A: Apply Range Names TOPIC B: Use Specialized Functions LESSON 2: ANALYZING DATA WITH LOGICAL AND LOOKUP FUNCTIONS 5 Paragrafen TOPIC A: Use Text Functions TOPIC B: Use Logical Functions TOPIC C: Use Lookup Functions TOPIC D: Use Date Functions TOPIC E: Use Financial Functions LESSON 3: ORGANIZING WORKSHEET DATA WITH TABLES 3 Paragrafen TOPIC A: Create and Modify Tables TOPIC B: Sort and Filter Data TOPIC C: Use Subtotal and Database Functions to Calculate Data LESSON 4: VISUALIZING DATA WITH CHARTS LESSON 5: ANALYZING DATA WITH PIVOTTABLES, SLICERS, AND PIVOTCHARTS LESSON 6: INSERTING GRAPHICS LESSON 7: ENHANCING WORKBOOKS LESSON LABS COURSE WRAP-UP APPENDICES