lynda.com Tutorial | Excel 2010: Advanced Formulas and Functions—Ranking data without sorting

Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=75923&utm_source=youtub...

In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best use. The course reviews the building-block functions, along with a few critical keyboard shortcuts that will speed up working with Excel data. It also covers how to perform advanced searching and data retrieval with Lookup functions, tabulate data with counting, statistical, and math functions, reformat data with text functions, and work with financial data using advanced formulas.

Category:

Howto & Style

Tags:

• lynda.com
• lynda
• online training
• online tutorials
• Dennis Taylor
• Excel training
• Excel tutorials
• Microsoft Office
• Microsoft training
• Microsoft tutorials
• Microsoft 2010
• Office 2010
• Excel 2010
• Office Excel
• business data
• business tool
• Excel formula
• Excel function

[37no37]

Generate all combinations from ranking list elements, taken 6 at a time. Rank in % high(68- 100), average (34-67), low (1-33) [ 2 high-2ave-2 low] 3even 3odd and sum up min (x), max (y).

[airtrixxx1080]

You are a great instructor. Thanks!

[slapcompany]

Hard-core results come from igniting the massive power of emotional commitment. Are your people committed?

Let’s get right on top of the bottom line: You must live your personal values at work. Check out slapCompany

[qwertyfshag]

Awesome