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.
Microsoft® Word 2010 Level 2 teaches students some intermediate skills that can be combined with basic skills to create more complex documents. Students will look at features such as creating and formatting tables‚ inserting and modifying pictures or shapes‚ learn what merging means in relation to mass mailings‚ and look at different ways of sharing documents with others.