Course Description

  • What are the course objectives?

    This Excel for beginners course will help you build expertise with Excel, the powerful spreadsheet application created by Microsoft commonly used to analyze business functions and make more informed decisions for you organization. Microsoft introduced a number of new features in Excel 2013, including remote file saving, new chart types, slicers and a timeline feature to work with pivot tables and FlashFill. All these features allow the user to work with data more efficiently and effectively. Demos are provided to show you how to work with Excel applications and to give you hands-on experience with Excel 2013.

    Professionals can benefit from Excel in different ways. In Excel 2013 the new FlashFill feature allows users to easily work with data. They can create interactive charts with filters using new chart elements and chart types. Excel 2013’s powerful pre-made templates allow users to create workbooks with ease. In addition, they can change data to a table with different in-built table styles and use new formulas and functions for easy calculations. They can work with dual monitors as each workbook functions in its own window.

    In addition, Excel 2013 has an option to save files in remote locations, which allows users to access online files from anywhere. Using the Excel application, organizations can store large amounts of data and automate various tasks.

    Microsoft Excel 2013: MOS Foundation certification demonstrates your proficiency with Excel 2013. Currently, there are approximately 37,500 lT professionals across the globe who hold a Microsoft Certified Solutions Associate (MCSA) certification.

  • What skills will you learn?

    Simplilearn’s Microsoft Excel 2013 Foundation Online Training teaches users to perform the following tasks:
    • Create and manage worksheets and workbooks
    • Create cells and ranges
    • Create tables
    • Apply formulas and functions
    • Create charts and objects

  • What are the career benefits in store for you?

    According to payscale.com, entry-level employees in high-growth industries who hold a Microsoft Certified Solutions Associate (MCSA) certification or Microsoft Office Specialist (MOS) certification can earn up to $16,000 a year more than their peers. This excel beginner training can give your career a boost by showing you how to maximize the value of your data, control costs more effectively and analyze business information. This Beginner Certification will increase your visibility in your organization by setting you apart from your colleagues and ensuring that you get recognized for your knowledge and skill.

  • Who should take this course?

    It is ideal for those who are looking to improve their job prospects by mastering Excel 2013.

Course Preview

    • Lesson 00 - Overview of MOS Foundation

      07:30
      • 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:12
      • 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

      1:13:10
      • 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
        01:47
      • 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:46
      • 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:54
      • 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:50
      • 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:40
      • 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
    • {{childObj.title}}

      • {{childObj.childSection.chapter_name}}

        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

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.

Read more Read less
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.

Read more Read less
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.

Read more Read less

      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.