Start learning with our library of video tutorials taught by experts. Get started
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.
Hi! I am Dennis Taylor, and I am 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 it 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!
There are currently no FAQs about Excel 2010: Advanced Formulas and Functions.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.