Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. The course starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly to real-world scenarios.
Course Introduction Video
CosmoLearning is promoting these materials solely for nonprofit educational purposes, and to recognize contributions made by Lynda.com (Lynda.com) to online education. We do not host or upload any copyrighted materials, including videos hosted on video websites like YouTube*, unless with explicit permission from the author(s).
All intellectual property rights are reserved to Lynda.com and involved parties.
CosmoLearning is not endorsed by Lynda.com, and we are not affiliated
with them, unless otherwise specified. Any questions, claims or concerns
regarding this content should be directed to their creator(s).
*If any embedded videos constitute copyright infringement, we strictly recommend contacting the website hosts directly to have such videos taken down. In such an event, these videos will no longer be playable on CosmoLearning or other websites.