Excel 2013: Advanced Formulas and Functions
MP4 | Video: 720p | Duration: 5:26:37 | English | Subtitles: VTT | 802.1 MB

Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, 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. The course starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly to real-world scenarios.

Topics include:
Displaying and highlighting formulasConverting formulas to valuesCreating 3D formulas to gather data from multiple sheetsUnderstanding the hierarchy of operations in formulasUsing absolute and relative referencesCreating 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 functionsPerforming basic mathCalculating dates and timesEditing text with functionsChecking for errors with formulas
Download link:

[Misafirler Kayıt Olmadan Link Göremezler Lütfen Kayıt İçin Tıklayın ! ]

[Misafirler Kayıt Olmadan Link Göremezler Lütfen Kayıt İçin Tıklayın ! ]
Links are Interchangeable - No Password - Single Extraction