Training Series Overview
This series covers the advanced functions and features of Excel 2013. Students will learn about working with multiple worksheets
and automating and auditing worksheets. They will also learn how to export, analyze and present Excel data.
Career Path:
In high-growth industries, entry-level employees who hold a Microsoft Office Specialist (MOS) certification can earn up to $16,000
more, annually, than their peers. Five times as many high-growth/high-salary positions require experience with Office than all non-
Microsoft software skills combined. Twenty-nine percent of tomorrow’s high-growth/high-wage positions require Office or Office-
related skills.
Series Taught By:
Debbie Fierst
Certification Details
Office 2013 combines cloud and web technologies to extend the way you create and consume information and introduces a new cloud
app model for you to build secure and flexible apps—all discoverable from the familiar Office interface. There are no prerequisites
for the Microsoft Office Specialist 2013 certification.
Certification Exam Details:
This training will prepare you for the Microsoft Office Specialist Certification. To learn more, please go to
Certiport for
certification details.
Available CEUs for Course Series Completion: 6
Students can earn up to 6 CEUs for fully completing this course series. This information will be displayed on the certificate of completion.
Learn More
Access Training Courses Below
Click any of the titles below to launch your videos:
Course 01 - Automating Worksheet FunctionalityAccess Now - No Membership Required
42m
Topic A - Update Workbook Properties
Demo 1 - Updating Workbook Properties
Demo 2 - Modifying the Default Settings in Excel
Topic B - Create and Edit a Macro
Demo 1 - Creating a Macro
Demo 2 - Editing a Macro
Topic C - Apply Conditional Formatting
Demo 1 - Applying Conditional Formatting
Demo 2 - Editing a Conditional Formatting Rule
Topic D - Add Data Validation Criteria
Demo 1 - Adding Data Validation Criteria
Course 02 - Auditing Worksheets
37m
Topic A - Trace Cells
Demo 1 - Tracing Cell Precedents and Dependents
Topic B - Troubleshoot Invalid Data and Formula Errors
Demo 1 - Troubleshooting Invalid Data
Demo 2 - Troubleshooting Invalid Formulas
Topic C - Watch and Evaluate Formulas
Demo 1 - Evaluating a Formula
Topic D - Create a Data List Outline
Demo 1 - Creating a Data List Outline
Demo 2 - Adding Subtotals to Grouped Data
Course 03 - Analyzing and Presenting Data
1hr 2m
Topic A - Create Sparklines
Demo 1 - Adding Sparklines to Your Worksheet
Demo 2 - Editing Sparkline Data
Topic B - Create Scenarios
Demo 1 - Adding a Scenario
Demo 2 - Editing Scenario Data
Topic C - Perform a What-If Analysis
Demo 1 - Using Goal Seek
Demo 2 - Installing the Solver Tool Add-In
Demo 3 - Using Solver to Perform a What-If Analysis
Topic D - Perform a Statistical Analysis with the Analysis ToolPak
Demo 1 - Performing a Data Analysis with Analysis ToolPak-Descriptive Statistics
Topic E - Create Interactive Data with Power View
Demo 1 - Creating a Power View Worksheet
Course 04 - Working With Multiple Workbooks
29m
Topic A - Consolidate Data
Demo 1 - Consolidating Data
Topic B - Link Cells in Different Workbooks
Demo 1 - Linking Cells in Different Workbooks
Demo 2 - Editing Links
Topic C - Merge Workbooks
Demo 1 - Merging Workbooks
Course 05 - Exporting Excel Data
36m
Topic A - Export Excel Data
Demo 1 - Exporting Excel Data
Topic B - Import a Delimited Text File
Demo 1 - Importing a Delimited Text File
Topic C - Integrate Excel Data with the Web
Demo 1 - Publishing a Worksheet to the Web
Demo 2 - Importing Data from the Web
Topic D - Create a Web Query
Demo 1 - Creating a Web Query
Training Final Exam
Are you ready to earn your certificate of completion? If so, Launch the Final Exam below to do so now!
|