Download Now
Excel 2011 for the Mac: Advanced Formulas and Functions
MP4 | Video: 720p | Duration: 6:13:51 | English | Subtitles: VTT | 1046.6 MB

Conquer some of the most daunting features in WeiRuan-->WeiRuan Excel once and for all. In this version of his popular course, designed specifically for Excel for Mac users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.

Topics include:
Using absolute, relative, and mixed referencesUsing the Formula BuilderConverting formulas to valuesCreating 3D formulas to gather data from multiple sheetsCreating and expanding the use of nested IF statementsLooking up information with VLOOKUP, MATCH, and INDEXUsing the power functions: COUNTIF, SUMIF, and AVERAGEIFAnalyzing data with the statistical functionsCalculating paymentPerforming basic mathDetermining dates and timesEditing text with functionsAnalyzing data with arrays
Download link:

Links are Interchangeable - No Password - Single Extraction
Direct Download

Tags: Advanced, Formulas, Functions

Add Comments:
Enter Code: *