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.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.

Live Instructor-Led Training

The Power to Boost Productivity!

Training partners

Spindustry Training - (515) 334-9556

Bookmark and Share

Online Excel Advanced Formulas

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

Schedule for this Course

Register 02/26/2021 8:30 am - 10:30 am
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.


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