->

Excel: Advanced Formulas and Functions

Excel: Advanced Formulas and Functions

MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch | Duration: 4h 24m

Genre: eLearning | Language: English + Sub | Size: 667 MB


 

Follow along with Excel expert Dennis Taylor as he demystifies the hundreds of formulas and functions available in Excel. Dennis starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Dennis provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. Note that this course is recorded in Excel for Office 365 but anyone using a recent version—including 2019, 2016, and 2013—will be able to follow along.

Topics include:

Displaying and highlighting formulas

Debugging formulas

Creating 3D formulas

Creating nested IF functions

Exploring VLOOKUP, MATCH, and INDEX

Tabulating data with COUNTIFS, SUMIFS, and AVERAGEIFS

Finding values with statistical functions

Adjusting results with rounding functions

Converting values between measuring systems

Calculating dates

Returning reference data

Manipulating text

Extracting information

 

HOMEPAGE

https://www.lynda.com/Excel-tutorials/Excel-Advanced-Formulas-Functions/802838-2.html

 

Excel: Advanced Formulas and Functions


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Solid   |  

Information
Members of Guests cannot leave comments.




rss