Excel: Advanced Formulas and Functions (6/2021)
Duration: 4h 41m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 699 MB
Genre: eLearning | Language: English
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 , 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.
Recognize the results of the MOD function.
Identify the Excel random number generating functions.
Apply the ROMAN function to convert a Roman numeral to Arabic.
Give an example where the LEFT and RIGHT functions could be used.
Describe the TRIM function.
Define the Excel Text functions.
Differentiate between Information functions.