713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas
Course Links
training schedule  Schedules
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule
Resources
training schedule
training schedule
training schedule

 

 


 
 

Microsoft® Office Excel: Level 2
Online Training Course Content

Course Objective: Students will learn to sort and filter data, perform complex calculations and functions, and analyze data using PivotTables and charts.

Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing spreadsheets in Excel. Knowledge of formulas and functions is also necessary (Sum, Min, Max, Average, If, and applying absolute referencing) to be successful in this class. Students can obtain this level of skill through our Level 1 course.

Contact us to discuss if this level is right for you.

Excel Level 2: Intermediate Functions & Formulas   Excel Level 2: Intermediate Features, PivotTables & Charts
3 Hour Webinar   3 Hour Webinar
         
Lesson 1: Calculate Data with Functions
   • IF
   • CONCATENATE
   • Nesting Functions
   
Lesson 2: Use Conditional Logic Functions
   • SUMIFS
   • COUNTIFS
   • AVERAGEIFS
   • MINIFS
   • MAXIFS
   
Lesson 3: Arrange and Categorize Data
   • Sort Data
   • Perform a Custom Sort with Data
   • Add and Delete Filters
   
Lesson 4: Lookup Functions and Named Ranges
   • Create and Use Named Ranges
   • Manage Named Ranges
   • Use VLOOKUP in a Formula
   • Use HLOOKUP in a Formula
 
Lesson 1: Organizing Worksheet Data with Tables
   • Create and Modify Tables
   • Format Tables
   • Calculate Data Using Table Functions
   • Table Slicers
   
Lesson 2: Presenting Data Using Charts
   • Create and Modify Charts
   • Recommended Charts
   • Incorporate Shapes in Charts
   • Create Trendlines
 
Lesson 3: Customizing and Enhancing Workbooks and the Excel Environment
   • Customize the Excel Environment
   • Manage Themes
   • Use Quick Analysis Tools
   
Lesson 4: Introduction to PivotTables and PivotCharts
   • Create and Modify a PivotTable
   • Format a PivotTable
   • Filter Data Using Slicers
   • Filter Data Using a Timeline
   • Analyze Data Using PivotCharts

Excel Training Class Outlines (Online Training):

Excel Level 1: Fundamentals of Excel
Excel Level 2: Intermediate Functions and Features
Excel Level 3: Advanced Tools and Collaboration Features
Excel Level 4: Advanced Formulas and Functions
Excel Level 5: Introduction To VBA Macros
Excel Level 6: Advanced VBA Macros
 

 

  		   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |