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 Welcome00:07
      • 0.2 Overview of MOS Foundation01:00
      • 0.3 Table of Content00:52
      • 0.4 Course Objective00:30
      • 0.5 Course Overview00:57
      • 0.6 Value of Excel for Professionals00:41
      • 0.7 Value of Excel for Organizations00:40
      • 0.8 Lessons Covered00:15
      • 0.9 Exam Pattern00:30
      • 0.10 MOS Excel 2013 Level 1 Certification01:31
      • 0.11 Sources of Information00:18
      • 0.12 Thank you00:09
    • Lesson 01 - Introduction to Excel 2013 13:12
      • 1.1 Introduction to Excel 201300:22
      • 1.2 Objectives00:29
      • 1.3 Excel 2013 Application User Interface01:05
      • 1.4 Excel 2013 Application User Interface contd00:31
      • 1.5 Excel 2013 Application Window00:27
      • 1.6 Excel 2013 Application Window Elements01:41
      • 1.7 Ribbon Options00:49
      • 1.8 Business Scenario01:29
      • 1.9 Demo Summary00:20
      • 1.10 Quick Access Toolbar00:30
      • 1.11 Customize Quick Access Toolbar00:22
      • 1.12 Business Scenario01:25
      • 1.13 Demo summary00:23
      • 1.14 Backstage View in Excel 201300:26
      • 1.15 New Features in Excel 201301:46
      • 1.16 Quiz
      • 1.17 Summary01:03
      • 1.18 Thank You00:04
    • Lesson 02 - Create and Manage Workbooks and Worksheets 1:13:10
      • 2.1 Create and Manage Workbooks and Worksheets00:22
      • 2.2 Objectives00:26
      • 2.3 Excel 2013 Workbooks01:11
      • 2.4 Create a Blank Workbook00:31
      • 2.5 Create a Workbook from a Template00:38
      • 2.6 Open an Existing Workbook00:25
      • 2.7 Business Scenario02:36
      • 2.8 Demo Summary00:19
      • 2.9 Native and Non native Files02:15
      • 2.10 Connect Import External Files02:06
      • 2.11 Connect Import External Files contd01:08
      • 2.12 Business Scenario03:08
      • 2.13 Demo summary00:33
      • 2.14 Worksheet Operations01:28
      • 2.15 Change Worksheet Tab Color00:32
      • 2.16 Hide or Unhide Worksheets00:28
      • 2.17 Business Scenario02:35
      • 2.18 Demo summary00:14
      • 2.19 Search and Replace Data00:28
      • 2.20 Go To and Name Box00:38
      • 2.21 Business Scenario02:30
      • 2.22 Demo summary00:23
      • 2.23 Insert Hyperlinks00:58
      • 2.24 Business Scenario01:14
      • 2.25 Demo summary00:19
      • 2.26 Modifying Workbook Themes00:49
      • 2.27 Modify Page Setup01:19
      • 2.28 Insert and Delete Columns and Rows01:00
      • 2.29 Modify Row Height and Column Width00:44
      • 2.30 Hide or Unhide Columns and Rows00:24
      • 2.31 Business Scenario03:38
      • 2.32 Demo summary00:44
      • 2.33 Insert Headers and Footers00:38
      • 2.34 Insert Headers and Footers contd00:33
      • 2.35 Business Scenario02:08
      • 2.36 Demo summary00:21
      • 2.37 Data Validation01:49
      • 2.38 Data Validation contd01:04
      • 2.39 Business Scenario04:01
      • 2.40 Demo summary00:25
      • 2.41 Enable Developer Tab00:37
      • 2.42 Macro Security Options01:36
      • 2.43 Record Macros01:38
      • 2.44 Business Scenario03:43
      • 2.45 Demo summary00:33
      • 2.46 Backward Compatibility01:32
      • 2.47 Workbook Views01:05
      • 2.48 Use Zoom for Workbooks00:43
      • 2.49 Freeze Panes01:04
      • 2.50 Split Window00:22
      • 2.51 Business Scenario02:23
      • 2.52 Demo summary00:19
      • 2.53 Show Formulas00:23
      • 2.54 Business Scenario01:47
      • 2.55 Demo summary00:12
      • 2.56 Add Values to Workbook Properties00:33
      • 2.57 Business Scenario01:07
      • 2.58 Demo summary00:14
      • 2.59 Save Workbooks in Alternate File Formats01:24
      • 2.60 Set Print Area and Print Workbooks00:46
      • 2.61 Business Scenario01:43
      • 2.62 Demo summary00:23
      • 2.63 Save Workbooks to Remote Locations00:50
      • 2.64 Quiz
      • 2.65 Summary01:05
      • 2.66 Thank You00:06
    • Lesson 03 - Create Cells and Ranges 44:46
      • 3.1 Create Cells and Ranges00:25
      • 3.2 Objectives00:27
      • 3.3 Cells and Ranges01:02
      • 3.4 Create Data using FillSeries01:16
      • 3.5 Business Scenario01:45
      • 3.6 Demo Summary00:16
      • 3.7 Create Data using AutoFill00:54
      • 3.8 Business Scenario02:28
      • 3.9 Demo Summary00:15
      • 3.10 Customize AutoFill Options00:44
      • 3.11 Business Scenario02:43
      • 3.12 Demo Summary00:19
      • 3.13 Paste Options00:43
      • 3.14 Paste Special02:09
      • 3.15 Format Cell Structure01:30
      • 3.16 Business Scenario02:12
      • 3.17 Demo Summary00:11
      • 3.18 Merge and Center01:17
      • 3.19 Business Scenario00:51
      • 3.20 Demo Summary00:11
      • 3.21 Format Cell Content01:14
      • 3.22 Business Scenario01:33
      • 3.23 Demo Summary00:15
      • 3.24 Cell Styles01:00
      • 3.25 Business Scenario01:53
      • 3.26 Demo Summary00:13
      • 3.27 Number Formats01:54
      • 3.28 Format Painter00:28
      • 3.29 Business Scenario01:21
      • 3.30 Demo Summary00:12
      • 3.31 Data Model with Advanced Conditional Format01:41
      • 3.32 Data Model with Advanced Conditional Format contd00:30
      • 3.33 Sparklines01:11
      • 3.34 Business Scenario01:34
      • 3.35 Demo Summary00:12
      • 3.36 Create Named Ranges01:08
      • 3.37 Business Scenario02:32
      • 3.38 Demo Summary00:14
      • 3.39 Data Group and Ungroup01:17
      • 3.40 Subtotals01:11
      • 3.41 Quiz
      • 3.42 Summary01:27
      • 3.43 Thank You00:08
    • Lesson 04 - Create Tables 29:54
      • 4.1 Create Tables00:22
      • 4.2 Objectives00:22
      • 4.3 Tables in Excel 201300:58
      • 4.4 Create and Format a Table00:34
      • 4.5 Business Scenario01:08
      • 4.6 Demo Summary00:19
      • 4.7 Define Table Names00:32
      • 4.8 Business Scenario01:34
      • 4.9 Demo Summary00:17
      • 4.10 Insert Table Rows and Columns00:46
      • 4.11 Business Scenario02:16
      • 4.12 Demo Summary00:17
      • 4.13 Delete Table Rows and Columns00:48
      • 4.14 Business Scenario01:27
      • 4.15 Demo Summary00:22
      • 4.16 Move Table Rows and Columns00:19
      • 4.17 Business Scenario02:10
      • 4.18 Demo Summary00:29
      • 4.19 Convert to Range00:22
      • 4.20 Business Scenario01:06
      • 4.21 Demo Summary00:21
      • 4.22 Remove Duplicates00:15
      • 4.23 Business Scenario01:42
      • 4.24 Demo Summary00:19
      • 4.25 Design Table Styles00:37
      • 4.26 Business Scenario00:52
      • 4.27 Demo Summary00:16
      • 4.28 Table Style Options01:04
      • 4.29 Filter Tables00:41
      • 4.30 Business Scenario02:01
      • 4.31 Demo Summary00:23
      • 4.32 Sort Table Data01:20
      • 4.33 Business Scenario02:00
      • 4.34 Demo Summary00:22
      • 4.35 Quiz
      • 4.36 Summary01:08
      • 4.37 Thank You00:05
    • Lesson 05 - Apply Formulas and Functions 56:50
      • 5.1 Apply Formulas and Functions00:22
      • 5.2 Objectives00:27
      • 5.3 Formulas and Functions01:04
      • 5.4 Cell References and Ranges in Formulas01:53
      • 5.5 Cell References and Ranges in Formulas contd00:30
      • 5.6 Business Scenario01:53
      • 5.7 Demo Summary00:27
      • 5.8 Formula Calculations Order01:47
      • 5.9 SUM Function01:04
      • 5.10 Business Scenario01:04
      • 5.11 Demo Summary00:17
      • 5.12 COUNT Function00:51
      • 5.13 COUNTA Function00:46
      • 5.14 Business Scenario04:34
      • 5.15 Demo Summary00:17
      • 5.16 AVERAGE Function00:44
      • 5.17 MIN Function00:42
      • 5.18 MAX Function00:39
      • 5.19 Business Scenario02:08
      • 5.20 Demo Summary00:21
      • 5.21 Conditional Logic in Functions00:51
      • 5.22 SUMIF Function01:05
      • 5.23 SUMIFS Function01:35
      • 5.24 Business Scenario04:06
      • 5.25 Demo Summary00:22
      • 5.26 COUNTIF Function00:54
      • 5.27 COUNTIFS Function01:20
      • 5.28 Business Scenario03:00
      • 5.29 Demo Summary00:21
      • 5.30 AVERAGEIF Function01:06
      • 5.31 AVERAGEIFS Function01:37
      • 5.32 Business Scenario03:36
      • 5.33 Demo Summary00:21
      • 5.34 LOWER PROPER UPPER and CONCATENATE Functions01:31
      • 5.35 TRIM Function00:25
      • 5.36 Business Scenario04:23
      • 5.37 Demo Summary00:21
      • 5.38 LEFT Function01:02
      • 5.39 RIGHT Function01:01
      • 5.40 mid Function00:53
      • 5.41 Business Scenario03:37
      • 5.42 Demo Summary00:23
      • 5.43 Quiz
      • 5.44 Summary01:05
      • 5.45 Thank You00:05
    • Lesson 06 - Create Charts and Objects 35:40
      • 6.1 Create Charts and Objects00:22
      • 6.2 Objectives00:22
      • 6.3 Introduction to Charts02:14
      • 6.4 Create Charts00:35
      • 6.5 Create Charts contd00:28
      • 6.6 Create Charts contd00:33
      • 6.7 Business Scenario05:22
      • 6.8 Demo Summary00:19
      • 6.9 Format Charts00:51
      • 6.10 Format Charts contd00:39
      • 6.11 Business Scenario02:32
      • 6.12 Demo Summary00:16
      • 6.13 Move and Resize Charts00:32
      • 6.14 Business Scenario01:53
      • 6.15 Demo Summary00:16
      • 6.16 Recommended Charts00:40
      • 6.17 Business Scenario01:37
      • 6.18 Demo Summary00:17
      • 6.19 Introduction to Objects00:37
      • 6.20 Insert Picture Objects00:34
      • 6.21 Business Scenario01:50
      • 6.22 Demo Summary00:16
      • 6.23 Insert Other File Formats as Objects00:52
      • 6.24 Business Scenario02:47
      • 6.25 Demo Summary00:18
      • 6.26 Add Textboxes00:26
      • 6.27 Business Scenario02:29
      • 6.28 Demo Summary00:16
      • 6.29 Add SmartArt00:26
      • 6.30 Business Scenario03:13
      • 6.31 Demo Summary00:25
      • 6.32 Quiz
      • 6.33 Summary01:17
      • 6.34 Thank You00: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.

    • What does it mean to be GSA approved course?

      The course is part of Simplilearn’s contract with GSA (only US) with special pricing for GSA approved agencies & organizations. To know more click here

    • How do i know if I am eligible to buy this course at GSA price?

      You should be employed with GSA approved agencies & organizations. The list of approved agencies is provided here

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