For individuals

Self paced learning

  • 180 days access to high quality self-paced learning content designed by industry experts
USD 149
For business

Flexible learning solutions for your team

  • Course advisors your team will want to train from
  • Training tailored to your needs
  • Outcome centric solutions that deliver on your business goals

Key features

MONEY BACK GUARANTEE

How this works :

At Simplilearn, we greatly value the trust of our patrons. Our courses were designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Self Placed Learning :

Raise refund request within 7 days of purchase of course. Money back guarantee is void if the participant has accessed more than 25% content.

  • 6+ Hrs of High Quality e-Learning content
  • 53 demo's with example on application
  • 1 Microsoft Excel Simulation Exam
  • 6 Chapter End Quizzes
  • Prepare for MOS Excel 2013 Core (77-420) Exam
  • Downloadable E-book Included

Course description

  • What is this course about?

    Excel is a powerful spreadsheet application created by Microsoft which helps you to understand and analyze business functions. This application is mainly useful for business heads for taking decisions about their business.  Microsoft introduced a number of new features in Excel 2013, such as saving files in remote locations, new chart types, slicers and timeline feature to work with pivot tables, FlashFill, etc. All these features allow the user to work with data more efficiently and effectively.

    This course will provide you a comprehensive introduction to the basics of Excel 2013 application and customizing excel options. It will give an introduction to creating and managing worksheets and workbooks. We will learn about creating and formatting cells and ranges. The course will also cover the information about creating and formatting tables, applying formulas and functions, creating charts, and inserting objects.

    Demos are provided to show how to work with Excel application and get hands-on experience in Excel 2013. The target audience of the course is anyone who is interested in learning Excel 2013. No prerequisite skills are required for taking this course.

  • Why is the certification most sought-after?

    Microsoft Excel 2013: MOS Foundation certification proves that the certified professional can work with Excel 2013 application efficiently. This certification also proves the certified professional’s skills in Excel 2013.

    Currently, there are approximately 37,500 lT professionals across the globe who hold a Microsoft Certified Solutions Associate (MCSA) certification.

    Professionals can benefit from Excel in different ways. In Excel 2013, professionals can use the new FlashFill feature to easily work with data. They can create interactive charts with filters using new chart elements and chart types. 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 works in its own window.

    Organizations have several benefits of working with Excel. Excel 2013 has powerful premade templates to create workbooks easily and different types of quick analysis tools, which help organizations to take decisions about their businesses. In addition, it has an option to save files in remote locations, which helps in accessing online files from anywhere. Using the Excel application, organizations can store huge data and automate various tasks.

  • What learning benefits do you get from Simplilearn’s training?

    Excel is a powerful spreadsheet application created by Microsoft that helps you to understand and analyze business functions.  

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

  • What are the career benefits in-store for you?

    This course provides the participants with the following career benefits:
    • According to payscale.com, in high-growth industries, entry-level employees who hold a Microsoft Certified Solutions Associate (MCSA) certification or Microsoft Office Specialist (MOS) certification can earn up to $16,000 more, annually, than their peers.
    • It helps professionals in their career by maximizing the value of their data, helping to control costs more effectively, and obtaining business information.
    • This course and certification will increase your visibility in your organization.
    • This certification sets you apart from your colleagues and ensures you get recognized for your knowledge and skill.

  • Who should do this course?

    Microsoft® Excel 2013 Foundation certification enables the professionals’ to gain proficiency in handling advanced formulas and tools. This certification training helps the users to enhance their skills in function with calculation, graphic tools, pivot tools, converting lists to a table and more. It is ideal for those who are looking to improve their job prospects by adopting Excel 2013 advanced skills and knowledge.

  • Why choose Simplilearn for your training?

    • Simplilearn is the World’s Largest Certification Training Provider, with over 500,000+ professionals trained globally
    • Trusted by the Fortune 500 companies as their learning provider for career growth and training
    • 2000+ certified and experienced trainers conduct trainings for various courses across the globe
    • All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt
    • Accredited, Approved and Recognized as a training organization, partner, education provider and examination center by globally renowned names like Project Management Institute of USA, APMG, CFA Institute, GARP, ASTQB, IIBA and others

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 00:00
      • 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 00:00
      • 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 00:00
      • 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 00:00
      • 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 00:00
      • 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 00:00
      • 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 you become a Microsoft Excel 2013 certified professional?

      The target audience of the course is anyone who is interested in learning Excel 2013. No prerequisite skills are required for taking this course.

      For Microsoft Excel 2013 certification, you will have to appear for the Microsoft certification exam. To do this, you will need to register for the examination. You will need to register at the Microsoft official website. Once registered, you will need to sign in, select your exam and schedule it with Pearson VUE.

    Reviews

    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

    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

    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 for this Online training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.

      1. Visa debit/credit card
      2. American express and Diners club card
      3. Master Card, or
      4. Through PayPal

    • What will I get along with this training?

      You will have access to the online e-learning and practice tests along with the training.

    • Can I cancel my enrollment? Do I get a refund?

      Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through 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 can 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.

    • I am not able to access the online course. Whom should I contact for a solution?

      Please raise a request via our Help and Support portal to have your issue resolved.

    • Do you provide 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 the Refund Policy and raise refund requests via our Help and Support portal.

    • Do you provide any course completion certificate?

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

    • I want to know more about the training program. Whom do I contact?

      Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

    Contact Us

    +1-844-532-7688

    (Toll Free)

    • Disclaimer
    • PMI, PMBOK, PMP, PgMP, CAPM, PMI-RMP, and PMI-ACP are registered marks of the Project Management Institute, Inc
    • ITIL® is a [registered] trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
    • IT Infrastructure Library is a [registered] trade mark of AXELOS Limited used, under permission of AXELOS Limited. All rights reserved.
    • The Swirl logo™ is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
    • PRINCE2® is a [registered] trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
    • MSP® is a [registered] trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
    • Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
    • Professional Scrum Master is a registered trademark of Scrum.org
    • The APMG-International Finance for Non-Financial Managers and Swirl Device logo is a trade mark of The APM Group Limited.
    • The Open Group®, TOGAF® are trademarks of The Open Group.
    • IIBA®, the IIBA® logo, BABOK® and Business Analysis Body of Knowledge® are registered trademarks owned by International Institute of Business Analysis.
    • CBAP® is a registered certification mark owned by International Institute of Business Analysis. Certified Business Analysis Professional, EEP and the EEP logo are trademarks owned by International Institute of Business Analysis.
    • COBIT® is a trademark of ISACA® registered in the United States and other countries.
    • CISA® is a Registered Trade Mark of the Information Systems Audit and Control Association (ISACA) and the IT Governance Institute.
    • CISSP® is a registered mark of The International Information Systems Security Certification Consortium ((ISC)2).
    • CISCO®, CCNA®, and CCNP® are trademarks of Cisco and registered trademarks in the United States and certain other countries.
    • Simplilearn and its affiliates, predecessors, successors and assigns are in no way associated, sponsored or promoted by SAP SE and neither do they provide any SAP based online or real-time courses or trainings
    /index/hidden/ - Never remove this line