Microsoft Excel 2016 Core teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.
Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Office Specialist Excel 2016 Exam #77-727.
Microsoft® Excel Expert teaches students how to use a variety of intermediate and advanced features to merge workbooks, perform data analysis, and audit formulas in spreadsheets. Students also use summary functions, create PivotTables and PivotCharts, and work with macros. Students who complete this course will have reviewed all the exam objectives to prepare for: Microsoft Excel 2016 Expert Exam #77-728. Successful completion of the certification exam provides a competitive advantage by validating the knowledge and skill sets for individuals who may be seeking employment or further job opportunities in their careers.