Microsoft Excel 2016 Series
A total of 2,712,362 job posts within the last year have listed knowledge of Microsoft Excel as a critical skill for the role, and it's not just within the finance and accounting industries. Everyone from Human Resources professionals to Retail Salespersons are using Excel in their day-to-day functions.
This Series combines three Microsoft Excel 2016 courses, to give you a thorough understanding of how to use this software to supplement your career. Courses include:
- Introduction to Microsoft...
University of the District of Columbia
Each course within the Excel Series will build upon the last, giving you expert knowledge in navigating and using the software.
Introduction to Microsoft Excel 2016
In this comprehensive online course, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links, and creating macros and custom toolbar buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016.
Intermediate Microsoft Excel 2016
In these hands-on lessons, you'll learn how to create informative, eye-catching charts and graphs, and master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016. Harness the power of Excel's data analysis tools and AutoFilter commands, and see how easy it is to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.
Advanced Microsoft Excel 2016
Maximize your investment in Microsoft Excel 2016 by mastering advanced features that most users don't even know exist. In this course, you'll discover how to use scenarios and data tables to quickly perform multiple what-if data analysis. You'll discover a variety of advanced techniques for PivotTables, and see how to work with the additional analysis tools provided by Excel add-ins. You'll master the art of conditional formatting to highlight duplicate entries, become adept at importing external data using Excel's built-in Power Query tool, learn how use Excel's consolidation function to efficiently summarize data from multiple sources, and so much more.
Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles..
How the course is taught
- Instructor-led online course
- 72 course hours
Chad Wambolt is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. He has spent his entire professional career in the finance field, working for both privately and publicly held companies with sales ranging from $500 million to $3 billion. Through the course of his career, Chad has become an expert user of Microsoft Excel. His knowledge of Excel's capabilities has helped organizations streamline processes and save countless hours of labor. Chad has taught Excel to students of varying skill levels since 1997.
Instructor Interaction: The instructor looks forward to interacting with learners in the online moderated discussion area to share their expertise and answer any questions you may have on the course content.
There are no prerequisites to take this course.
- This course must be taken on a PC. Macs are not compatible.
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
- Microsoft Office Excel 2016 version (not included in enrollment)
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.