Microsoft Excel Expert teaches students how to use a variety of intermediate and advanced features to consolidate data, perform data analysis, and audit formulas in spreadsheets. Students also use summary functions, create pivot tables and pivot charts, and work with macros. Students who complete this course will have reviewed all the exam objectives and be prepared to take the Microsoft Office Specialist Excel Expert Exam #MO-201. Successful completion of the certification exam validates the knowledge and skill sets for individuals seeking employment or advancement in their careers.