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 50% 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
  • 20 PDU's offered

About Course

  • What is this course about?

    Microsoft® Excel 2013 Advance certification enables the professionals to gain proficiency in handling basic formulas and tools. This certification training helps the 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 Excel 2013 fundamental skills and knowledge.

  • Why is the certification most sought-after?

    The Microsoft® Excel® 2013: MOS advanced certification proves that the certified professional can work with Excel 2013 application effectively and efficiently. This certification also proves the certified professional’s skills in Excel 2013.

    Currently there are approximately 37.5 thousand professionals across the globe who hold a Microsoft Certified Solutions Associate (MCSA) certification.

    Professionals can benefit from Excel in different ways. In Excel 2013, professionals can manage and share workbooks, create and apply several formulas and charts. This helps in organizing the data in meaningful output.

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

    At the end of Simplilearn’s training in Microsoft® Excel 2013 Advance, you will gain knowledge of the following:
    • 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 PivotCharts
    • List the steps for installing apps from office store

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

    The career benefits of this course are as follows:
    • 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.
    • It helps a professional by maximizing the value of their data, which helps to control costs more effectively, and obtaining business information.
    • This course and certification will increase your visibility in your organization.
    • This certification sets you apart from your colleague and ensures you get recognized for your knowledge and skill.

  • Who should do this course?

    Microsoft® Excel 2013 advanced certification enables the professionals’ to gain proficiency in creating and applying advanced formulas, charts, and templates. This certification training helps the users to enhance their skills in managing and sharing workbooks, applying custom formats and 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
    • 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 Syllabus

    • 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 00:00
    • 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 00:00
    • 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 00:00
    • 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 00:00
    • 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 00:00
    • 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?

    For Microsoft Excel 2013 certification, you will have to appear for the Microsoft certification exam. To do this, you will need to register for the examination. You would need to register at the Microsoft official website. Once registered, you would need to sign in select your exam and to schedule it with Pearson VUE.

Reviews

Filled in missing gaps in my knowledge. Thank you

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

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

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

Talk to us(toll free)
Drop us a Query
Name *
Email *
Your Query *
Looking for a training for
Myself My team/organization
I agree to be contacted over email
We are looking into your query.
Our consultants will get in touch with you soon.

Request for a custom quote

Please fill in the details and our inhouse support team will get back to you within 1 business day

Name*

Email*

Phone*

Course*
Company
Looking for*
Online license
training
Onsite
training
Online Virtual
training
Please select one of the above
Your Query
I agree to be contacted over mail
Please accept to proceed
/index/hidden/ - Never remove this line