Course Overview

Training Options

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Course Content

  • Microsoft® Excel® 2013 Intermediate: MOS Certification

    Preview
    • Lesson 00 - Overview Of MOS Intermediate Course

      07:18Preview
      • 0.1 Welcome
        00:08
      • 0.2 Overview Of MOS Intermediate Course
        00:44
      • 0.3 Table Of Content
        00:53
      • 0.4 Course Objectives
        00:27
      • 0.5 Course Overview
        00:55
      • 0.6 Value Of Excel For Professionals
        00:38
      • 0.7 Value Of Excel For Organizations
        00:50
      • 0.8 Lessons Covered
        00:15
      • 0.9 Exam Pattern
        00:29
      • 0.10 Microsoft Excel 2013 Mos Intermediate Certification
        01:29
      • 0.11 Sources Of Information
        00:19
      • 0.12 Thank You
        00:11
    • Lesson 01 - Manage And Share Workbooks In Ms Excel 2013

      18:17Preview
      • 1.1 Manage And Share Workbooks In Ms Excel 2013
        00:22
      • 1.2 Objectives
        00:21
      • 1.3 Share Workbooks
        00:59
      • 1.4 Shareworkbooks (Contd.)
        00:42
      • 1.5 Business Scenario
        00:58
      • 1.6 Demo Summary
        00:11
      • 1.7 Track Changes
        02:06
      • 1.8 Highlight Changes And Comments
        01:13
      • 1.9 Business Scenario
        02:16
      • 1.10 Demo Summary
        00:23
      • 1.11 Accept And Reject Changes
        01:01
      • 1.12 Business Scenario
        02:38
      • 1.13 Demo Summary
        00:16
      • 1.14 Formula Errors
        01:21
      • 1.15 Error Tracing
        00:55
      • 1.16 Business Scenario
        01:09
      • 1.17 Demo Summary
        00:16
      • 1.18 Quiz
      • 1.19 Summary
        00:59
      • 1.20 Thank You
        00:11
    • Lesson 02 - Apply Custom Formats and Layouts

      43:17Preview
      • 2.1 Apply Custom formats and layouts
        00:28
      • 2.2 Objectives
        00:28
      • 2.3 Create Custom Conditional formats
        00:56
      • 2.4 Conditional Formatting Rule Types
        01:32
      • 2.5 Business Scenario
        01:48
      • 2.6 Demo Summary
        00:14
      • 2.7 Formatting cells Using Formulas
        00:35
      • 2.8 Formatting Celis Using Formulas (contd.)
        00:31
      • 2.9 Business Scenario
        03:37
      • 2.10 Demo Summary
        00:20
      • 2.11 Manage Conditional Format Rules
        01:13
      • 2.12 Manage conditional format Rules (contd.)
        00:48
      • 2.13 Business Scenario
        04:08
      • 2.14 Demo Summary
        00:21
      • 2.15 Create Advance Filters by Search
        00:39
      • 2.16 Business Scenario
        02:12
      • 2.17 Demo Summary
        00:19
      • 2.18 Create Advance Filters Using Values
        00:18
      • 2.19 Business Scenario
        02:57
      • 2.20 Demo Summary
        00:24
      • 2.21 Create Advance Filters by Colors
        00:23
      • 2.22 Business Scenario
        01:04
      • 2.23 Demo Summary
        00:17
      • 2.24 Modify Worksheets with Accessibility Tools
        01:08
      • 2.25 Modify Worksheets with Accessibility Tools (Contd.)
        01:09
      • 2.26 Business Scenario
        00:57
      • 2.27 Demo Summary
        00:09
      • 2.28 Display Data in Multiple international Formats
        01:00
      • 2.29 Business Scenario
        01:14
      • 2.30 Demo Summary
        00:19
      • 2.31 Proofing in other languages
        00:50
      • 2.32 Proofing in Other languages (Contd.)
        00:38
      • 2.33 Business Scenario
        02:18
      • 2.34 Demo Summary
        00:19
      • 2.35 Use international symbols
        00:50
      • 2.36 Use international Symbols (contd.)
        00:28
      • 2.37 Business Scenario
        01:05
      • 2.38 Demo Summary
        00:17
      • 2.39 Manage body and heading fonts
        00:48
      • 2.40 Manage body and Heading fonts (contd.)
        00:24
      • 2.41 Business Scenario
        02:12
      • 2.42 Demo Summary
        00:20
      • 2.43 Quiz
      • 2.44 Summary
        01:09
      • 2.45 Thank You
        00:11
    • Lesson 03 - Create Advanced Formulas in Excel 2013

      59:23Preview
      • 3.1 Create Advanced Formulas in Excel 2013
        00:22
      • 3.2 Objectives
        00:20
      • 3.3 LOOKUP Functions
        00:48
      • 3.4 VLOOKUP Function
        00:56
      • 3.5 Syntax Arguments in VLOOKUP Function
        02:28
      • 3.6 Business Scenario
        03:05
      • 3.7 Demo Summary
        00:10
      • 3.8 HLOOKUP Function
        00:46
      • 3.9 Syntax Arguments in HLOOKUP Function
        02:11
      • 3.10 Business Scenario
        02:58
      • 3.11 Demo Summary
        00:10
      • 3.12 LOOKUP Function
        01:03
      • 3.13 Syntax Arguments in LOOKUP Function
        02:06
      • 3.14 Business Scenario
        02:37
      • 3.15 Demo Summary
        00:11
      • 3.16 TRANSPOSE Function
        00:58
      • 3.17 Business Scenario
        01:58
      • 3.18 Demo Summary
        00:10
      • 3.19 TODAY and NOW Functions
        00:41
      • 3.20 Business Scenario
        01:34
      • 3.21 Demo Summary
        00:11
      • 3.22 DAY MONTH and YEAR Functions
        01:00
      • 3.23 Business Scenario
        02:58
      • 3.24 Demo Summary
        00:12
      • 3.25 HOUR MINUTE and SECOND Functions
        01:18
      • 3.26 Business Scenario
        03:08
      • 3.27 Demo Summary
        00:10
      • 3.28 DATEVALUE and TIMEVALUE Functions
        00:50
      • 3.29 Business Scenario
        02:15
      • 3.30 Demo Summary
        00:13
      • 3.31 CONCATENATE Function
        00:56
      • 3.32 WEEKDAY and WEEKNUM Functions
        00:46
      • 3.33 Syntax Arguments in WEEKDAY and WEEKNUM Function
        01:09
      • 3.34 Business Scenario
        03:42
      • 3.35 Demo Summary
        00:14
      • 3.36 WORKDAY and WORKDAY INTL Functions
        02:11
      • 3.37 Business Scenario
        04:23
      • 3.38 Demo Summary
        00:16
      • 3.39 NETWORKDAYS and NETWORKDAYS INTL Functions
        01:51
      • 3.40 Business Scenario
        04:32
      • 3.41 Demo Summary
        00:27
      • 3.42 Quiz
      • 3.43 Summary
        01:03
      • 3.44 Thank you
        00:06
    • Lesson 04 - Create Advanced Charts in Excel 2013

      26:43Preview
      • 4.1 Create Advanced Charts in Excel 2013
        00:26
      • 4.2 Objectives
        00:23
      • 4.3 Trendlines
        01:24
      • 4.4 Linear Trendline
        00:39
      • 4.5 Logarithmic Trendline
        00:54
      • 4.6 Polynomial Trendline
        01:07
      • 4.7 Power Trendline
        00:50
      • 4.8 Exponential Trendline
        00:45
      • 4.9 Moving Average Trendline
        01:02
      • 4.10 Business Scenario
        05:08
      • 4.11 Demo Summary
        00:21
      • 4.12 Chart Elements
        01:22
      • 4.13 Filters in Charts
        00:26
      • 4.14 Dual Axis Charts
        01:11
      • 4.15 Business Scenario
        04:09
      • 4.16 Demo Summary
        00:27
      • 4.17 Create Custom Chart Templates
        01:16
      • 4.18 Business Scenario
        02:49
      • 4.19 Demo Summary
        00:51
      • 4.20 Quiz
      • 4.21 Summary
        01:07
      • 4.22 Thank You
        00:06
    • Lesson 05 - Create and Manage PivotTables

      49:06Preview
      • 5.1 Create and Manage PivotTables
        00:21
      • 5.2 Objectives
        00:22
      • 5.3 PivotTables
        01:00
      • 5.4 Create PivotTables
        00:55
      • 5.5 Create PivotTables contd
        01:36
      • 5.6 Create PivotTables contd
        02:05
      • 5.7 Create PivotTables contd
        00:28
      • 5.8 Business Scenario
        02:04
      • 5.9 Demo Summary
        00:13
      • 5.10 Recommended PivotTables Button
        00:38
      • 5.11 Business Scenario
        01:07
      • 5.12 Demo Summary
        00:12
      • 5.13 Format Pivot tables
      • 5.14 Business Scenario
        02:18
      • 5.15 Demo Summary
        00:14
      • 5.16 Modify Field Headers
        00:52
      • 5.17 Business Scenario
        02:03
      • 5.18 Demo Summary
        00:14
      • 5.19 Change the View of Data
        00:45
      • 5.20 Group Records
        00:36
      • 5.21 Business Scenario
        01:59
      • 5.22 Demo Summary
        00:12
      • 5.23 Calculated Field and Calculated Item
        00:45
      • 5.24 Calculated Field and Calculated Item contd
        00:43
      • 5.25 Business Scenario
        02:44
      • 5.26 Demo Summary
        00:19
      • 5.27 Slicers
        01:06
      • 5.28 Slicers contd
        00:30
      • 5.29 Business Scenario
        02:10
      • 5.30 Demo Summary
        00:12
      • 5.31 View Chart Animations
        00:36
      • 5.32 Business Scenario
        02:38
      • 5.33 Demo Summary
        00:15
      • 5.34 Install PowerPivot Add in
        00:25
      • 5.35 Business Scenario
        01:12
      • 5.36 Demo Summary
        00:15
      • 5.37 PowerPivot
        00:45
      • 5.38 PowerPivot contd
        00:33
      • 5.39 Business Scenario
        00:53
      • 5.40 Demo Summary
        00:09
      • 5.41 PowerPivot Relationships
        00:53
      • 5.42 Create Relationship between Tables
        00:17
      • 5.43 Create Relationship between Tables contd
        01:10
      • 5.44 Business Scenario
        02:17
      • 5.45 Demo Summary
        00:15
      • 5.46 Edit and Delete Relationship
        00:15
      • 5.47 Business Scenario
        01:55
      • 5.48 Demo Summary
        00:16
      • 5.49 Create PowerPivot Hierarchy
        00:34
      • 5.50 Business Scenario
        01:32
      • 5.51 Demo Summary
        00:13
      • 5.52 Modify PowerPivot Hierarchy
        00:54
      • 5.53 Business Scenario
        00:59
      • 5.54 Demo Summary
        00:11
      • 5.55 Quiz
      • 5.56 Summary
        00:57
      • 5.57 Thank You
        00:04

Reviews

  • Hussain Somjee

    Hussain Somjee

    Graduate, Occidental College

    Great introduction to using excel for finance and non-finance executives.

  • Veselina Kasapova

    Veselina Kasapova

    Auditor at Bulgarian National Audit Office

    New and useful information, really simple to learn.

  • Jordyn Woods

    Jordyn Woods

    Extremely well designed e-learning content. Well done Simplilearn!

  • Clara Wells

    Clara Wells

    This is just what I was looking for! I now feel I know what can be achieved in Excel and I definitely recommend this course to anybody who wants to master Excel's exciting features.

  • Elena Alvarez

    Elena Alvarez

    Impressed with the detail in this course. Well laid out courseware with nicely put tips and tricks to excel the Excel.

prevNext

Why Online Bootcamp

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

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 with the following criteria:

    • Complete 85% of the course.

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

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

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