• [email protected]
Your cart is empty

Add something to cart :)

Buy Lynda.com Excel 2010 Advanced Formulas and Functions

Lynda.com Excel 2010 Advanced Formulas and Functions
Lynda.com Excel 2010 Advanced Formulas and Functions box
Category: Training software

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 t...... see full description

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. Exercise files accompany the course.

Topics include:
* Referencing, copying, updating, and converting formulas
* Using the logical functions and creating compound logic tests
* Searching for and matching data based on specific criteria
* Reconfiguring cell data using text functions
* Calculating dates, times, and days of the week
* Analyzing mathematical and financial data
* Using the power functions, COUNTIFS, SUMIFS, and AVERAGEIFS
* Working with rounding functions
* Returning cell references

Official site
Platform Windows WindowsMac OS X Mac OS X
Category Training software
Vendor Lynda.com
Permanent link http://down.cd/6485/buy-Lynda.com-Excel-2010-Advanced-Formulas-and-Functions-download
Tags Lynda Excel 2010 Advanced Formulas Functions

Thanks VERY MUCH! It's comforting to know that I can always trust and rely on all my friends at "down.cd" to help me with all my software! You guys have been GREAT whenever I cannot find my software. It's good to know that you keep back-up versions of the software available for me to download whenever I need to, 24-hours, day or night!!! Thanks again! I'll let some of my other friends know about you, for sure!

Blair Armstrong