Lynda - Excel for Mac Advanced Formulas and Functions (3652019)

Duration: 2h 18m | Video: .MP4 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | Size: 486 MB
Genre: eLearning | Language: English
Looking to master all the formulas and functions available in Excel for Mac? In this comprehensive course, Dennis Taylor presents numerous Excel formulas and functions and shows how to use them efficiently. Dennis begins with tips and keyboard shortcuts to accelerate the way you work with formulas within one or multiple worksheets. He then covers how to perform logical tests with the IF, AND, OR, and NOT functions, search and retrieve data with lookup functions (VLOOKUP, XLOOKUP, MATCH, and INDEX), analyze data with statistical functions, use text functions to clean up worksheets, work with array formulas and functions, and master date and time calculations. If you're looking to up your formulas and functions skills in Excel, join Dennis as he uses practical examples that transition effortlessly to real-world scenarios.