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.

  • 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.