• Home
  • Course Catalog
  • Contact Us
Loading... Loading... Please wait...
Request info
Contact Us
First Name*
Last Name*
Lead Status
Lead Source*
External Referrer
Partner SMEC ID
Enter text from the pic*

Microsoft Excel 2013 (Voucher Included) (MS-EX13)


Course Description

This course consist of three modules:
In Microsoft Excel Beginning, you’ll cover basic through advanced topics, including:
How to enter data and format cells and apply number formats
Practice how to create formulas and audit the cell references
Learn how to represent data as Charts
Use pictures and graphics
In Microsoft Excel Intermediate you’ll cover basic through advanced topics, including:
Create formulas that use Relative and Absolute values and audit the formulas
Use and modify TEXT formulas to combine cells (Concatenate) and format the data
Create, use and troubleshoot Named Ranges and use Named Ranges in formulas
Understand how to create and use Lookup Tables and use the IF functions
Excel In Print: Use page Layout and Page Set up to modify print settings
Excel Online: Use and modify Sparklines and hyperlinks
In Microsoft Excel Advanced, you’ll learn how to:
Analyze data visually with a PivotChart.
Create a PivotChart and Show the Field List.
Edit the Value Field Settings.
Filter the data in the PivotChart.
Edit the Chart Layouts and Chart Style.
Use Slicers


This course teaches the following Exam 77-420: Microsoft Excel 2013 Objectives
Excel® 2013 Core: Exam 77-420
Excel 2013 Expert Part 1: Exam 77-427
Excel 2013 Expert Part 2: Exam 77-428

1.0 Create and Manage Worksheets and Workbooks
1.1 Create Worksheets and Workbooks
1.1.1 Create New Blank Workbooks
1.1.2 Create New Workbooks Use Templates
1.1.3 Import Files
1.1.4 Open Non-Native Files Directly in Excel
1.1.5 Add Worksheets to Existing Workbooks
1.1.6 Copy and Move Worksheets
1.2 Navigate Through Worksheets and Workbooks
1.2.1 Search For Data Within A Workbook
1.2.2 Insert Hyperlinks
1.2.3 Change Worksheet Order
1.2.4 Demonstrate How to Use Go to
1.2.5 Demonstrate How to Use Name Box
1.3 Format Worksheets and Workbooks
1.3.1 Change Worksheet Tab Color
1.3.2 Modify Page Setup
1.3.3 Insert and Delete Columns and Rows
1.3.4 Change Workbook Themes
1.3.5 Adjust Row Height and Column Width
1.3.6 Insert Watermarks
1.3.7 Insert Headers and Footers
1.3.8 Set Data Validation
1.4 Customize Options and Views For Worksheets and Workbooks
1.4.1 Hide Worksheets
1.4.2 Hide Columns and Rows
1.4.3 Customize The Quick Access Toolbar
1.4.4 Customize The Ribbon
1.4.5 Manage Macro Security
1.4.6 Change Workbook Views
1.4.7 Record Simple Macros
1.4.8 Add Values to Workbook Properties
1.4.9 Demonstrate How to Use Zoom
1.4.10 Display Formulas
1.4.11 Freeze Panes
1.4.12 Assign Shortcut Keys
1.4.13 Split The Window
1.5 Configure Worksheets and Workbooks to Print Or Save
1.5.1 Set A Print Area
1.5.2 Save Workbooks in Alternate File Formats
1.5.3 Print Individual Worksheets
1.5.4 Set Print Scaling
1.5.5 Repeat Headers and Footers
1.5.6 Maintain Backward Compatibility
1.5.7 Configure Workbooks to Print
1.5.8 Save Files to Remote Locations

2.0 Create Cells and Ranges
2.1 Insert Data in Cells and Ranges
2.1.1 Append Data to Worksheets
2.1.2 Find and Replace Data
2.1.3 Copy and Paste Data
2.1.4 Demonstrate How to Use Autofill Tool
2.1.5 Expand Data Across Columns
2.1.6 Insert and Delete Cells
2.2 Format Cells and Ranges
2.2.1 Merge Cells
2.2.2 Modify Cell Alignment and Indentation
2.2.3 Change Font and Font Styles
2.2.4 Use Format Painter
2.2.5 Wrap Text Within Cells
2.2.6 Apply Number Formats
2.2.7 Apply Highlighting
2.2.8 Apply Cell Styles
2.2.9 Change Text to Wordart
2.3 Order and Group Cells and Ranges
2.3.1 Apply Conditional Formatting
2.3.2 Insert Sparklines
2.3.3 Transpose Columns and Rows
2.3.4 Create Named Ranges
2.3.5 Create Outlines
2.3.6 Collapse Groups Of Data in Outlines
2.3.7 Insert Subtotals
3.0 Create Tables
3.1 Create A Table
3.1.1 Move Between Tables and Ranges
3.1.2 Add and Remove Cells Within Tables
3.1.3 Define Titles
3.2 Modify A Table
3.2.1 Apply Styles to Tables
3.2.2 Band Rows and Columns
3.2.3 Insert Total Rows
3.2.4 Remove Styles From Tables
3.3 Filter and Sort A Table
3.3.1 Filter Records
3.3.2 Sort Data On Multiple Columns
3.3.3 Change Sort Order
3.3.4 Remove Duplicates

4.0 Apply Formulas and Functions
4.1 Apply Cell Ranges and References in Formulas and Functions
4.1.1 Demonstrate How to Use References (Relative, Mixed, Absolute)
4.1.2 Define Order Of Operations
4.1.3 Reference Cell Ranges in Formulas

4.2 Summarize Data With Functions
4.2.1 Demonstrate How to Apply The SUM Function
4.2.2 Demonstrate How to Apply The MIN and MAX Functions
4.2.3 Demonstrate How to Apply The COUNT Function
4.2.4 Demonstrate How to Apply The AVERAGE Function
4.3 Apply Conditional Logic in Functions
4.3.1 Demonstrate How to Apply The SUMIF Function
4.3.2 Demonstrate How to Apply The AVERAGEIF Function
4.3.3 Demonstrate How to Apply The COUNTIF Function
4.4 Format and Modify Text With Functions
4.4.1 Demonstrate How to Use The RIGHT, LEFT and MID Functions
4.4.2 Demonstrate How to Use The TRIM Function
4.4.3 Demonstrate How to Use The UPPER and LOWER Functions
4.4.4 Demonstrate How to Use The CONCATENATE Function

Create Charts and Objects
5.1 Create A Chart
5.1.1 Create Charts and Graphs
5.1.2 Add Additional Data Series
5.1.3 Switch Between Rows and Columns in Source Data
5.1.4 Demonstrate How to Use Quick Analysis
5.2 Format A Chart
5.2.1 Add Legends
5.2.2 Resize Charts and Graphs
5.2.3 Modify Chart and Graph Parameters
5.2.4 Apply Chart Layouts and Styles
5.2.5 Position Charts and Graphs
5.3 Insert and Format An Object
5.3.1 Insert Text Boxes
5.3.2 Insert Smartart
5.3.3 Insert Images
5.3.4 Add Borders to Objects
5.3.5 Add Styles and Effects to Objects
5.3.6 Change Object Colors
5.3.7 Modify Object Properties
5.3.8 Position Objects

This Course Teaches the Following Exam 77-427 and 428 Microsoft Excel Expert 2013 Objectives
1.0 Manage and Share Workbooks
1.1 Manage Multiple Workbooks
1.1.1 Modify Existing Templates
1.1.2 Merge Multiple Workbooks
1.1.3 Manage Versions Of A Workbook
1.1.4 Copy Styles From Template to Template
1.1.5 Copy Macros From Workbook to Workbook
1.1.6 Link to External Data
1.2 Prepare A Workbook For Review
1.2.1 Set Tracking Options
1.2.2 Limit Editors
1.2.3 Create Workspaces
1.2.4 Restrict Editing
1.2.5 Control Recalculation
1.2.6 Protect Worksheet Structure
1.2.7 Mark As Final
1.2.8 Remove Workbook Metadata
1.2.9 Encrypt Workbooks With A Password
1.3 Manage Workbook Changes
1.3.1 Track Changes
1.3.2 Manage Comments
1.3.3 Identify Errors
1.3.4 Troubleshoot With Tracing
1.3.5 Display All Changes
1.3.6 Retain All Changes

2.0 Apply Custom Formats and Layouts
2.1 Apply Custom Data Formats
2.1.1 Create Custom Formats (Number, Time, Date)
2.1.2 Create Custom Accounting Formats
2.1.3 Demonstrate How to Use Advanced Fill Series Options
2.2 Apply Advanced Conditional Formatting and Filtering
2.2.1 Write Custom Conditional Formats
2.2.2 Demonstrate How to Use Functions to Format Cells
2.2.3 Create Advanced Filters
2.2.4 Manage Conditional Format Rules
2.3 Apply Custom Styles and Templates
2.3.1 Create Custom Color Formats
2.3.2 Create and Modify Cell Styles
2.3.3 Create and Modify Custom Templates
2.3.4 Create Form Fields
2.4 Prepare A Workbook For Internationalization and Accessibility
2.4.1 Modify Tab Order Among Workbook Elements and Objects
2.4.2 Display Data in Multiple International Formats
2.4.3 Modify Worksheets For Use With Accessibility Tools
2.4.4 Demonstrate How to Use International Symbols
2.4.5 Manage Multiple Options For +Body and +Heading Fonts

3.0 Create Advanced Formulas
3.1 Apply Functions in Formulas
3.1.1 Demonstrate How to Use The IF Function in Conjunction With Other Functions
3.1.2 Demonstrate How to Use AND/OR Functions
3.1.3 Demonstrate How to Use Nested Functions
3.1.4 Demonstrate How to Use SUMIFS, AVERAGEIFS, and COUNTIFS Functions
3.2 Look Up Data With Functions
3.2.1 Demonstrate How to Use The LOOKUP Function
3.2.2 Demonstrate How to Use The VLOOKUP Function
3.2.3 Demonstrate How to Use The HLOOKUP Function
3.2.4 Demonstrate How to Use The TRANSPOSE Function
3.3 Apply Advanced Date and Time Functions
3.3.1 Demonstrate How to Use The NOW and TODAY Functions
3.3.2 Demonstrate How to Use Functions to Serialize Dates and Times
3.4 Create Scenarios
3.4.1 Demonstrate How to Use The Watch Window
3.4.2 Consolidate Data
3.4.3 Enable Iterative Calculations
3.4.4 Demonstrate How to Use What If Analysis Tools Including Goal Seek
3.4.5 Demonstrate How to Use The Scenario Manager
3.4.6 Demonstrate How to Use Financial Functions

4.0 Create Advanced Charts and Tables
4.1 Create Advanced Chart Elements
4.1.1 Add Trendlines to Charts
4.1.2 Create Dual Axis Charts
4.1.3 Create Custom Chart Templates
4.1.4 View Chart Animations
4.2 Create and Manage Pivot Tables
4.2.1 Create New Pivot Tables
4.2.2 Modify Field Selections and Options
4.2.3 Create A Slicer
4.2.4 Group Records
4.2.5 Utilize Calculated Fields
4.2.6 Format Data
4.2.7 Demonstrate How to Use PowerPivot
4.2.8 Manage Relationships
4.3 Create and Manage Pivot Charts
4.3.1 Create New Pivot Charts
4.3.2 Manipulate Options in Existing Pivot Charts
4.3.3 Apply Styles to Pivot Charts

Grading and Examination: This course has continuous assessments for goal-based learning. Each Level has an online quiz. There are several Skill Tests for students to demonstrate practical use of the materials. A student must earn 70% of the possible points for credit on the course. There is no penalty for re-taking a quiz or resubmitting a Skill Test to achieve a better score.


12 months




To enroll in the Microsoft Excel 2013 program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up files.
This program is for you if you’re an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately. This program is also suitable for you if you’re looking to learn about this software and expand your job possibilities.


This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. A core-level candidate for the Microsoft Excel 2013 exam should have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Excel 2013. These candidates should be able to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs. Candidate roles might include students, clerical workers, bookkeepers, instructors, and others.




Elizabeth Ann Nofs is the designer, developer, and instructor of the Comma Mama Guides. She developed a successful method for teaching visually that is based on observation, orientation and notation. The books that I wrote for this course meet the Microsoft Vendor of Approved course ware. As the instructor for this program, Elizabeth is available to provide guidance and motivation for learners throughout the duration of this program. As an expert mentor, she will provide answers to learner questions, monitor learner's program progression, and review lesson and program quiz/test results


This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with Windows 7 and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and an e-mail account. You should also have Microsoft Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word.
All materials for this program are available online.
The following resources are available to download throughout the lessons:
• Beginning, Intermediate and Advanced Guides to Microsoft® Excel 2013 (PDF)
• Microsoft Excel 2013 Beginning, Intermediate and Advanced Sample files.
This program does not require any additional purchases of supplementary materials.

Find Similar Courses by Category