Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training. Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences.
Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. Mac home design software reviews. He lives in Boulder, Colorado. By: Curt Frye course.
6h 32m 34s. 4,855 viewers.
Excel For Mac 2011 Training
Course Transcript - Voiceover Hi I'm Dennis Taylor and welcome to Excel 2011 for the Mac, managing and analyzing data. When you work with large lists, you need tools to manage your data and get the most information out of them. Excel has a variety of features specifically designed for these purposes and I'll cover them in detail in this course. I'll start by showing you a variety of ways to use the most important data management tool, sorting, and then show you how you can see just the data you need using filtering. I'll also show you how to automatically insert subtotals into sorted lists, how to identify and delete duplicate data, and how to gather valuable statistical information via the sum if family of functions and the database statistical functions. So let's get started with Excel 2011 for the Mac, managing and analyzing data. Practice while you learn with exercise files.