Microsoft Excel 2013 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 2013 Expert Exams #77-427 and #77-428. Successful completion of the certification exams provide 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 2016 Certification Guide teaches students how to design, create, and manage databases. Students will design tables, select appropriate data types, and create logical relationships. They will also create and manage queries, forms, and reports, and will use techniques to streamline data entry, maintain data integrity, and analyze data.