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® OneNote 2013 teaches the information worker how to use this tool to organize, locate and share information. You will learn how to collect and organize notes, insert files, capture screens, and enhance notes for all types of projects. Additionally, you will collaborate with others, organize research ideas, integrate them with other Office applications, and view information with a shared notebook. Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft OneNote 2013 Exam #77-421. Pages: 146 Courseware Number: 3259-1 Print ISBN: 978-1-55332-400-3