LinkedIn Learning Certificate of Completion

Certificate recipient

Ankur Jain

Operations, Global Supply Chain, Digital Transformation and Consulting Leader | Analytics, Business Intelligence and Program Manager | Mentor | CLSSBB

Completion date

September 10, 2024

Details

4h 47m 31s
66 videos
3 exercise files

Skills covered

Microsoft Excel

Certificate of completion for Excel: Advanced Formulas and Functions (2022) content earned by Ankur Jain

4h 47m

Excel: Advanced Formulas and Functions (2022)

By: Dennis Taylor

Course

2,003,827 viewers Released Apr 1, 2019

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.