Employers around the world cite Microsoft Excel as one of the most sought-after skills for any new hire. This learning path helps you become an Excel power user—covering everything from functions and formatting to PivotTables and dashboards.
Master the powerful features and functions in Excel.
Learn how to use Excel's robust built-in formulas.
Become certified as a Microsoft Office Specialist (MOS) or MOS Expert.
Excel Essential Training (Office 365) with Dennis Taylor
Get up to speed with Microsoft Excel. Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, sort and filter data, and use other powerful Excel features.
2h 6m • COURSE
Excel 2016: Advanced Formulas and Functions with Dennis Taylor
Learn how to create efficient formulas and use some of the 450+ functions in Excel to tabulate and analyze numerical, date, and text data.
6h 18m • COURSE
Excel 2016: Advanced Formatting Techniques with Dennis Taylor
Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2016. Learn advanced Excel formatting techniques.
3h 29m • COURSE
Excel: Creating a Basic Dashboard with Curt Frye
Discover how to summarize spreadsheet data effectively in Excel 2016. Learn how to set up a dashboard worksheet, create links to workbook elements, maximize your screen space by hiding rows, and more.
1h 31m • COURSE
Excel 2016: Charts in Depth with Dennis Taylor
Learn how to create advanced Excel charts, such as Gantt charts, custom pie charts, waterfall charts, and more, in Excel 2016.
4h 36m • COURSE
Excel 2016: Pivot Tables in Depth with Curt Frye
Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016.
3h 42m • COURSE
Cert Prep: Excel 2016 Microsoft Office Specialist (77-727) with Jennifer McBee
Demonstrate your advanced knowledge of Excel 2016 by becoming a Microsoft Office Specialist. This course helps you prepare for exam 77-727.
3h 3m • COURSE
Cert Prep: Excel 2016 Microsoft Office Expert (77-728) with Jennifer McBee
Demonstrate your advanced knowledge of Excel 2016 by becoming a Microsoft Office Specialist Expert. This course helps you prepare for exam 77-728.
3h 45m • COURSE
You'll master Excel 2016 with these experts
Dennis Taylor is an Excel expert who has 25+ years of experience in spreadsheet authoring and training.
Dennis has experience working 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 U.S. 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. He lives in Boulder, Colorado.
Curt Frye is the president of Technology and Society, Incorporated.He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for Lynda.com and LinkedIn Learning. As a speaker, he has presented talks on topics including "Rhetorical Mathematics" for CLE credit at the Law and Magic conference, "Business Storytelling Using Microsoft Excel" at the ATD-Cascadia annual conference, and his Improspectives® approach to applying the techniques of improv theater to business and life for numerous audiences. As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences.Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.
Microsoft Certified Trainer Jennifer McBee helps students master Office and pass MOS certification exams.
Jennifer has been a Microsoft Certified Trainer since 2007, successfully teaching Microsoft Office and other desktop software to such organizations as L.L.Bean, Siemens Healthcare Diagnostics, the City of Bangor, Time Warner Cable, the Maine Department of Labor, and Bangor International Airport. She holds Master-level MOS certification in Office 2003, 2007, 2010, and 2013, and she has served as a subject matter expert on exams for Office 2010 and 2013. She also runs a testing center for Certiport, the exclusive certification exam partner of Microsoft.
She has helped such organizations as the State of Maine Department of Labor, Time Warner Cable, Syracuse University, and others to prepare their employees to pass MOS Excel, Word, and PowerPoint 2010 and 2013 exams. She has done the same for students in Office classes at a local community college, where she has taught for three years.