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® Access 2013 Certification Guide teaches students how to design data tables‚ select appropriate data types and relate tables logically. Students will create and modify database objects including tables‚ forms‚ reports‚ queries and macros‚ and will apply intermediate skills to streamline data entry‚ ensure data integrity‚ automate tasks and analyze data.