News

Azure For IT Professionals

Learn more about implementing Azure as part of your infrastructure.

Staying Sharp on Microsoft Office Can Save Time & Money

Learning the latest Microsoft Office tips and tricks can benefit you greatly.

"How do I determine if this new technology is for real?"

Michael Bird explains how to navigate new technology waters.

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 02/13/2019 1:30 pm - 3:30 pm
Instructor: Pamela Smith
0.25 Days Virtual Training: Online Courses
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