ConsultingCPG & RetailEntrepreneurship & Start-upEnvironment & SustainabilityFinance & BankingHealthcare & PharmaceuticalsIndustriesInvestingMaster of Advanced ManagementMaster's in Asset ManagementMaster's in Global Business & SocietyMBAMBA for ExecutivesNon-Profit, Education & Public SectorReal Estate, Energy & ManufacturingTechnology, Media & Entertainment

Excel: Advanced Formulas and Functions

Follow along with Excel MVP Oz du Soleil as he demystifies the many kinds of formulas and functions available in Excel. Oz starts with a few critical keyboard shortcuts that will speed up your work, and offers grounding in how to develop your own style working with formulas and functions. Next, Oz covers a variety of formulas such as the XLOOKUP/VLOOKUP and INDEX functions, counting and statistical functions, text functions, and date/time, array, math, and information functions. Oz provides practical examples to help viewers easily transition to using Excel’s most powerful formulas and functions in real-world scenarios. The course concludes with a series of challenges so you can test your knowledge.

Learn More