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.

  • Training for Microsoft® 77-428 exam
  • 6 hours of high-quality e-learning content
  • 18 end-of-chapter quizzes
  • 45 industry based examples
  • 3 Microsoft Excel 2013 simulation exams

Course description

  • What is this course about?

    Microsoft Excel 2013 Advanced certification establishes a professional’s proficiency in handling basic and advanced formulas and tools. This certification training helps users to enhance their understanding of the basic tools 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 the certification so desirable?

    Excel 2013 is the most commonly used spreadsheet software which allows you to organize the data into meaningful output. The Microsoft Excel 2013: MOS advanced certification proves that you can work with Excel 2013 application effectively and efficiently. Currently, there are approximately 37,500 professionals across the globe who hold a Microsoft Certified Solutions Associate (MCSA) certification.

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

    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

  • What are the career benefits in-store for you?

    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.

    The skills you gain in this course will help you maximize the value of your data, which helps to control costs more effectively through better analysis of business information. This course and certification will increase your visibility in your organization and set you apart from your colleague, ensuring that you get recognized for your knowledge and skill.

  • Who should take this course?

    Microsoft Excel 2013 advanced certification enables you to gain proficiency in creating and applying advanced formulas, charts and templates. This certification training enhances your skills in managing and sharing workbooks, applying custom formats, customizing layouts and more. It is ideal for those who are looking to improve their job prospects by adopting Excel 2013 advanced skills and knowledge.

  • Why choose Simplilearn for your training?

    Simplilearn is the world’s largest certification training provider, with over 500,000+ professionals trained globally. We are trusted by Fortune 500 companies as their learning provider for career growth and training. Our 2000+ certified and experienced instructors conduct training for various courses across the globe. All of our courses are designed and developed under a tried and tested unique learning framework that is proven to deliver a 98.6% pass rate upon the candidate’s first attempt at the exam.

    Simplilearn is 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 01 - Manage and Share Workbooks 35:27
      • 1.1 Introduction00:26
      • 1.2 Objectives00:57
      • 1.3 Modify Workbook Templates00:31
      • 1.4 - Business Scenario00:30
      • 1.5 Demo - Modify Workbook Templates01:27
      • 1.6 Merge Multiple Workbooks00:52
      • 1.7 Business Scenario00:30
      • 1.8 Demo - Merge Multiple Workbooks02:12
      • 1.9 Manage Multiple Versions Of A Workbook00:45
      • 1.10 Remove Workbook Metadata00:54
      • 1.11 Copy Styles Between Tables00:28
      • 1.12 Business Scenario00:27
      • 1.13 Demo - Copy Styles Between Templates00:51
      • 1.14 Copy Macros Between Workbooks00:35
      • 1.15 Business Scenario00:26
      • 1.16 Demo - Copy Macros Between Workbooks01:04
      • 1.17 External Data Connections01:13
      • 1.18 Business Scenario00:27
      • 1.19 Demo - External Data Connections02:26
      • 1.20 Protect Workbooks For Sharing00:25
      • 1.21 Business Scenario00:30
      • 1.22 Demo - Protect Workbooks For Sharing00:39
      • 1.23 Protect Worksheet Structure00:52
      • 1.24 Business Scenario00:32
      • 1.25 Demo - Protect Worksheet Structure01:01
      • 1.26 Set Tracking Options01:13
      • 1.27 Business Scenario00:25
      • 1.29 Restrict Editing And Limiting Editors00:35
      • 1.30 Business Scenario00:31
      • 1.31 Demo - Restrict Editing And Limiting Editors02:01
      • 1.32 Encrypt Workbooks With A Password00:48
      • 1.33 Business Scenario00:37
      • 1.34 Demo - Encrypt Workbook With A Password02:17
      • 1.35 Business Scenario00:32
      • 1.36 Demo - Mark Workbooks As Final00:45
      • 1.37 Control Calculations Options01:02
      • 1.38 Business Scenario00:30
      • 1.39 Demo - Control Calculations Options01:27
      • 1.40 - Summary00:55
      • 1.41 Mark Workbooks As Final00:49
      • 1.42 Quiz
    • Lesson 02 - Apply Custom Formats and Layouts 39:01
      • 2.1 Apply Custom Formats and LAyouts00:25
      • 2.2 Objectives00:49
      • 2.3 Create Custom Formats (number, Time, Date)06:14
      • 2.4 Business Scenario00:25
      • 2.5 Demo - Create Custom Formats Number Date02:48
      • 2.6 Create Custom Accounting Formats00:57
      • 2.7 Advanced Fill Series Options01:56
      • 2.8 Business Scenario00:32
      • 2.9 Demo - Advanced Fill Series Options02:01
      • 2.10 Create Custom Templates01:14
      • 2.11 Create And Modify Cell Styles00:57
      • 2.12 Business Scenario00:30
      • 2.13 Demo - Create And Modify Cell Styles03:06
      • 2.14 Create Custom Color Formats00:52
      • 2.15 Business Scenario00:24
      • 2.16 Demo - Create Custom Color Formats01:46
      • 2.17 Create Custom Font Formats00:40
      • 2.18 Business Scenario00:23
      • 2.19 Demo - Create Custom Font Formats02:41
      • 2.20 Create Themes00:37
      • 2.21 Business Scenario00:25
      • 2.22 Demo - Create Themes01:04
      • 2.23 Create Form Fields02:50
      • 2.24 Business Scenario00:29
      • 2.25 Demo - Create Form Fields03:11
      • 2.26 Control The Tab Order Of Objects00:56
      • 2.27 Summary00:49
      • 2.28 Quiz
    • Lesson 03 - Create Advanced Formulas 50:31
      • 3.1 Introduction00:26
      • 3.2 Objectives01:12
      • 3.3 Nested Functions01:06
      • 3.4 If, And, Or Functions01:49
      • 3.5 Business Scenario00:31
      • 3.6 Demo - If And Or Functions02:38
      • 3.7 Advanced Sumifs Function01:44
      • 3.8 Business Scenario00:40
      • 3.9 Demo - Advanced Sumifs Functions05:55
      • 3.10 Advanced Countifs Function01:18
      • 3.11 Business Scenario00:37
      • 3.12 Demo - Advanced Countifs Functions02:18
      • 3.13 Advanced Averageifs Function01:17
      • 3.14 Business Scenario00:36
      • 3.15 Demo - Advanced Averageifs Functions03:09
      • 3.16 What-if-analysis Tools01:32
      • 3.17 Watch Window01:06
      • 3.18 Business Scenario00:24
      • 3.19 Demo - Utilize Watch Window01:26
      • 3.20 Goal Seek00:55
      • 3.21 Business Scenario00:37
      • 3.22 Demo - Goal Seek01:10
      • 3.23 Create Scenarios01:32
      • 3.24 Business Scenario00:28
      • 3.25 Demo - Create Scenarios05:27
      • 3.26 Create Data Table02:32
      • 3.27 Business Scenario00:25
      • 3.28 Demo - Data Table00:41
      • 3.29 Consolidate Data01:39
      • 3.30 Business Scenario00:27
      • 3.31 Demo - Consolidate Data00:57
      • 3.32 Financial Functions02:55
      • 3.33 Summary01:02
      • 3.34 Quiz
    • Lesson 04 - Create Advanced Charts and Objects 16:25
      • 4.1 Introduction00:25
      • 4.2 Objectives00:31
      • 4.3 Pivotchart01:32
      • 4.4 Create New Pivotcharts04:17
      • 4.5 Business Scenario00:26
      • 4.6 Demo - Create New Pivotcharts01:32
      • 4.7 Pivotcharts With Animations00:38
      • 4.8 Business Scenario00:34
      • 4.9 Pivotcharts With Animations00:56
      • 4.10 Manipulate Options In Existing Pivotcharts00:48
      • 4.11 Business Scenario00:23
      • 4.12 Manipulate Options In Existing Pivotcharts01:34
      • 4.13 Pivotchart Styles00:36
      • 4.14 Business Scenario00:20
      • 4.15 Demo - Pivotcharts Styles01:22
      • 4.16 Summary00:31
      • 4.17 Quiz
    • Lesson 05 - Excel 2013 Advance New Features 23:45
      • 5.1 Introduction00:24
      • 5.2 Objectives00:38
      • 5.3 Introduction To Apps For Office04:17
      • 5.4 Installing Apps From Office Store00:48
      • 5.5 Business Scenario00:28
      • 5.6 Demo - Installing Apps From Office Store01:31
      • 5.7 Inserting And Managing Apps00:43
      • 5.8 Business Scenario00:27
      • 5.9 Demo - Inserting And Managing Apps01:14
      • 5.10 Timeline Filter01:59
      • 5.11 Business Scenario00:32
      • 5.12 Demo - Timeline Filter01:25
      • 5.13 Introduction To Powerview Report03:47
      • 5.14 Create Powerview Report01:00
      • 5.15 Business Scenario00:27
      • 5.16 Demo - Creating Powerview Reports01:03
      • 5.17 Powerview Reports Options01:17
      • 5.18 Business Scenario00:29
      • 5.19 Demo - Powerview Reports Option00:37
      • 5.20 Summary00:39
      • 5.21 Quiz
    • Lesson 06 - Creating Templates with Advanced Functions 38:58
      • 6.1 Introduction00:24
      • 6.2 Objectives00:57
      • 6.3 Creating Excel User Defined Templates01:05
      • 6.4 Business Scenario00:39
      • 6.5 Demo 1 - Creating Excel User Defined Templates09:59
      • 6.6 Multiple List Box00:58
      • 6.7 Business Scenario00:37
      • 6.8 Demo 2 - Multiple List Box02:55
      • 6.9 Advanced Validation Rule With Isnumber00:41
      • 6.10 Business Scenario00:37
      • 6.11 Demo 3 - Advanced Validation Rule With Isnumber01:46
      • 6.12 Advanced Validation Rule With Istext00:38
      • 6.13 Business Scenario00:35
      • 6.14 Demo 4 - Advanced Validation Rule With Istext01:12
      • 6.15 Combine Date And Logical Functions00:36
      • 6.16 Business Scenario00:43
      • 6.17 Demo 5 - Combine Date And Logical Functions03:56
      • 6.18 Eomonth Function01:26
      • 6.19 Business Scenario00:30
      • 6.20 Demo 6 - Eomonth Function01:10
      • 6.21 Match Function03:06
      • 6.22 Business Scenario00:26
      • 6.23 Match Function00:37
      • 6.24 Business Scenario00:30
      • 6.25 Index With Match Function01:12
      • 6.26 ndex With Match Function00:55
      • 6.27 Summary00: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?

    You need to appear for the Microsoft certification exam. The first step is to register for the examination at the Microsoft official website. Once registered, sign in, select your exam and schedule it with Pearson VUE.

Reviews

Teresa Gibbons

Filled in missing gaps in my knowledge. Thank you

Kendall Kennedy

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

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

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

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.