77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation
- A Microsoft Office Specialist needs to work with Microsoft computer programs, including Excel, PowerPoint, and Word. Excel is a spreadsheet software program that allows users to store data.
- Certified Specialist in Microsoft Excel As a Certified Specialist in Microsoft Excel, you are able to analyze business problems to make quick and accurate decisions, build sophisticated spreadsheets, perform 'what-if' analyses, apply functions and manipulate PivotTables. Specialist Certification - Two Courses Plus Passing Associated Exams.
- Microsoft Office Specialist (MOS) Expert: Excel 365 and 2019 Earning MOS Excel Expert certification proves you have advanced-level skills and understanding in Excel and can assist others with proper use of the program’s features. The below courses, which are the same as those for the MOS credential above, can help you get started.
Languages: en ar-sa bg-bg zh-cn zh-tw de es fr it ja ko nl pl pt-br ro ru th tr
Retirement date:
Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They know and demonstrate the correct application of the principle features of Excel 2016. Candidates create and edit a workbook with multiple sheets, and they use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.
Price based on the country in which the exam is proctored.
for Excel 2016: Core Data Analysis, Manipulation, and PresentationMany AP specialists rely on software like Microsoft's Excel 2019 program to collect, track and update important financial data. This online course will prepare you for the Microsoft Office Specialist (MOS) Expert certification exam for Excel 2019 and award you an Accounts Payable Specialist (APS) certification upon successful course completion.
All objectives of the exam are covered in depth so you'll be ready for any question on the exam.
Microsoft Excel Specialist 2007
Validate your proficiency and advance your career as a certified Microsoft Office Specialist in Excel 2013. You'll master creating and managing worksheets and workbooks through hands-on training and performance-based scenarios.
Optimize Excel's powerful features and functions.
Explore the most useful of the 450+ formulas and functions in Excel.
Learn to move, copy, and analyze data stored in multiple worksheets and workbooks.
Courses
1
Excel 2013 Essential Training
By: Dennis Taylor
Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.
2
Excel 2013: Managing Multiple Worksheets and Workbooks
By: Dennis Taylor
Learn how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013.
3
Excel 2013: Charts in Depth
By: Dennis Taylor
Present data to your audience in a more visually compelling way with charts in this Excel tutorial.
4
Excel 2013: Advanced Formatting Techniques
By: Dennis Taylor
Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2013.
5
Excel 2013: Advanced Formulas and Functions
By: Dennis Taylor
In this series of Excel tutorials, discover some of the most challenging of the 300+ formulas and functions in Excel, and learn about how to put them to their best use.
6
Cert Prep: Excel 2013 Microsoft Office Specialist (77-420)
By: Jennifer McBee
Prep for the MOS Excel 2013 certification exam. Review worksheets and workbooks, cells and ranges, formulas and functions, charts, and other objects. Take the practice test.
Instructors
Dennis Taylor
Principal at Taylor Associates
Jennifer McBee
What Is An Excel Specialist
Instructor/Author of Microsoft Office Specialist Associate and Expert Certification Prep courses on LinkedIn Learning
Microsoft Excel Specialist
Related Topics