Microsoft Excel Expert 2016

1024px-Microsoft_Office_Excel_(2018–present).svg

28

Jul

Teacher Melanie Pinkus
Categories
Students 0 (Registered)

Course Content

Total learning: 29 lessons Time: 10 weeks

Unit 1: Manage Workbooks
- Lecture1.1
  
  Lesson 1.1: Custom Properties
- Lecture1.2
  
  Lesson 1.2: Macros
- Lecture1.3
  
  Lesson 1.3: Form Controls
- Lecture1.4
  
  Lesson 1.4: Merge Workbooks
- Lecture1.5
  
  Lesson 1.5: Protect Worksheets
Unit 2: Manage Workbook Review
- Lecture2.1
  
  Lesson 2.1: Maintain Shared Workbooks
- Lecture2.2
  
  Lesson 2.2: Configure Formulas
Unit 3: Advanced Data and Formatting
- Lecture3.1
  
  Lesson 3.1: Configure Data Validation
- Lecture3.2
  
  Lesson 3.2: Configure Excel Options
Unit 4: Custom Workbook Elements
- Lecture4.1
  
  Lesson 4.1: Templates
- Lecture4.2
  
  Lesson 4.2: Workbook Protection
- Lecture4.3
  
  Lesson 4.3: XML Mapping and Exporting
Unit 5: Create Advanced References
- Lecture5.1
  
  Lesson 5.1: Evaluate Formulas
- Lecture5.2
  
  Lesson 5.2: Consolidate Data
- Lecture5.3
  
  Lesson 5.3: Iterative Calculations
Unit 6: Apply Functions in Formulas
- Lecture6.1
  
  Lesson 6.1: SUMIFS Function
- Lecture6.2
  
  Lesson 6.2: AVERAGEIFS Function
- Lecture6.3
  
  Lesson 6.3: COUNTIFS Function
- Lecture6.4
  
  Lesson 6.4: VLOOKUP and HLOOKUP Functions
Unit 7: Perform Data Analysis and Business Intelligence
- Lecture7.1
  
  Lesson 7.1: Formula Auditing
- Lecture7.2
  
  Lesson 7.2: Scenario Analysis
- Lecture7.3
  
  Lesson 7.3: Goal Seek Tool
Unit 8: Advanced Chart Elements
- Lecture8.1
  
  Lesson 8.1: Advanced Chart Features
- Lecture8.2
  
  Lesson 8.2: Trendlines
Unit 9: PivotTables and PivotCharts
- Lecture9.1
  
  Lesson 9.1: Insert PivotTables
- Lecture9.2
  
  Lesson 9.2: Modify PivotTables
- Lecture9.3
  
  Lesson 9.3: Slicers
- Lecture9.4
  
  Lesson 9.4: Insert PivotCharts
- Lecture9.5
  
  Lesson 9.5: Modify PivotCharts

Instructor