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 Excel 2016
If you work with numbers, you need to master Microsoft Excel 2016! This hands-on course will teach you dozens of shortcuts and tricks for setting up fully-formatted worksheets quickly and efficiently. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. In addition, you will get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. You will also learn Excel 2016 features, including Quick Analysis, Flash Fill, and new charting capabilities. This is not a tutorial, but an in-depth class. By the time you're done, you will be using this vital Office 2016 application like a pro.
Intermediate Microsoft Excel 2016
In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.
Advanced Microsoft Excel 2016
Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed Microsoft Excel training, you'll see how to truly maximize this program's functions and capabilities. After all, most organizations rely heavily on Excel to consolidate, analyze, and report data and want their employees to be proficient in this important program. This Excel training class gives you the skills you need to impress your current or future employer—and its online format means you can take this class from anywhere, at any time. With exercises, quizzes, and all the latest information, the best online Excel training is right here in this course. The lessons will simplify some of those tricky Excel concepts that might seem hard to grasp, so you can discover how Excel 2016 table tools actually take the complexity out of spreadsheet creation and management. When you've completed this course, you'll be able to accomplish just about everything Microsoft Excel has to offer in displaying, analyzing, reporting, and tracking data—and you'll understand it so well, you'll even be able to share your newfound skills with your friends and colleagues.
Series bundles are not eligible for partial drops or refunds. Transfers are available to other open sessions.