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.

  • 5 hours of high-quality e-learning content
  • 6 chapter-end quizzes
  • 3 simulation exams
  • 102 demos with example on application
  • 49 live demos
  • 49 scenario and case studies included

Course description

  • What is this course about?

    Microsoft® Excel 2013 Intermediate 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 is the certification most sought-after?

    Several responsible positions across various industry sectors require professionals with good MS Excel skills to harness the power of macros, who can set the macro-security levels for protecting the organization against virus. Macros also help organizations in bypassing data-entry functions. Employers across the globe seek professionals who are proficient in Excel shortcuts and macros. Following are some of the major reasons, which make this course most sought after:
    • Many businesses seek professionals who have strong data analyzing and organizing skills. Getting Microsoft Excel certified can give you a competitive edge over the others.
    • Employers generally rush through the resume hunting for credentials that add value to their business. MS Excel is one such credential that can quickly get your resume noticed by the recruiters.
    • High-paying profiles such as business analysts, administrative assistants, marketing managers and project managers demand Excel skills.
    • Microsoft Excel is a ubiquitous and valuable tool, which enables professionals to arrange huge data and perform graphing, calculations, making the interpretation of information and data easy.

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

    Following are the learning benefits of MS Excel Intermediate Online training program:
    • Trained candidates will be able to carry out conditional formatting and apply it to tables, worksheets, PivotTables, and cells and also use formulas for applying conditional formatting.
    • Participants will be able to use VLOOKUP for finding relevant information or data from large spreadsheets.
    • Filter and sort data entailed here enables the professionals to quickly huge sets or lists of data and extract the necessary information.
    • Trained participants will be able to switch and upgrade to newer versions of MS Excel and begin with the new version.

  • Who should do this course?

    MS Excel Intermediate training program is ideal for-
    • Candidates who are interested in extending their knowledge and understanding of Microsoft excel.
    • Professionals who use Microsoft Excel to perform daily activities.
    • Professionals working in marketing, accounting and is also best suited for pricing analysts and business analysts.

  • Why Simplilearn?

    • 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 Intermediate Course 07:18
      • 0.1 Welcome00:08
      • 0.2 Overview Of MOS Intermediate Course00:44
      • 0.3 Table Of Content00:53
      • 0.4 Course Objectives00:27
      • 0.5 Course Overview00:55
      • 0.6 Value Of Excel For Professionals00:38
      • 0.7 Value Of Excel For Organizations00:50
      • 0.8 Lessons Covered00:15
      • 0.9 Exam Pattern00:29
      • 0.10 Microsoft Excel 2013 Mos Intermediate Certification01:29
      • 0.11 Sources Of Information00:19
      • 0.12 Thank You00:11
    • Lesson 01 - Manage And Share Workbooks In Ms Excel 2013 18:17
      • 1.1 Manage And Share Workbooks In Ms Excel 201300:22
      • 1.2 Objectives00:21
      • 1.3 Share Workbooks00:59
      • 1.4 Shareworkbooks (Contd.)00:42
      • 1.5 Business Scenario00:58
      • 1.6 Demo Summary00:11
      • 1.7 Track Changes02:06
      • 1.8 Highlight Changes And Comments01:13
      • 1.9 Business Scenario02:16
      • 1.10 Demo Summary00:23
      • 1.11 Accept And Reject Changes01:01
      • 1.12 Business Scenario02:38
      • 1.13 Demo Summary00:16
      • 1.14 Formula Errors01:21
      • 1.15 Error Tracing00:55
      • 1.16 Business Scenario01:09
      • 1.17 Demo Summary00:16
      • 1.18 Quiz
      • 1.19 Summary00:59
      • 1.20 Thank You00:11
    • Lesson 02 - Apply Custom Formats and Layouts 43:17
      • 2.1 Apply Custom formats and layouts00:28
      • 2.2 Objectives00:28
      • 2.3 Create Custom Conditional formats00:56
      • 2.4 Conditional Formatting Rule Types01:32
      • 2.5 Business Scenario01:48
      • 2.6 Demo Summary00:14
      • 2.7 Formatting cells Using Formulas00:35
      • 2.8 Formatting Celis Using Formulas (contd.)00:31
      • 2.9 Business Scenario03:37
      • 2.10 Demo Summary00:20
      • 2.11 Manage Conditional Format Rules01:13
      • 2.12 Manage conditional format Rules (contd.)00:48
      • 2.13 Business Scenario04:08
      • 2.14 Demo Summary00:21
      • 2.15 Create Advance Filters by Search00:39
      • 2.16 Business Scenario02:12
      • 2.17 Demo Summary00:19
      • 2.18 Create Advance Filters Using Values00:18
      • 2.19 Business Scenario02:57
      • 2.20 Demo Summary00:24
      • 2.21 Create Advance Filters by Colors00:23
      • 2.22 Business Scenario01:04
      • 2.23 Demo Summary00:17
      • 2.24 Modify Worksheets with Accessibility Tools01:08
      • 2.25 Modify Worksheets with Accessibility Tools (Contd.)01:09
      • 2.26 Business Scenario00:57
      • 2.27 Demo Summary00:09
      • 2.28 Display Data in Multiple international Formats01:00
      • 2.29 Business Scenario01:14
      • 2.30 Demo Summary00:19
      • 2.31 Proofing in other languages00:50
      • 2.32 Proofing in Other languages (Contd.)00:38
      • 2.33 Business Scenario02:18
      • 2.34 Demo Summary00:19
      • 2.35 Use international symbols00:50
      • 2.36 Use international Symbols (contd.)00:28
      • 2.37 Business Scenario01:05
      • 2.38 Demo Summary00:17
      • 2.39 Manage body and heading fonts00:48
      • 2.40 Manage body and Heading fonts (contd.)00:24
      • 2.41 Business Scenario02:12
      • 2.42 Demo Summary00:20
      • 2.43 Quiz
      • 2.44 Summary01:09
      • 2.45 Thank You00:11
    • Lesson 03 - Create Advanced Formulas in Excel 2013 59:23
      • 3.1 Create Advanced Formulas in Excel 201300:22
      • 3.2 Objectives00:20
      • 3.3 LOOKUP Functions00:48
      • 3.4 VLOOKUP Function00:56
      • 3.5 Syntax Arguments in VLOOKUP Function02:28
      • 3.6 Business Scenario03:05
      • 3.7 Demo Summary00:10
      • 3.8 HLOOKUP Function00:46
      • 3.9 Syntax Arguments in HLOOKUP Function02:11
      • 3.10 Business Scenario02:58
      • 3.11 Demo Summary00:10
      • 3.12 LOOKUP Function01:03
      • 3.13 Syntax Arguments in LOOKUP Function02:06
      • 3.14 Business Scenario02:37
      • 3.15 Demo Summary00:11
      • 3.16 TRANSPOSE Function00:58
      • 3.17 Business Scenario01:58
      • 3.18 Demo Summary00:10
      • 3.19 TODAY and NOW Functions00:41
      • 3.20 Business Scenario01:34
      • 3.21 Demo Summary00:11
      • 3.22 DAY MONTH and YEAR Functions01:00
      • 3.23 Business Scenario02:58
      • 3.24 Demo Summary00:12
      • 3.25 HOUR MINUTE and SECOND Functions01:18
      • 3.26 Business Scenario03:08
      • 3.27 Demo Summary00:10
      • 3.28 DATEVALUE and TIMEVALUE Functions00:50
      • 3.29 Business Scenario02:15
      • 3.30 Demo Summary00:13
      • 3.31 CONCATENATE Function00:56
      • 3.32 WEEKDAY and WEEKNUM Functions00:46
      • 3.33 Syntax Arguments in WEEKDAY and WEEKNUM Function01:09
      • 3.34 Business Scenario03:42
      • 3.35 Demo Summary00:14
      • 3.36 WORKDAY and WORKDAY INTL Functions02:11
      • 3.37 Business Scenario04:23
      • 3.38 Demo Summary00:16
      • 3.39 NETWORKDAYS and NETWORKDAYS INTL Functions01:51
      • 3.40 Business Scenario04:32
      • 3.41 Demo Summary00:27
      • 3.42 Quiz
      • 3.43 Summary01:03
      • 3.44 Thank you00:06
    • Lesson 04 - Create Advanced Charts in Excel 2013 26:43
      • 4.1 Create Advanced Charts in Excel 201300:26
      • 4.2 Objectives00:23
      • 4.3 Trendlines01:24
      • 4.4 Linear Trendline00:39
      • 4.5 Logarithmic Trendline00:54
      • 4.6 Polynomial Trendline01:07
      • 4.7 Power Trendline00:50
      • 4.8 Exponential Trendline00:45
      • 4.9 Moving Average Trendline01:02
      • 4.10 Business Scenario05:08
      • 4.11 Demo Summary00:21
      • 4.12 Chart Elements01:22
      • 4.13 Filters in Charts00:26
      • 4.14 Dual Axis Charts01:11
      • 4.15 Business Scenario04:09
      • 4.16 Demo Summary00:27
      • 4.17 Create Custom Chart Templates01:16
      • 4.18 Business Scenario02:49
      • 4.19 Demo Summary00:51
      • 4.20 Quiz
      • 4.21 Summary01:07
      • 4.22 Thank You00:06
    • Lesson 05 - Create and Manage PivotTables 49:06
      • 5.1 Create and Manage PivotTables00:21
      • 5.2 Objectives00:22
      • 5.3 PivotTables01:00
      • 5.4 Create PivotTables00:55
      • 5.5 Create PivotTables contd01:36
      • 5.6 Create PivotTables contd02:05
      • 5.7 Create PivotTables contd00:28
      • 5.8 Business Scenario02:04
      • 5.9 Demo Summary00:13
      • 5.10 Recommended PivotTables Button00:38
      • 5.11 Business Scenario01:07
      • 5.12 Demo Summary00:12
      • 5.13 Format Pivot tables
      • 5.14 Business Scenario02:18
      • 5.15 Demo Summary00:14
      • 5.16 Modify Field Headers00:52
      • 5.17 Business Scenario02:03
      • 5.18 Demo Summary00:14
      • 5.19 Change the View of Data00:45
      • 5.20 Group Records00:36
      • 5.21 Business Scenario01:59
      • 5.22 Demo Summary00:12
      • 5.23 Calculated Field and Calculated Item00:45
      • 5.24 Calculated Field and Calculated Item contd00:43
      • 5.25 Business Scenario02:44
      • 5.26 Demo Summary00:19
      • 5.27 Slicers01:06
      • 5.28 Slicers contd00:30
      • 5.29 Business Scenario02:10
      • 5.30 Demo Summary00:12
      • 5.31 View Chart Animations00:36
      • 5.32 Business Scenario02:38
      • 5.33 Demo Summary00:15
      • 5.34 Install PowerPivot Add in00:25
      • 5.35 Business Scenario01:12
      • 5.36 Demo Summary00:15
      • 5.37 PowerPivot00:45
      • 5.38 PowerPivot contd00:33
      • 5.39 Business Scenario00:53
      • 5.40 Demo Summary00:09
      • 5.41 PowerPivot Relationships00:53
      • 5.42 Create Relationship between Tables00:17
      • 5.43 Create Relationship between Tables contd01:10
      • 5.44 Business Scenario02:17
      • 5.45 Demo Summary00:15
      • 5.46 Edit and Delete Relationship00:15
      • 5.47 Business Scenario01:55
      • 5.48 Demo Summary00:16
      • 5.49 Create PowerPivot Hierarchy00:34
      • 5.50 Business Scenario01:32
      • 5.51 Demo Summary00:13
      • 5.52 Modify PowerPivot Hierarchy00:54
      • 5.53 Business Scenario00:59
      • 5.54 Demo Summary00:11
      • 5.55 Quiz
      • 5.56 Summary00:57
      • 5.57 Thank You00:04
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Reviews

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

New and useful information, really simple to learn.

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

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

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.

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