Excel: Advanced Formulas and Functions

Categories: Microsoft Office
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Join Excel guru Dennis Taylor as he debunks the mystique around Excel’s many formulae and functions. Dennis begins with a few crucial formula shortcuts that will expedite your work before covering a wide range of functions, including VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date-and-time, math, text, and information functions. He also covers functions like VLOOKUP, MATCH, and INDEX. Dennis gives concrete examples to make it simple for viewers to use Excel’s most potent formulas and functions in realistic situations. You should be aware that this course is recorded in Excel for Office 365, but you can still follow along with any current version, including 2019, 2016, and 2013.


             Learning objectives

  • 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.          
Show More

Course Content

Chapter 1 : Formula & Function Tips & Shortcuts

Chapter 2: If & Related Functions

Chapter 3: Lookup & Reference Functions

Chapter 4: Power Functions

Chapter 5: Statistical Functions

Chapter 6: Math Functions

Chapter 7: Date & Time Functions

Chapter 8: Reference Functions

Chapter 9: Text Functions

Chapter 10: Information Functions

Next steps

Student Ratings & Reviews

No Review Yet
No Review Yet