Excel: Advanced Formulas and Functions

Created by: Dennis Taylor

Produced in 2019

icon
Course Description

Follow along with Excel expert Dennis Taylor as he demystifies the hundreds of formulas and functions available in Excel. Dennis starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Dennis provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. Note that this course is recorded in Excel for Office 365 but anyone using a recent version including 2019, 2016, and 2013 will be able to follow along.Topics include:Displaying and highlighting formulasDebugging formulasCreating 3D formulasCreating nested IF functionsExploring VLOOKUP, MATCH, and INDEXTabulating data with COUNTIFS, SUMIFS, and AVERAGEIFSFinding values with statistical functionsAdjusting results with rounding functionsConverting values between measuring systemsCalculating datesReturning reference dataManipulating textExtracting information

icon
Instructor Details

Dennis Taylor

Dennis Taylor is an Excel expert who has 25+ years of experience in spreadsheet authoring and training.Dennis has experience working as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the U.S. and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado.

Read More

icon
Reviews

0

0 total reviews

5 star 4 star 3 star 2 star 1 star
0% Complete
0% Complete
0% Complete
0% Complete
0% Complete
0% 0% 0% 0% 0%