Earn the latest Excel certification, Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) MO-200. Certification preparation includes live practice with the instructor. These essential and advanced Excel skills will make you invaluable. Formulas, insert functions, conditional formatting and templates will be covered, as well as charts, pivot tables and many other amazing Excel tools. Create, modify and format worksheets, modify cells, columns and rows and print and manage workbooks. Work with Excel spreadsheets in simple to sophisticated ways. Demonstrate your knowledge of Excel 2019 by becoming MO-200 Microsoft Excel Certified. Microsoft Excel is one of the most sought-after skills in today’s job market. This leads to data-driven business decisions that have a better chance for success for everyone involved. You will not only be able to summarize data for you to analyze, but also organize the data in a way that meaningfully presents it to others. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You already have experience working with Excel and creating basic PivotTables to summarize data, but Excel is capable of doing much more. Along with this, the need to analyze that data and gain actionable insight is greater than ever. PREREQUISITE: Intermediate Excel or equivalent.Īdvances in technology have made it possible to store ever increasing amounts of data.
If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at we can assist with enrollment. To see if you qualify, or to explore all of our grant-supported classes, please click here. This class is being offered through our Grant-Supported Training program, and is free to employees of most NJ businesses.
Also learn how to create conditional formatting rules using formulas, perform complex calculations using Array formulas and create customized lists using data validation. Learn how to analyze data using advanced formula skills by focusing on functions from various categories within the function library. This course is designed for participants who have a basic knowledge of Excel functions and want to discover how advanced functions can help save time at work.
PREREQUISITE: Understand and use basic Excel functions.