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 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:17
      • 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:17
      • 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:23
      • 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:43
      • 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:06
      • 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
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

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!

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.

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.

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

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