Microsoft Office 365 Excel - Level 2

Microsoft Office 365 Excel - Level 2

Module1: Creating Advanced Formulas

  • Apply Range Names
  • Use Specialized Functions

 Module 2: Analyzing Data with Logical and Lookup Functions

  • Use Text Functions
  • Use Logical Functions
  • Use Lookup Functions
  • Use Date Functions
  • Use Financial Functions

 Module 3: Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data
  • Use Subtotal and Database Functions to Calculate Data

 Module 4: Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts

Course Enquiry