713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule

Resources

training schedule
training schedule
training schedule


 

 


 

 

Microsoft® Office 365 Excel: Level 2

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.

What's New is 365: New and improved Quick Analysis tools now make it easier than ever to utilize the exciting new features. Excel is now capable of making recommendations for charting options based on your data. Create powerful charts easy with the new improved chart types, like Waterfall, Sunburst, Histogram, or Box and Whisker charts. Excel is packed with exciting new templates, improved Pivot Table enhancements, and Multi-select slicer feature to make your workload easier.

Lesson 1: Calculating Data with Advanced Functions

Topic 1A: Calculate Data Across Worksheets
Topic 1B: Nesting Functions
Topic 1C: Use SUMIFS, COUNTIFS and AVERAGEIFS In Formulas
Topic 1D: Use New Functions MINIFS and MAXIFS

Lesson 2: Organizing Worksheet Data with Tables

Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort and Filter Data
Topic 2D: Calculate Data Using Table Functions

Lesson 3: Using Lookup Functions

Topic 3A: Create and Use Named Ranges
Topic 3B: Manage Named Ranges
Topic 3C: VLOOKUP
Topic 3D: HLOOKUP

Lesson 4: Presenting Data Using Charts

Topic 4A: Create and Modify Charts
Topic 4B: Recommended Charts
Topic 4C: New 365 Charts
Topic 4D: Incorporate Shapes in Charts
Topic 4E: Create Trendlines

Lesson 5: Analyzing Data Using PivotTables and PivotCharts

Topic 5A: Create a PivotTable
Topic 5B: Filter Data Using Slicers
Topic 5C: Filter Data Using a Timeline
Topic 5D: Analyze Data Using PivotCharts

Lesson 6: Enhancing Workbooks

Topic 6A: Customize the Excel Environment
Topic 6B: Manage Themes
Topic 6C: Use Quick Analysis Tools


Excel 365 Training Course Outlines

Excel 365 Core Features & Functions:

Excel 365 LV 1: Fundamentals of Excel
Excel 365 LV 2: Intermediate Functions & Features
Excel 365 LV 3: Advanced Tools &
Collaboration Features

Excel 365 LV 4: Advanced Functions

Excel 365 New Functions & Features:

Excel 365: New Functions & Formulas
Excel 365: New Features

Excel VBA Macros:

Excel 365 LV 5: Introduction To VBA Macros
Excel 365 LV 6: Advanced VBA Macros
 

Excel In-Depth Essentials:

Excel In-Depth: Charting Essentials
Excel In-Depth: PivotTable Essentials
Excel In-Depth: Advanced Excel Keyboarding

Excel Power Tools:

Excel Get & Transform (PowerQuery)
Excel PowerPivot Part 1
Excel PowerPivot Part 2

 

 

 
   
     

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