- 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.
Overview
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.
Syllabus
Courses under this program:
Course 1: Excel 2013 Essential Training
-Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.
Course 2: Excel 2013: Managing Multiple Worksheets and Workbooks
-Learn how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013.
Course 3: Excel 2013: Charts in Depth
-Present data to your audience in a more visually compelling way with charts in this Excel tutorial.
Course 4: Excel 2019 Essential Training
-Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2019 features.
Course 5: Excel 2013: Advanced Formulas and Functions
-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.
Course 6: Cert Prep: Excel 2013 Microsoft Office Specialist (77-420)
-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.
Course 1: Excel 2013 Essential Training
-Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.
Course 2: Excel 2013: Managing Multiple Worksheets and Workbooks
-Learn how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013.
Course 3: Excel 2013: Charts in Depth
-Present data to your audience in a more visually compelling way with charts in this Excel tutorial.
Course 4: Excel 2019 Essential Training
-Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2019 features.
Course 5: Excel 2013: Advanced Formulas and Functions
-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.
Course 6: Cert Prep: Excel 2013 Microsoft Office Specialist (77-420)
-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.
Courses
-
Prepare for the Excel Associate/Microsoft Office Specialist exam for Microsoft 365 Apps.
-
Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.
-
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.
-
Get expert advice on Excel formatting to help your data stand out.
-
Learn how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013.
-
Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2019 features.
Taught by
Dennis Taylor and Jennifer McBee