Training Series Overview
This series covers the basic functions and features of Excel 2013. Students will learn about calculations and how to modify and
format a worksheet. They will also learn how to customize the Excel environment and how to manage and print workbooks.
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: 8
Students can earn up to 8 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 - Getting Started with Microsoft Excel 2013Access Now - No Membership Required
32m
Topic A - Identify the Elements of the Excel Interface
Demo 1 - Excel Elements
Topic B - Create a Basic Worksheet
Demo 1 - Creating a Spreadsheet
Topic C - Use the Help System
Demo 1 - Using Help System
Course 02 - Performing Calculations
42m
Topic A - Create Formulas in a Worksheet
Demo 1 - Creating Formulas
Topic B - Insert Functions in a Worksheet
Demo 1 - Insert Functions in a Worksheet
Topic C - Reuse Formulas
Demo 1 - Reusing Formulas
Course 03 - Modifying a Worksheet
36m
Topic A - Manipulate Data
Demo 1 - Manipulating Data
Topic B - Insert, Manipulate, and Delete Cells, Columns, and Rows
Demo 1 - Adjust Display of Columns
Topic C - Search for and Replace Data
Demo 1 - Searching for and Replacing Data
Topic D - Spell Check a Worksheet
Demo 1 - Spell Checking a Worksheet
Course 04 - Formatting a Worksheet
46m
Topic A - Modify Fonts
Demo 1 - Modifying Fonts
Topic B - Add Borders and Color to Cells
Demo 1 - Adding Borders and Color to Cells
Topic C - Apply Number Formats
Demo 1 - Applying Number Formats
Topic D - Align Cell Contents
Demo 1 - Aligning Cell Contents
Topic E - Apply Cell Styles
Demo 1 - Applying Cell Styles
Course 05 - Printing Workbook Contents
28m
Topic A - Define the Basic Page Layout for a Workbook
Demo 1 - Previewing a Workbook Before Print
Demo 2 - Applying Print Changes
Topic B - Refine the Page Layout and Apply Print Options
Demo 1 - Refine Print Layout
Course 06 - Managing Large Workbooks
21m
Topic A - Format Worksheet Tabs
Demo 1 - Formatting Worksheet Tabs
Topic B - Manage Worksheets
Demo 1 - Managing Worksheets
Topic C - Manage the View of Worksheets and Workbooks
Demo 1 - Managing the View of Worksheets and Workbooks
Course 07 - Customizing the Excel Environment
28m
Topic A - Customize General and Language Options
Demo 1 - Customizing General and Language Options
Topic B - Customize Formula Options
Demo 1 - Formula Options
Topic C - Customize Proofing and Save Options
Demo 1 - Customizing Proofing and Save Options
Topic D - Customize the Ribbon and Quick Access Toolbar
Demo 1 - Customizing the Quick Access Toolbar
Topic E - Customize the Functionality of Excel by Enabling Add-Ins
Demo 1 - Customizing the Functionality of Excel
Topic F - Customize Advanced and Trust Center Options
Demo 1 - Customizing Advanced and Trust Center Options
Training Final Exam
Are you ready to earn your certificate of completion? If so, Launch the Final Exam below to do so now!
|