Course Overview

Training Options

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Course Content

  • Microsoft® Excel® 2013 Foundation: MOS Certification

    Preview
    • Lesson 00 - Overview of MOS Foundation

      07:30Preview
      • 0.1 Welcome
        00:07
      • 0.2 Overview of MOS Foundation
        01:00
      • 0.3 Table of Content
        00:52
      • 0.4 Course Objective
        00:30
      • 0.5 Course Overview
        00:57
      • 0.6 Value of Excel for Professionals
        00:41
      • 0.7 Value of Excel for Organizations
        00:40
      • 0.8 Lessons Covered
        00:15
      • 0.9 Exam Pattern
        00:30
      • 0.10 MOS Excel 2013 Level 1 Certification
        01:31
      • 0.11 Sources of Information
        00:18
      • 0.12 Thank you
        00:09
    • Lesson 01 - Introduction to Excel 2013

      13:12Preview
      • 1.1 Introduction to Excel 2013
        00:22
      • 1.2 Objectives
        00:29
      • 1.3 Excel 2013 Application User Interface
        01:05
      • 1.4 Excel 2013 Application User Interface contd
        00:31
      • 1.5 Excel 2013 Application Window
        00:27
      • 1.6 Excel 2013 Application Window Elements
        01:41
      • 1.7 Ribbon Options
        00:49
      • 1.8 Business Scenario
        01:29
      • 1.9 Demo Summary
        00:20
      • 1.10 Quick Access Toolbar
        00:30
      • 1.11 Customize Quick Access Toolbar
        00:22
      • 1.12 Business Scenario
        01:25
      • 1.13 Demo summary
        00:23
      • 1.14 Backstage View in Excel 2013
        00:26
      • 1.15 New Features in Excel 2013
        01:46
      • 1.16 Quiz
      • 1.17 Summary
        01:03
      • 1.18 Thank You
        00:04
    • Lesson 02 - Create and Manage Workbooks and Worksheets

      01:12:04Preview
      • 2.1 Create and Manage Workbooks and Worksheets
        00:22
      • 2.2 Objectives
        00:26
      • 2.3 Excel 2013 Workbooks
        01:11
      • 2.4 Create a Blank Workbook
        00:31
      • 2.5 Create a Workbook from a Template
        00:38
      • 2.6 Open an Existing Workbook
        00:25
      • 2.7 Business Scenario
        02:36
      • 2.8 Demo Summary
        00:19
      • 2.9 Native and Non native Files
        02:15
      • 2.10 Connect Import External Files
        02:06
      • 2.11 Connect Import External Files contd
        01:08
      • 2.12 Business Scenario
        03:08
      • 2.13 Demo summary
        00:33
      • 2.14 Worksheet Operations
        01:28
      • 2.15 Change Worksheet Tab Color
        00:32
      • 2.16 Hide or Unhide Worksheets
        00:28
      • 2.17 Business Scenario
        02:35
      • 2.18 Demo summary
        00:14
      • 2.19 Search and Replace Data
        00:28
      • 2.20 Go To and Name Box
        00:38
      • 2.21 Business Scenario
        02:30
      • 2.22 Demo summary
        00:23
      • 2.23 Insert Hyperlinks
        00:58
      • 2.24 Business Scenario
        01:14
      • 2.25 Demo summary
        00:19
      • 2.26 Modifying Workbook Themes
        00:49
      • 2.27 Modify Page Setup
        01:19
      • 2.28 Insert and Delete Columns and Rows
        01:00
      • 2.29 Modify Row Height and Column Width
        00:44
      • 2.30 Hide or Unhide Columns and Rows
        00:24
      • 2.31 Business Scenario
        03:38
      • 2.32 Demo summary
        00:44
      • 2.33 Insert Headers and Footers
        00:38
      • 2.34 Insert Headers and Footers contd
        00:33
      • 2.35 Business Scenario
        02:08
      • 2.36 Demo summary
        00:21
      • 2.37 Data Validation
        01:49
      • 2.38 Data Validation contd
        01:04
      • 2.39 Business Scenario
        04:01
      • 2.40 Demo summary
        00:25
      • 2.41 Enable Developer Tab
        00:37
      • 2.42 Macro Security Options
        01:36
      • 2.43 Record Macros
        01:38
      • 2.44 Business Scenario
        03:43
      • 2.45 Demo summary
        00:33
      • 2.46 Backward Compatibility
        01:32
      • 2.47 Workbook Views
        01:05
      • 2.48 Use Zoom for Workbooks
        00:43
      • 2.49 Freeze Panes
        01:04
      • 2.50 Split Window
        00:22
      • 2.51 Business Scenario
        02:23
      • 2.52 Demo summary
        00:19
      • 2.53 Show Formulas
        00:23
      • 2.54 Business Scenario
        00:41
      • 2.55 Demo summary
        00:12
      • 2.56 Add Values to Workbook Properties
        00:33
      • 2.57 Business Scenario
        01:07
      • 2.58 Demo summary
        00:14
      • 2.59 Save Workbooks in Alternate File Formats
        01:24
      • 2.60 Set Print Area and Print Workbooks
        00:46
      • 2.61 Business Scenario
        01:43
      • 2.62 Demo summary
        00:23
      • 2.63 Save Workbooks to Remote Locations
        00:50
      • 2.64 Quiz
      • 2.65 Summary
        01:05
      • 2.66 Thank You
        00:06
    • Lesson 03 - Create Cells and Ranges

      44:46Preview
      • 3.1 Create Cells and Ranges
        00:25
      • 3.2 Objectives
        00:27
      • 3.3 Cells and Ranges
        01:02
      • 3.4 Create Data using FillSeries
        01:16
      • 3.5 Business Scenario
        01:45
      • 3.6 Demo Summary
        00:16
      • 3.7 Create Data using AutoFill
        00:54
      • 3.8 Business Scenario
        02:28
      • 3.9 Demo Summary
        00:15
      • 3.10 Customize AutoFill Options
        00:44
      • 3.11 Business Scenario
        02:43
      • 3.12 Demo Summary
        00:19
      • 3.13 Paste Options
        00:43
      • 3.14 Paste Special
        02:09
      • 3.15 Format Cell Structure
        01:30
      • 3.16 Business Scenario
        02:12
      • 3.17 Demo Summary
        00:11
      • 3.18 Merge and Center
        01:17
      • 3.19 Business Scenario
        00:51
      • 3.20 Demo Summary
        00:11
      • 3.21 Format Cell Content
        01:14
      • 3.22 Business Scenario
        01:33
      • 3.23 Demo Summary
        00:15
      • 3.24 Cell Styles
        01:00
      • 3.25 Business Scenario
        01:53
      • 3.26 Demo Summary
        00:13
      • 3.27 Number Formats
        01:54
      • 3.28 Format Painter
        00:28
      • 3.29 Business Scenario
        01:21
      • 3.30 Demo Summary
        00:12
      • 3.31 Data Model with Advanced Conditional Format
        01:41
      • 3.32 Data Model with Advanced Conditional Format contd
        00:30
      • 3.33 Sparklines
        01:11
      • 3.34 Business Scenario
        01:34
      • 3.35 Demo Summary
        00:12
      • 3.36 Create Named Ranges
        01:08
      • 3.37 Business Scenario
        02:32
      • 3.38 Demo Summary
        00:14
      • 3.39 Data Group and Ungroup
        01:17
      • 3.40 Subtotals
        01:11
      • 3.41 Quiz
      • 3.42 Summary
        01:27
      • 3.43 Thank You
        00:08
    • Lesson 04 - Create Tables

      29:54Preview
      • 4.1 Create Tables
        00:22
      • 4.2 Objectives
        00:22
      • 4.3 Tables in Excel 2013
        00:58
      • 4.4 Create and Format a Table
        00:34
      • 4.5 Business Scenario
        01:08
      • 4.6 Demo Summary
        00:19
      • 4.7 Define Table Names
        00:32
      • 4.8 Business Scenario
        01:34
      • 4.9 Demo Summary
        00:17
      • 4.10 Insert Table Rows and Columns
        00:46
      • 4.11 Business Scenario
        02:16
      • 4.12 Demo Summary
        00:17
      • 4.13 Delete Table Rows and Columns
        00:48
      • 4.14 Business Scenario
        01:27
      • 4.15 Demo Summary
        00:22
      • 4.16 Move Table Rows and Columns
        00:19
      • 4.17 Business Scenario
        02:10
      • 4.18 Demo Summary
        00:29
      • 4.19 Convert to Range
        00:22
      • 4.20 Business Scenario
        01:06
      • 4.21 Demo Summary
        00:21
      • 4.22 Remove Duplicates
        00:15
      • 4.23 Business Scenario
        01:42
      • 4.24 Demo Summary
        00:19
      • 4.25 Design Table Styles
        00:37
      • 4.26 Business Scenario
        00:52
      • 4.27 Demo Summary
        00:16
      • 4.28 Table Style Options
        01:04
      • 4.29 Filter Tables
        00:41
      • 4.30 Business Scenario
        02:01
      • 4.31 Demo Summary
        00:23
      • 4.32 Sort Table Data
        01:20
      • 4.33 Business Scenario
        02:00
      • 4.34 Demo Summary
        00:22
      • 4.35 Quiz
      • 4.36 Summary
        01:08
      • 4.37 Thank You
        00:05
    • Lesson 05 - Apply Formulas and Functions

      56:50Preview
      • 5.1 Apply Formulas and Functions
        00:22
      • 5.2 Objectives
        00:27
      • 5.3 Formulas and Functions
        01:04
      • 5.4 Cell References and Ranges in Formulas
        01:53
      • 5.5 Cell References and Ranges in Formulas contd
        00:30
      • 5.6 Business Scenario
        01:53
      • 5.7 Demo Summary
        00:27
      • 5.8 Formula Calculations Order
        01:47
      • 5.9 SUM Function
        01:04
      • 5.10 Business Scenario
        01:04
      • 5.11 Demo Summary
        00:17
      • 5.12 COUNT Function
        00:51
      • 5.13 COUNTA Function
        00:46
      • 5.14 Business Scenario
        04:34
      • 5.15 Demo Summary
        00:17
      • 5.16 AVERAGE Function
        00:44
      • 5.17 MIN Function
        00:42
      • 5.18 MAX Function
        00:39
      • 5.19 Business Scenario
        02:08
      • 5.20 Demo Summary
        00:21
      • 5.21 Conditional Logic in Functions
        00:51
      • 5.22 SUMIF Function
        01:05
      • 5.23 SUMIFS Function
        01:35
      • 5.24 Business Scenario
        04:06
      • 5.25 Demo Summary
        00:22
      • 5.26 COUNTIF Function
        00:54
      • 5.27 COUNTIFS Function
        01:20
      • 5.28 Business Scenario
        03:00
      • 5.29 Demo Summary
        00:21
      • 5.30 AVERAGEIF Function
        01:06
      • 5.31 AVERAGEIFS Function
        01:37
      • 5.32 Business Scenario
        03:36
      • 5.33 Demo Summary
        00:21
      • 5.34 LOWER PROPER UPPER and CONCATENATE Functions
        01:31
      • 5.35 TRIM Function
        00:25
      • 5.36 Business Scenario
        04:23
      • 5.37 Demo Summary
        00:21
      • 5.38 LEFT Function
        01:02
      • 5.39 RIGHT Function
        01:01
      • 5.40 mid Function
        00:53
      • 5.41 Business Scenario
        03:37
      • 5.42 Demo Summary
        00:23
      • 5.43 Quiz
      • 5.44 Summary
        01:05
      • 5.45 Thank You
        00:05
    • Lesson 06 - Create Charts and Objects

      35:40Preview
      • 6.1 Create Charts and Objects
        00:22
      • 6.2 Objectives
        00:22
      • 6.3 Introduction to Charts
        02:14
      • 6.4 Create Charts
        00:35
      • 6.5 Create Charts contd
        00:28
      • 6.6 Create Charts contd
        00:33
      • 6.7 Business Scenario
        05:22
      • 6.8 Demo Summary
        00:19
      • 6.9 Format Charts
        00:51
      • 6.10 Format Charts contd
        00:39
      • 6.11 Business Scenario
        02:32
      • 6.12 Demo Summary
        00:16
      • 6.13 Move and Resize Charts
        00:32
      • 6.14 Business Scenario
        01:53
      • 6.15 Demo Summary
        00:16
      • 6.16 Recommended Charts
        00:40
      • 6.17 Business Scenario
        01:37
      • 6.18 Demo Summary
        00:17
      • 6.19 Introduction to Objects
        00:37
      • 6.20 Insert Picture Objects
        00:34
      • 6.21 Business Scenario
        01:50
      • 6.22 Demo Summary
        00:16
      • 6.23 Insert Other File Formats as Objects
        00:52
      • 6.24 Business Scenario
        02:47
      • 6.25 Demo Summary
        00:18
      • 6.26 Add Textboxes
        00:26
      • 6.27 Business Scenario
        02:29
      • 6.28 Demo Summary
        00:16
      • 6.29 Add SmartArt
        00:26
      • 6.30 Business Scenario
        03:13
      • 6.31 Demo Summary
        00:25
      • 6.32 Quiz
      • 6.33 Summary
        01:17
      • 6.34 Thank You
        00:06

Exam & Certification

  • How do I become a Microsoft Excel 2013 certified professional?

    For Microsoft Excel 2013 certification, you will have to take the Microsoft certification exam. To do this, you will need to register for the examination at the Microsoft official website. Once registered, you will need to sign in, select your exam and schedule it with Pearson VUE. No prerequisite skills are required for taking this course.

  • What do I need to do to unlock my certificate?

    Online self-learners need to complete 85% of the course to receive their certificate of participation from Simplilearn.

Reviews

  • Destiny Webb

    Destiny Webb

    Simplilearn’s course was extremely informative covering all the important and much needed topics to be career ready. Highly effective and recommendable.

  • Amy Tucker

    Amy Tucker

    This excellent course will transform you into an Excel expert. You will be the go-to person in your organization for anything related to Excel if you master the concepts in this course.

  • Rachel Washington

    Rachel Washington

    Simplilearn’s Excel Foundation is a great course with carefully planned and reviewed course material. I feel very confident after the course to showcase my Excel knowledge.

FAQs

  • How do I enroll for the Online training?

    You can enroll through our website and make an online payment using any of the following options:
    • Visa debit/credit card
    • American Express and Diners Club card
    • Mastercard
    • PayPal
    Once payment is processed, you will automatically receive a payment receipt and access information via email.
     

  • If I need to cancel my enrollment, can I get a refund?

    Yes, you can cancel your enrollment if necessary. We will refund the course price after deducting an administration fee. To learn more, please read our Refund Policy.

  • Do you provide any course completion certificate?

    Yes, we offer course completion certificate after you successfully complete the training program.

  • Where and how can I access the e-learning content? Are there any limitations?

    Once you register with us for a course by paying the course fee, you will have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

  • Do you provide a money back guarantee for the training programs?

    Yes. We do offer a money-back guarantee for many of our training programs. You can refer to our Refund Policy. Refund requests can be submitted via our Help and Support portal.

  • I’d like to learn more about this training program. Whom should I contact?

    Contact us using the form on the right of any page on the Simplilearn website or select the Live Chat link. Our customer service representatives can provide you with more details.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.