Excel 2010: Advanced Formulas and Functions

with Dennis Taylor
please wait ...
Excel 2010: Advanced Formulas and Functions
Video duration: 0s 5h 5m Advanced


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


- Hi, I'm Dennis Taylor, and I'm pleased to present Excel 2010: Advanced Formulas and Functions. For many Excel users, the central focus of what they do is writing formulas and functions. If you really want to take advantage of Excel's power, you need exposure to its many functions. Nobody needs to know them all, of course, but just mastering the intricacies of such vital functions as if and vlookup, as well as the related match and index functions, gives you enormous control over your data and opens the door to creative data analysis and manipulation.

I'll start off by showing you some great shortcuts for building formulas and functions, numerous variations on the aforementioned if and lookup functions, vital statistical and math functions, and some date functions that could prove to be indispensable. I'll show you how text functions can help you clean up flawed data, how powerful array formulas and functions give you even more analytical possibilities, and I'll show you how to use functions in combination with one another to achieve even greater power.

To become a proficient and more confident Excel user, you need to know more about formulas and functions. This course is filled with tons of techniques and tools to help you reach those objectives. Welcome to Excel 2010: Advanced Formulas and Functions.

please wait ...