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.
This Microsoft® Excel 2013 Level 2 Guide teaches the information worker how to work with intermediate or
advanced features for business reports such as charts to show trends or patterns‚ what-if scenarios‚ or table and database functions. The information worker will also look at more functions to set up more complex
calculations. Pages: 132 Courseware Number: 6281-1 Print ISBN: 978-1-55332-404-1