Available Courses
Level 1 - Introduction and Basics
The Excel 2013 - Introduction and Basics course is part of the MOS exam 77-420 range. You will learn how to open workbooks as well as navigate directly to cells and between worksheets. You will also use the viewing tools for worksheets. The estimated time to complete this course is 2 hours and 20 minutes.
Level 2- Cells and Worksheets
The Excel 2013 - Introduction and Basics course is part of the MOS exam 77-420 range. You will learn how to open workbooks as well as navigate directly to cells and between worksheets. You will also use the viewing tools for worksheets. The estimated time to complete this course is 2 hours and 20 minute.
Level 3- Views and Layout
The Excel 2013 - Views and Layout course is part of the MOS exam 77-420 range. You will use Excel views, and import and export files. You will also insert hyperlinks, add workbook properties, add headers, use Page Setup and the Print Place. The estimated time to complete this course is 3 hours and 14 minutes.
Level 4- Formatting and Proofing
The Excel 2013 - Formatting and Proofing course is part of the MOS exam 77-420 range. You will use AutoFill and Paste options, modify and group worksheets, apply styles and format worksheets. You will also use proofing tools, Flash Fill and record macros. The estimated time to complete this course is 3 hours and 10 minutes.
Level 5- Formulars and Functions
The Excel 2013 - Formulas and Functions course is part of the MOS exam 77-420 range. You will learn how to use formulas and functions in Excel including Informational, Logical, Financial, Text functions, data tables and using named ranges. The estimated time to complete this course is 3 hours and 12 minutes.
Level 6- Presenting Data Visually
The Excel 2013 - Presenting Data Visually course is part of the MOS exam 77-420 range. You will create charts and add illustrations using Pictures, WordArt, SmartArt, and ClipArt. You will also learn how to add Shapes and Sparklines and use Outlining tools. The estimated time to complete this course is 2 hours and 5 minutes.
Level 7- Sharing and Validating Data
The Excel 2013 - Sharing and Validating Data course is part of the MOS exam 77-420 range. You will learn how to add comments and share workbooks. You will also sort data and apply filters, use custom and conditional formats as well as validate data. The estimated time to complete this course is 2 hours and 7 minutes.
Excel 2013 - Level 1 Advanced
The Excel 2013 Level 1 Advanced course is part of MOS exam 77-427 range. You will learn how to work with advanced chart features, pivot tables and pivot charts.
