Microsoft Excel 2010/ 2013 (Intermediate)

Duration: 2 Days
Contact Hours: 14

---

Course Mode

• Lectures
  
• Hands-on

---

Target Audience

• Office administrator
• Secretaries
• Managers
• General PC users who intend to enhance knowledge & ability to support more advanced features in Microsoft Excel
  

---

Benefits

• Transform from raw data into desired message in the form of charts/ tables
• Delegates are shown the strategy to uncover the solution

---

Course Overview

Conditional Formatting

• Conditional format with data bars
  
• Conditional format with icon sets
  
• Conditional format with formulas
  
• Conditional format with colour scales
  
• Conditional format with cell rules
  

Function

• Date & time function
  
• Text function
  
• Sum & count function
  
• Information function
  
• Lookup & reference function

Advanced Function

• Using lookup functions: VLOOKUP, HLOOKUP, LOOKUP
  
• Using logic function: IF, AND, OR, NOT
  

Managing data in list

• Sorting database list
  
• Filtering database list
  
• Subtotal data
  
• Using functions with lists
  
• Using advanced filtering and AutoCalculate
  

Performing Calculation on Named Groups

• Understand relatives and absolute reference
  
• Naming methods
  
• Creating and redefining range names
  
• Creating formulas with range names
  

Data Validation

• What is data validation?
  
• Types of validation criteria
  

Data Analysis

• Consolidate data in single workbook
  
• Consolidate data in multiple workbook
  
• Subtotal
  

Presenting Data in Charts

• Overview of Excel charting features
  
• Creating chart
  
• Charts modifications

Pivot Table

• Pivot table
  
• Create pivot table

---