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 Advanced: MOS Certification (Exam – 77-428)

    Preview
    • Lesson 01 - Manage and Share Workbooks

      35:27Preview
      • 1.1 Introduction
        00:26
      • 1.2 Objectives
        00:57
      • 1.3 Modify Workbook Templates
        00:31
      • 1.4 - Business Scenario
        00:30
      • 1.5 Demo - Modify Workbook Templates
        01:27
      • 1.6 Merge Multiple Workbooks
        00:52
      • 1.7 Business Scenario
        00:30
      • 1.8 Demo - Merge Multiple Workbooks
        02:12
      • 1.9 Manage Multiple Versions Of A Workbook
        00:45
      • 1.10 Remove Workbook Metadata
        00:54
      • 1.11 Copy Styles Between Tables
        00:28
      • 1.12 Business Scenario
        00:27
      • 1.13 Demo - Copy Styles Between Templates
        00:51
      • 1.14 Copy Macros Between Workbooks
        00:35
      • 1.15 Business Scenario
        00:26
      • 1.16 Demo - Copy Macros Between Workbooks
        01:04
      • 1.17 External Data Connections
        01:13
      • 1.18 Business Scenario
        00:27
      • 1.19 Demo - External Data Connections
        02:26
      • 1.20 Protect Workbooks For Sharing
        00:25
      • 1.21 Business Scenario
        00:30
      • 1.22 Demo - Protect Workbooks For Sharing
        00:39
      • 1.23 Protect Worksheet Structure
        00:52
      • 1.24 Business Scenario
        00:32
      • 1.25 Demo - Protect Worksheet Structure
        01:01
      • 1.26 Set Tracking Options
        01:13
      • 1.27 Business Scenario
        00:25
      • 1.29 Restrict Editing And Limiting Editors
        00:35
      • 1.30 Business Scenario
        00:31
      • 1.31 Demo - Restrict Editing And Limiting Editors
        02:01
      • 1.32 Encrypt Workbooks With A Password
        00:48
      • 1.33 Business Scenario
        00:37
      • 1.34 Demo - Encrypt Workbook With A Password
        02:17
      • 1.35 Business Scenario
        00:32
      • 1.36 Demo - Mark Workbooks As Final
        00:45
      • 1.37 Control Calculations Options
        01:02
      • 1.38 Business Scenario
        00:30
      • 1.39 Demo - Control Calculations Options
        01:27
      • 1.40 - Summary
        00:55
      • 1.41 Mark Workbooks As Final
        00:49
      • 1.42 Quiz
    • Lesson 02 - Apply Custom Formats and Layouts

      39:01Preview
      • 2.1 Apply Custom Formats and LAyouts
        00:25
      • 2.2 Objectives
        00:49
      • 2.3 Create Custom Formats (number, Time, Date)
        06:14
      • 2.4 Business Scenario
        00:25
      • 2.5 Demo - Create Custom Formats Number Date
        02:48
      • 2.6 Create Custom Accounting Formats
        00:57
      • 2.7 Advanced Fill Series Options
        01:56
      • 2.8 Business Scenario
        00:32
      • 2.9 Demo - Advanced Fill Series Options
        02:01
      • 2.10 Create Custom Templates
        01:14
      • 2.11 Create And Modify Cell Styles
        00:57
      • 2.12 Business Scenario
        00:30
      • 2.13 Demo - Create And Modify Cell Styles
        03:06
      • 2.14 Create Custom Color Formats
        00:52
      • 2.15 Business Scenario
        00:24
      • 2.16 Demo - Create Custom Color Formats
        01:46
      • 2.17 Create Custom Font Formats
        00:40
      • 2.18 Business Scenario
        00:23
      • 2.19 Demo - Create Custom Font Formats
        02:41
      • 2.20 Create Themes
        00:37
      • 2.21 Business Scenario
        00:25
      • 2.22 Demo - Create Themes
        01:04
      • 2.23 Create Form Fields
        02:50
      • 2.24 Business Scenario
        00:29
      • 2.25 Demo - Create Form Fields
        03:11
      • 2.26 Control The Tab Order Of Objects
        00:56
      • 2.27 Summary
        00:49
      • 2.28 Quiz
    • Lesson 03 - Create Advanced Formulas

      50:31Preview
      • 3.1 Introduction
        00:26
      • 3.2 Objectives
        01:12
      • 3.3 Nested Functions
        01:06
      • 3.4 If, And, Or Functions
        01:49
      • 3.5 Business Scenario
        00:31
      • 3.6 Demo - If And Or Functions
        02:38
      • 3.7 Advanced Sumifs Function
        01:44
      • 3.8 Business Scenario
        00:40
      • 3.9 Demo - Advanced Sumifs Functions
        05:55
      • 3.10 Advanced Countifs Function
        01:18
      • 3.11 Business Scenario
        00:37
      • 3.12 Demo - Advanced Countifs Functions
        02:18
      • 3.13 Advanced Averageifs Function
        01:17
      • 3.14 Business Scenario
        00:36
      • 3.15 Demo - Advanced Averageifs Functions
        03:09
      • 3.16 What-if-analysis Tools
        01:32
      • 3.17 Watch Window
        01:06
      • 3.18 Business Scenario
        00:24
      • 3.19 Demo - Utilize Watch Window
        01:26
      • 3.20 Goal Seek
        00:55
      • 3.21 Business Scenario
        00:37
      • 3.22 Demo - Goal Seek
        01:10
      • 3.23 Create Scenarios
        01:32
      • 3.24 Business Scenario
        00:28
      • 3.25 Demo - Create Scenarios
        05:27
      • 3.26 Create Data Table
        02:32
      • 3.27 Business Scenario
        00:25
      • 3.28 Demo - Data Table
        00:41
      • 3.29 Consolidate Data
        01:39
      • 3.30 Business Scenario
        00:27
      • 3.31 Demo - Consolidate Data
        00:57
      • 3.32 Financial Functions
        02:55
      • 3.33 Summary
        01:02
      • 3.34 Quiz
    • Lesson 04 - Create Advanced Charts and Objects

      16:25Preview
      • 4.1 Introduction
        00:25
      • 4.2 Objectives
        00:31
      • 4.3 Pivotchart
        01:32
      • 4.4 Create New Pivotcharts
        04:17
      • 4.5 Business Scenario
        00:26
      • 4.6 Demo - Create New Pivotcharts
        01:32
      • 4.7 Pivotcharts With Animations
        00:38
      • 4.8 Business Scenario
        00:34
      • 4.9 Pivotcharts With Animations
        00:56
      • 4.10 Manipulate Options In Existing Pivotcharts
        00:48
      • 4.11 Business Scenario
        00:23
      • 4.12 Manipulate Options In Existing Pivotcharts
        01:34
      • 4.13 Pivotchart Styles
        00:36
      • 4.14 Business Scenario
        00:20
      • 4.15 Demo - Pivotcharts Styles
        01:22
      • 4.16 Summary
        00:31
      • 4.17 Quiz
    • Lesson 05 - Excel 2013 Advance New Features

      23:45Preview
      • 5.1 Introduction
        00:24
      • 5.2 Objectives
        00:38
      • 5.3 Introduction To Apps For Office
        04:17
      • 5.4 Installing Apps From Office Store
        00:48
      • 5.5 Business Scenario
        00:28
      • 5.6 Demo - Installing Apps From Office Store
        01:31
      • 5.7 Inserting And Managing Apps
        00:43
      • 5.8 Business Scenario
        00:27
      • 5.9 Demo - Inserting And Managing Apps
        01:14
      • 5.10 Timeline Filter
        01:59
      • 5.11 Business Scenario
        00:32
      • 5.12 Demo - Timeline Filter
        01:25
      • 5.13 Introduction To Powerview Report
        03:47
      • 5.14 Create Powerview Report
        01:00
      • 5.15 Business Scenario
        00:27
      • 5.16 Demo - Creating Powerview Reports
        01:03
      • 5.17 Powerview Reports Options
        01:17
      • 5.18 Business Scenario
        00:29
      • 5.19 Demo - Powerview Reports Option
        00:37
      • 5.20 Summary
        00:39
      • 5.21 Quiz
    • Lesson 06 - Creating Templates with Advanced Functions

      38:58Preview
      • 6.1 Introduction
        00:24
      • 6.2 Objectives
        00:57
      • 6.3 Creating Excel User Defined Templates
        01:05
      • 6.4 Business Scenario
        00:39
      • 6.5 Demo 1 - Creating Excel User Defined Templates
        09:59
      • 6.6 Multiple List Box
        00:58
      • 6.7 Business Scenario
        00:37
      • 6.8 Demo 2 - Multiple List Box
        02:55
      • 6.9 Advanced Validation Rule With Isnumber
        00:41
      • 6.10 Business Scenario
        00:37
      • 6.11 Demo 3 - Advanced Validation Rule With Isnumber
        01:46
      • 6.12 Advanced Validation Rule With Istext
        00:38
      • 6.13 Business Scenario
        00:35
      • 6.14 Demo 4 - Advanced Validation Rule With Istext
        01:12
      • 6.15 Combine Date And Logical Functions
        00:36
      • 6.16 Business Scenario
        00:43
      • 6.17 Demo 5 - Combine Date And Logical Functions
        03:56
      • 6.18 Eomonth Function
        01:26
      • 6.19 Business Scenario
        00:30
      • 6.20 Demo 6 - Eomonth Function
        01:10
      • 6.21 Match Function
        03:06
      • 6.22 Business Scenario
        00:26
      • 6.23 Match Function
        00:37
      • 6.24 Business Scenario
        00:30
      • 6.25 Index With Match Function
        01:12
      • 6.26 ndex With Match Function
        00:55
      • 6.27 Summary
        00:48

Exam & Certification

  • How do I become a certified Microsoft Excel 2013 Advanced Professional?

    To become certified, you must pass the Microsoft certification exam. You can register for the exam on the Microsoft website, where it will be scheduled with Pearson VUE.

Reviews

  • Teresa Gibbons

    Teresa Gibbons

    Manager at CDK Global LLC

    Filled in missing gaps in my knowledge. Thank you

  • Valentina Ruiz

    Valentina Ruiz

    Great training. Easy to understand and well explained courseware. Excellent online course for the excel users.

  • Kendall Kennedy

    Kendall Kennedy

    I found this course easy to follow with great clarity. The course material itself is highly recommended.

  • Paige Harrison

    Paige Harrison

    Simplilearn’s Excel-Advanced course was perfect in getting into the advanced level details of Excel. I thoroughly enjoyed the course and feel much more confident.

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

  • What payment options are available?

    You can enroll through our website and make an online payment using any of the following options:

    • Visa debit/credit card
    • American Express and Diners Club card
    • Mastercard
    • PayPal
    • Once payment is processed, you will automatically receive a payment receipt and access information via email.

  • What does this training include?

    You will receive access to e-learning content for all learning units as well as access to exclusive forums moderated by faculty and industry experts.

  • If I need to cancel my enrollment, can I get a refund?

    Yes, you can cancel your enrollment if necessary. We will refund the course price after deducting an administration fee. To learn more, please read our Refund Policy.

  • Do you provide a 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 our Refund Policy. Refund requests can be submitted via our Help and Support portal.

  • Can I extend the access period?

    Yes, you can extend the access period by paying an additional fee. Please raise a request via our Help and Support portal.

  • Where and how can I access the e-learning content? Are there any limitations?

    Once you register with us for a course and pay the course fee, you will have 24/7 access to the e-learning content on our website. An automated course purchase confirmation email sent by us will guide you through the process.

  • I’d like to learn more about this training program. Whom should I contact?

    Contact us using the form on the right of any page on the Simplilearn website, or select the Live Chat link. Our customer service representatives can provide you with more details.

  • Who are the instructors and how are they selected?

    All of our highly-qualified trainers are certified, with more than 15 years of experience in training and working in their domain. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they qualify as Simplilearn trainers. We also ensure that only those trainers who maintain a high alumni rating continue to train for us.

  • What is Global Teaching Assistance?

    Our teaching assistants are a dedicated team of subject matter experts here to help you get certified in your first attempt. They engage students proactively to ensure the course path is being followed and help you enrich your learning experience, from class onboarding to project mentoring and job assistance. Teaching Assistance is available during business hours.

  • How does Simplilearn ensure the effectiveness of the material and the training?

    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.

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

    Please raise a request through Help and Support. You can also use our chat function for an instant solution.

  • What is covered under the 24/7 Support promise?

    We offer 24/7 support through email, chat, and calls. We also have a dedicated team that provides on-demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.

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