Viewers: in countries Watching now:
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.
I've enjoyed presenting this course, and I hope it's been beneficial to you. If you want to know more about Excel 2010, don't forget to check out the web site lynda.com. There you'll find lots of different courses on Excel 2010, as well as courses on the other versions of Excel. You might check out Excel 2010 Power Shortcuts, which has a goodly number of tips and shortcuts to increase the efficiency. You will get more power out of Excel this way. You might check out Working with Dates and Times, and there are certainly other courses as well that might gather your interest.
Visit this site often because from time to time you will see new offerings in this courseware. Thank you for watching.
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.