Excel 2016 Essential Training

Start mastering Excel, the world’s most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.

Topics include:

• Identify two navigational features within the Excel interface.
• Distinguish the best approach to managing data in cells.
• Recognize how Excel processes simple formulas.
• Describe the different ways to access formatting features.
• Identify page layout parameters for printing worksheets.
• Determine the best approach to creating charts.
• Explain how best to manage multiple worksheets and workbooks.

About the Author

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.

Product Details

• Full Video Tutorials
• Video File Format: MP4
• Skill Level: Beginner
• Video Duration: 8h 53m
• Instructor: Dennis Taylor