Country

Watch Introduction Video

Classroom Training in Ashburn Change city

Sorry, we do not have any classroom workshops in Ashburn at the moment. Please leave your details and we will get back to you with the feasibility of conducting a workshop

Drop us your details and we will get back to you

{{queryStatusMsg}}
Name *
Email *
Message *
I agree to be contacted over email
 

Online self learning

3 DAYS MONEY BACK GUARANTEE

How this works:

For refund, write to support@simplilearn.com within 3 days of purchase

The mode of reimbursement will be same as the mode of payment used during enrollment fees. For example: If a participant has paid through credit cards, we will reimburse through credit card

Note: Money back guarantee is void if the participant has accessed more than 50% of the course content.


Start Anytime! Anywhere in the world
Access days:
30 Days 180 Days
$69

$99

 

Key Features

  • 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
  • Scenario and casestudies included
  • Assist in Scheduling your Exam with Certiport Test Center
  • Course Completion Certificate
  • 20 PDUs Offered
  • 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
  • Scenario and casestudies included
  • Assist in Scheduling your Exam with Certiport Test Center
  • Course Completion Certificate
  • 20 PDUs Offered
Specials Offer(s) Available

Flat 30% Off on All Online courses + details Flat 30% Off on All Online courses
Use Coupon: OSL30 valid till 7th Aug
Use Coupon:OSL30

About Course

Course Preview

    • Lesson 00 - Overview of MOS Foundation 8:30
      • 0.1 Welcome 1:7
      • 0.2 Overview of MOS Foundation 1:0
      • 0.3 Table of Content 1:52
      • 0.4 Course Objective 1:30
      • 0.5 Course Overview 1:57
      • 0.6 Value of Excel for Professionals 1:41
      • 0.7 Value of Excel for Organizations 1:40
      • 0.8 Lessons Covered 1:15
      • 0.9 Exam Pattern 1:30
      • 0.10 MOS Excel 2013 Level 1 Certification 2:31
      • 0.11 Sources of Information 1:18
      • 0.12 Thank you 1:9
    • Lesson 01 - Introduction to Excel 2013 11:18
      • 1.1 Introduction to Excel 2013 1:22
      • 1.2 Objectives 1:29
      • 1.3 Excel 2013 Application User Interface 2:5
      • 1.4 Excel 2013 Application User Interface contd 1:31
      • 1.5 Excel 2013 Application Window 1:27
      • 1.6 Excel 2013 Application Window Elements 2:41
      • 1.7 Ribbon Options 1:49
      • 1.8 Business Scenario 0:0
      • 1.9 Demo Summary 1:20
      • 1.10 Quick Access Toolbar 1:30
      • 1.11 Customize Quick Access Toolbar 1:22
      • 1.12 Business Scenario 0:0
      • 1.13 Demo summary 1:23
      • 1.14 Backstage View in Excel 2013 1:26
      • 1.15 New Features in Excel 2013 2:46
      • 1.16 Quiz 0:0
      • 1.17 Summary 2:3
      • 1.18 Thank You 1:4
    • Lesson 02 - Create and Manage Workbooks and Worksheets 42:1
      • 2.1 Create and Manage Workbooks and Worksheets 1:22
      • 2.2 Objectives 1:26
      • 2.3 Excel 2013 Workbooks 2:11
      • 2.4 Create a Blank Workbook 1:31
      • 2.5 Create a Workbook from a Template 1:38
      • 2.6 Open an Existing Workbook 1:25
      • 2.7 Business Scenario 0:0
      • 2.8 Demo Summary 1:19
      • 2.9 Native and Non native Files 3:15
      • 2.10 Connect Import External Files 3:6
      • 2.11 Connect Import External Files contd 2:8
      • 2.12 Business Scenario 0:0
      • 2.13 Demo summary 1:33
      • 2.14 Worksheet Operations 2:28
      • 2.15 Change Worksheet Tab Color 1:32
      • 2.16 Hide or Unhide Worksheets 1:28
      • 2.17 Business Scenario 0:0
      • 2.18 Demo summary 1:14
      • 2.19 Search and Replace Data 1:28
      • 2.20 Go To and Name Box 1:38
      • 2.21 Business Scenario 0:0
      • 2.22 Demo summary 1:23
      • 2.23 Insert Hyperlinks 1:58
      • 2.24 Business Scenario 0:0
      • 2.25 Demo summary 1:19
      • 2.26 Modifying Workbook Themes 1:49
      • 2.27 Modify Page Setup 2:19
      • 2.28 Insert and Delete Columns and Rows 1:0
      • 2.29 Modify Row Height and Column Width 1:44
      • 2.30 Hide or Unhide Columns and Rows 1:24
      • 2.31 Business Scenario 0:0
      • 2.32 Demo summary 1:44
      • 2.33 Insert Headers and Footers 1:38
      • 2.34 Insert Headers and Footers contd 1:33
      • 2.35 Business Scenario 0:0
      • 2.36 Demo summary 1:21
      • 2.37 Data Validation 2:49
      • 2.38 Data Validation contd 2:4
      • 2.39 Business Scenario 0:0
      • 2.40 Demo summary 1:25
      • 2.41 Enable Developer Tab 1:37
      • 2.42 Macro Security Options 2:36
      • 2.43 Record Macros 2:38
      • 2.44 Business Scenario 0:0
      • 2.45 Demo summary 1:33
      • 2.46 Backward Compatibility 2:32
      • 2.47 Workbook Views 2:5
      • 2.48 Use Zoom for Workbooks 1:43
      • 2.49 Freeze Panes 2:4
      • 2.50 Split Window 1:22
      • 2.51 Business Scenario 0:0
      • 2.52 Demo summary 1:19
      • 2.53 Show Formulas 1:23
      • 2.54 Business Scenario 0:0
      • 2.55 Demo summary 1:12
      • 2.56 Add Values to Workbook Properties 1:33
      • 2.57 Business Scenario 0:0
      • 2.58 Demo summary 1:14
      • 2.59 Save Workbooks in Alternate File Formats 2:24
      • 2.60 Set Print Area and Print Workbooks 1:46
      • 2.61 Business Scenario 1:24
      • 2.62 Demo summary 1:23
      • 2.63 Save Workbooks to Remote Locations 1:50
      • 2.64 Quiz 0:0
      • 2.65 Summary 2:5
      • 2.66 Thank You 1:6
    • Lesson 03 - Create Cells and Ranges 26:54
      • 3.1 Create Cells and Ranges 1:25
      • 3.2 Objectives 1:27
      • 3.3 Cells and Ranges 2:2
      • 3.4 Create Data using FillSeries 2:16
      • 3.5 Business Scenario 0:0
      • 3.6 Demo Summary 1:16
      • 3.7 Create Data using AutoFill 1:54
      • 3.8 Business Scenario 0:0
      • 3.9 Demo Summary 1:15
      • 3.10 Customize AutoFill Options 1:44
      • 3.11 Business Scenario 0:0
      • 3.12 Demo Summary 1:19
      • 3.13 Paste Options 1:43
      • 3.14 Paste Special 3:9
      • 3.15 Format Cell Structure 2:30
      • 3.16 Business Scenario 0:0
      • 3.17 Demo Summary 1:11
      • 3.18 Merge and Center 2:17
      • 3.19 Business Scenario 0:0
      • 3.20 Demo Summary 1:11
      • 3.21 Format Cell Content 2:14
      • 3.22 Business Scenario 0:0
      • 3.23 Demo Summary 1:15
      • 3.24 Cell Styles 1:0
      • 3.25 Business Scenario 0:0
      • 3.26 Demo Summary 1:13
      • 3.27 Number Formats 2:54
      • 3.28 Format Painter 1:28
      • 3.29 Business Scenario 0:0
      • 3.30 Demo Summary 1:12
      • 3.31 Data Model with Advanced Conditional Format 2:41
      • 3.32 Data Model with Advanced Conditional Format contd 1:30
      • 3.33 Sparklines 2:11
      • 3.34 Business Scenario 0:0
      • 3.35 Demo Summary 1:12
      • 3.36 Create Named Ranges 2:8
      • 3.37 Business Scenario 0:0
      • 3.38 Demo Summary 1:14
      • 3.39 Data Group and Ungroup 2:17
      • 3.40 Subtotals 2:11
      • 3.41 Quiz 0:0
      • 3.42 Summary 2:27
      • 3.43 Thank You 1:8
    • Lesson 04 - Create Tables 14:38
      • 4.1 Create Tables 1:22
      • 4.2 Objectives 1:22
      • 4.3 Tables in Excel 2013 1:58
      • 4.4 Create and Format a Table 1:34
      • 4.5 Business Scenario 0:0
      • 4.6 Demo Summary 1:19
      • 4.7 Define Table Names 1:32
      • 4.8 Business Scenario 0:0
      • 4.9 Demo Summary 1:17
      • 4.10 Insert Table Rows and Columns 1:46
      • 4.11 Business Scenario 0:0
      • 4.12 Demo Summary 1:17
      • 4.13 Delete Table Rows and Columns 1:48
      • 4.14 Business Scenario 0:0
      • 4.15 Demo Summary 1:22
      • 4.16 Move Table Rows and Columns 1:19
      • 4.17 Business Scenario 0:0
      • 4.18 Demo Summary 1:29
      • 4.19 Convert to Range 1:22
      • 4.20 Business Scenario 0:0
      • 4.21 Demo Summary 1:21
      • 4.22 Remove Duplicates 1:15
      • 4.23 Business Scenario 0:0
      • 4.24 Demo Summary 1:19
      • 4.25 Design Table Styles 1:37
      • 4.26 Business Scenario 0:0
      • 4.27 Demo Summary 1:16
      • 4.28 Table Style Options 2:4
      • 4.29 Filter Tables 1:41
      • 4.30 Business Scenario 0:0
      • 4.31 Demo Summary 1:23
      • 4.32 Sort Table Data 2:20
      • 4.33 Business Scenario 0:0
      • 4.34 Demo Summary 1:22
      • 4.35 Quiz 0:0
      • 4.36 Summary 2:8
      • 4.37 Thank You 1:5
    • Lesson 05 - Apply Formulas and Functions 29:29
      • 5.1 Apply Formulas and Functions 1:22
      • 5.2 Objectives 1:27
      • 5.3 Formulas and Functions 2:4
      • 5.4 Cell References and Ranges in Formulas 2:53
      • 5.5 Cell References and Ranges in Formulas contd 1:30
      • 5.6 Business Scenario 0:0
      • 5.7 Demo Summary 1:27
      • 5.8 Formula Calculations Order 2:47
      • 5.9 SUM Function 2:4
      • 5.10 Business Scenario 0:0
      • 5.11 Demo Summary 1:17
      • 5.12 COUNT Function 1:51
      • 5.13 COUNTA Function 1:46
      • 5.14 Business Scenario 0:0
      • 5.15 Demo Summary 1:17
      • 5.16 AVERAGE Function 1:44
      • 5.17 MIN Function 1:42
      • 5.18 MAX Function 1:39
      • 5.19 Business Scenario 0:0
      • 5.20 Demo Summary 1:21
      • 5.21 Conditional Logic in Functions 1:51
      • 5.22 SUMIF Function 2:5
      • 5.23 SUMIFS Function 2:35
      • 5.24 Business Scenario 0:0
      • 5.25 Demo Summary 1:22
      • 5.26 COUNTIF Function 1:54
      • 5.27 COUNTIFS Function 2:20
      • 5.28 Business Scenario 0:0
      • 5.29 Demo Summary 1:21
      • 5.30 AVERAGEIF Function 2:6
      • 5.31 AVERAGEIFS Function 2:37
      • 5.32 Business Scenario 0:0
      • 5.33 Demo Summary 1:21
      • 5.34 LOWER PROPER UPPER and CONCATENATE Functions 2:31
      • 5.35 TRIM Function 1:25
      • 5.36 Business Scenario 0:0
      • 5.37 Demo Summary 1:21
      • 5.38 LEFT Function 2:2
      • 5.39 RIGHT Function 2:1
      • 5.40 mid Function 1:53
      • 5.41 Business Scenario 0:0
      • 5.42 Demo Summary 1:23
      • 5.43 Quiz 0:0
      • 5.44 Summary 2:5
      • 5.45 Thank You 1:5
    • Lesson 06 - Create Charts and Objects 14:58
      • 6.1 Create Charts and Objects 1:22
      • 6.2 Objectives 1:22
      • 6.3 Introduction to Charts 3:14
      • 6.4 Create Charts 1:35
      • 6.5 Create Charts contd 1:28
      • 6.6 Create Charts contd 1:33
      • 6.7 Business Scenario 0:0
      • 6.8 Demo Summary 1:19
      • 6.9 Format Charts 1:51
      • 6.10 Format Charts contd 1:39
      • 6.11 Business Scenario 0:0
      • 6.12 Demo Summary 1:16
      • 6.13 Move and Resize Charts 1:32
      • 6.14 Business Scenario 0:0
      • 6.15 Demo Summary 1:16
      • 6.16 Recommended Charts 1:40
      • 6.17 Business Scenario 0:0
      • 6.18 Demo Summary 1:17
      • 6.19 Recommended Charts 1:38
      • 6.20 Insert Picture Objects 1:34
      • 6.21 Business Scenario 0:0
      • 6.22 Demo Summary 1:16
      • 6.23 Insert Other File Formats as Objects 1:52
      • 6.24 Business Scenario 0:0
      • 6.25 Demo Summary 1:18
      • 6.26 Add Textboxes 1:26
      • 6.27 Business Scenario 0:0
      • 6.28 Demo Summary 1:16
      • 6.29 Add SmartArt 1:26
      • 6.30 Business Scenario 0:0
      • 6.31 Demo Summary 1:25
      • 6.32 Quiz 0:0
      • 6.33 Summary 2:17
      • 6.34 Thank You 1:6
    • {{childObj.title}}
      • {{lesson.title}}

    View More

    View Less

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

    1. Simplilearn is the World’s Largest Certification Training Provider, with over 400,000+ professionals trained globally
    2. Trusted by the Fortune 500 companies as their learning provider for career growth and training
    3. 2000+ certified and experienced trainers conduct trainings for various courses across the globe
    4. 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
    5. 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

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.

FAQs

  • What is the code of this certification exam?

    The certification code for MOS Excel 2013 is 77-420.

  • What is the duration of the exam?

    The duration of the exam will be 50 minutes and the total number of scenarios will be 4 to 6.

  • What are the focus areas of this exam?

    Features of Excel 2013 will be the focus area for this certification exam.

  • Are there any prerequisite certificates to be obtained before applying for the course?

    There are no prerequisite certificates to be obtained for this course.

  • Is there any exam pass-rate guarantee provided by Simplilearn?

    Simplilearn assures learners 100% guarantee of passing the exam and also offers money back guarantee provided certain conditions are met.

  • How does Simplilearn assure that the material and the training delivered are effective?

    Simplilearn follows a Global Learning Framework which has been proven to deliver results and has been perfected by their experience in training about a million learners.

  • Will I get a course completion certificate?

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

  • Is exam fee included in the course fee?

    Exam fee is not included in the course fee and the user will have to pay an exam fee to appear for the exam.

  • 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 send an email to support@simplilearn.com. You can also chat with us to get an instant solution.

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

    Yes, we do provide money back guarantee for some of our training programs. You can contact support@simplilearn.com for more information.

  • Do you provide any course completion certificate?

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

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
Drop us a Query
Name *
Email *
Your Query *
Looking for a training for
Myself My team/organization
I agree to be contacted over email
1800-232-5454(9am-7pm)
We are looking into your query.
Our consultants will get in touch with you soon.
 
Group Buy

corporatesales@simplilearn.com

Knowledge Bank

Request for a custom quote

Please fill in the details and our inhouse support team will get back to you within 1 business day

Name*

Email*

Phone*

Course
Company
Looking for*
Online license
training
Onsite
training
Online Virtual
training
Please select one of the above
Your Query
I agree to be contacted over mail
Please accept to proceed
/index/hidden/ - Never remove this line
  • Query