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 Excel 365
New Functions and Formulas (Online)

Training Course Content

Course Summary: Excel 365 has many exciting new functions which are not included in other versions of Office (2019 and earlier). These either have been a part of Excel 365 for years, or have been added through monthly updates to the software. In this class, students will learn how to use these new Logical, Lookup, and Dynamic Array functions in formulas.

Course Prerequisite: Students should be familiar with how to create formulas using intermediate functions in Excel like SUMIFS, COUNTIFS, AVERAGEIFS and have been exposed to VLOOKUP.

Course Requirements: In order to ensure you have access to all functions taught in this class, be sure your Office 365 Account settings are set to Current Channel. If you have any questions about how to check for this, please be sure to contact us.

Lesson 1: Improved Lookup Functions

  • The superior lookup function, XLOOKUP
  • Return a position or count values with XMATCH

Lesson 2: Using Logical Functions

  • Summarize data using MINIFS, MAXIFS
  • Test multiple conditions with IFS

Lesson 3: Data Modification using Formulas

  • Joining data strings using CONCAT and TEXTJOIN
  • Replace values with SWITCH

Lesson 4: Dynamic Array Functions

  • FILTER returns a filtered array
  • Create a sorted array with either SORT or SORTBY
  • UNIQUE builds an array of all distinct values
  • Use SEQUENCE to create consecutive data
  • Build an array of random values with RANDARRAY

Lesson 5: Use Variables in a Formula

  • LET function
  • Use FILTER and SEQUENCE in LET

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   |