Home » Tutorial » Excel 2011 for the Mac: Advanced Formulas and Functions
Category: Tutorial
Download Now

Excel 2011 for the Mac: Advanced Formulas and Functions
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

Excel 2011 for the Mac: Advanced Formulas and Functions rapidshare mediafire megaupload hotfile download, Excel 2011 for the Mac: Advanced Formulas and Functions torrent emule download, Excel 2011 for the Mac: Advanced Formulas and Functions full free download, Excel 2011 for the Mac: Advanced Formulas and Functions rar zip password or anything related.
Back
Dear visitor, you went to the site as unregistered user.
We recommend you to Register or enter the site under your name.


Add your comment

Name:*
E-Mail:*
Security code:*