News

Webinars from Spindustry on SharePoint, MS Teams, and Power BI

Spindustry offers a variety of ways to learn more about solutions to benefit your business. Below is a list of upcoming webinars or pre-recorded sessions that we hope you find helpful.

Five Benefits of Live Instructor Led Training

Five Benefits of Live Instructor Led Training

Experts still agree that there are no viable replacements for having a live professional in the room during training sessions.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.


CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Online Excel 2016 Advanced Formulas

Course Code: OLEX4
Length: 0.25 Days
Tuition: $49.00

Schedule for this Course

 DateLengthLocation
Register 03/26/2019 1:30 pm - 3:30 pm
Instructor: Pamela Smith
0.25 Days Virtual Training: Online Courses

Course Description:

Learn Excel from the comfort of your office or home.
 
Become a more powerful Excel user as you expand your use of Formulas and Functions.
 
This two-hour Live Instructor-led course will explore more of the popular intermediate functions in Excel and give you the tools to manipulate and understand your data. This course is good for anyone that needs to create formulas or understand formulas that have already been created.

Prerequisites

Excel 2016 Intro to Formulas class or prior knowledge of the topics covered in that class.

Course Outline:

·         Use date and time functions
·         Adjust the case within cells with PROPER, UPPER, and LOWER
·         Use the IF function to create logical tests
·         Tabulate information using a single criterion with COUNTIF, SUMIF, AND AVERAGEIF
·         Tabulate information using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS
·         Use the DSUM and DAVERAGE function with a list
·         Create VLOOKUPs and HLOOKUPs and use the MATCH function

back to top