Course description

  • What are the course objectives?

    Microsoft Excel 2013 Advanced certification will establish your proficiency in handling both basic and advanced formulas and tools in the most commonly used spreadsheet software program. This certification training is critical for both business and finance professionals and will enhance your understanding of advanced tools used for organizing, visualizing, calculating and managing data in MS Excel 2013. It is ideal for those who are looking to improve their job prospects by adopting advanced Excel 2013 skills and knowledge.

  • Why is this certification so desirable?

    Expertise with Microsoft Excel 2013 is a highly desired skillset in today’s complex business environment where financial and business analysis creates real competitive advantage. The Microsoft Excel 2013: MOS advanced certification verifies your ability to work with the feature-rich Excel 2013 application efficiently and effectively, helping you maximize the value of data, control costs more effectively through better analysis of business information and enhance your career opportunities.
     
    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.

  • What skills will you learn?

    At the end of Simplilearn’s training in advanced Microsoft Excel 2013, you will be able to: 
    • Manage versions of a workbook and remove workbook metadata
    • Identify the steps for setting tracking options and limiting editors
    • Create custom accounting, color and font formats
    • Manipulate options in existing pivot charts
    • List the steps for installing apps from office store

  • Who should take this course?

    Microsoft Excel 2013 advanced certification is ideal for any professional who is looking to improve his or her job prospects by adopting Excel 2013 advanced skills and knowledge.

  • Why choose Simplilearn for your training?

    • Simplilearn is one of the world’s largest certification training providers, with more than 500,000 professionals trained globally
    • Trusted by Fortune 500 companies as their learning provider for career growth and training
    • Thousands of certified and experienced trainers conducting trainings around the world
    • Robust learning management system (LMS) designed to ensure you pass your certification tests on the first attempt.
    • Accredited, Approved and Recognized as a training organization, partner, education provider and examination center by globally renowned names like Project Management Institute, APMG, CFA Institute, GARP, ASTQB, IIBA and others
    • Our high-touch support model with 24/7 teaching assistance provides a fulfilling online learning experience, from the moment you start your training to the day you get your certification

Course preview

    • Lesson 01 - Manage and Share Workbooks 35:27
      • 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:01
      • 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:31
      • 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:25
      • 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:45
      • 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:58
      • 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
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

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

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.

Read more Read less
Valentina Ruiz
Valentina Ruiz

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

FAQs

  • How do I enroll for the online training?

    You can enroll for this training on our website and make an online payment using any of the following options: 
    • Visa Credit or Debit Card
    • MasterCard
    • American Express
    • Diner’s Club
    • PayPal 
    Once payment is received 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 contact our Help and Support portal for more information.

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

    Once you register for this course, you will have 24/7 access to the e-learning content on our website. An automated course purchase confirmation will guide you through the process.

  • How can I learn more about this training program?

    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 our instructors and how are they selected?

    All of our highly qualified trainers are industry experts with at least 15 years of relevant teaching experience. Each of them has gone through a rigorous selection process that includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating remain on our faculty.

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

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

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

    Our certification training is designed for you to pass the exams on your first attempt. With a hands-on learning approach and Global Learning Framework, the training not only gives you the confidence to pass the exam, but also helps you retain knowledge beyond the exam.

  • I am not able to access the online course. Who can help me?

    Contact us using the form on the right of any page on the Simplilearn website, select the Live Chat link or contact Help & Support.

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