Country

Classroom Training in Woodbridge Change city

Select a convenient batch & Register

Online Classroom

Online classroom

An Instructor led Online Classroom is a live Online classroom where you can interact with your trainer and peers. It is as simple as attending a web meeting.

Watch a Sample Session

May 16 - Jun 07
{Weekend Batch}
Batch Schedule Dates

May

  • Sat
    16
  • Sun
    17
  • Sat
    23
  • Sun
    24
  • Sat
    30
  • Sun
    31

Jun

  • Sat
    06
  • Sun
    07
 
Time
09:00 - 13:00
 
Location
Online Classroom
 
Price
$ 799
 

Can't find convenient schedule? Let us know

 

Online self learning

3 DAYS MONEY BACK GUARANTEE

How this works:

For refund, write to support@simplilearn.com within 3 days of purchase

The mode of reimbursement will be same as the mode of payment used during enrollment fees. For example: If a participant has paid through credit cards, we will reimburse through credit card

Note: Money back guarantee is void if the participant has accessed more than 50% of the course content.


Start Anytime! Anywhere in the world
Access days:
30 Days 180 Days
$180

$200

 

Key Features

  • 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
  • 45 Live Demos
  • High Passrate
  • Downloadable e-Book
  • Video based e-Learning material
  • Course completion certificate
  • 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
  • 45 Live Demos
  • High Passrate
  • Downloadable e-Book
  • Video based e-Learning material
  • Course completion certificate
Specials Offer(s) Available

Flat 30% Off on All Online courses + details Flat 30% Off on All Online courses
Use Coupon: APR30 valid till 30th Apr
Use Coupon:APR30

About Course

Course Preview

    • Lesson 01 - Manage and Share Workbooks 36:2
      • 1.1 Introduction 1:26
      • 1.2 Objectives 1:57
      • 1.21 Business Scenario 1:30
      • 1.22 Demo - Protect Workbooks For Sharing 1:39
      • 1.23 Protect Worksheet Structure 1:52
      • 1.24 Business Scenario 1:32
      • 1.25 Demo - Protect Worksheet Structure 2:1
      • 1.26 Set Tracking Options 2:13
      • 1.27 Business Scenario 1:25
      • 1.29 Restrict Editing And Limiting Editors 1:35
      • 1.3 Modify Workbook Templates 1:31
      • 1.4 - Business Scenario 1:30
      • 1.5 Demo - Modify Workbook Templates 2:27
      • 1.6 Merge Multiple Workbooks 1:52
      • 1.7 Business Scenario 1:30
      • 1.8 Demo - Merge Multiple Workbooks 3:12
      • 1.9 Manage Multiple Versions Of A Workbook 1:45
      • 1.10 Remove Workbook Metadata 1:54
      • 1.11 Copy Styles Between Tables 1:28
      • 1.12 Business Scenario 1:27
      • 1.13 Demo - Copy Styles Between Templates 1:51
      • 1.14 Copy Macros Between Workbooks 1:35
      • 1.15 Business Scenario 1:26
      • 1.16 Demo - Copy Macros Between Workbooks 2:4
      • 1.17 External Data Connections 2:13
      • 1.18 Business Scenario 1:27
      • 1.19 Demo - External Data Connections 3:26
      • 1.30 Business Scenario 1:31
      • 1.31 Demo - Restrict Editing And Limiting Editors 3:1
      • 1.32 Encrypt Workbooks With A Password 1:48
      • 1.33 Business Scenario 1:37
      • 1.34 Demo - Encrypt Workbook With A Password 3:17
      • 1.35 Business Scenario 1:32
      • 1.36 Demo - Mark Workbooks As Final 1:45
      • 1.37 Control Calculations Options 2:2
      • 1.38 Business Scenario 1:30
      • 1.39 Demo - Control Calculations Options 2:27
      • 1.40 - Summary 1:55
      • 1.41 Mark Workbooks As Final 1:49
      • 1.42 Quiz 0:0
    • Lesson 02 - Apply Custom Formats and Layouts 40:1
      • 2.1 Apply Custom Formats and LAyouts 1:25
      • 2.2 Objectives 1:49
      • 2.3 Create Custom Formats (number, Time, Date) 7:14
      • 2.4 Business Scenario 1:25
      • 2.5 Demo - Create Custom Formats Number Date 3:48
      • 2.6 Create Custom Accounting Formats 1:57
      • 2.7 Advanced Fill Series Options 2:56
      • 2.8 Business Scenario 1:32
      • 2.9 Demo - Advanced Fill Series Options 3:1
      • 2.10 Create Custom Templates 2:14
      • 2.11 Create And Modify Cell Styles 1:57
      • 2.12 Business Scenario 1:30
      • 2.13 Demo - Create And Modify Cell Styles 4:6
      • 2.14 Create Custom Color Formats 1:52
      • 2.15 Business Scenario 1:24
      • 2.16 Demo - Create Custom Color Formats 2:46
      • 2.17 Create Custom Font Formats 1:40
      • 2.18 Business Scenario 1:23
      • 2.19 Demo - Create Custom Font Formats 3:41
      • 2.20 Create Themes 1:37
      • 2.21 Business Scenario 1:25
      • 2.22 Demo - Create Themes 2:4
      • 2.23 Create Form Fields 3:50
      • 2.24 Business Scenario 1:29
      • 2.25 Demo - Create Form Fields 4:11
      • 2.26 Control The Tab Order Of Objects 1:56
      • 2.27 Summary 1:49
      • 2.28 Quiz 0:0
    • Lesson 03 - Create Advanced Formulas 51:31
      • 3.1 Introduction 1:26
      • 3.2 Objectives 2:12
      • 3.3 Nested Functions 2:6
      • 3.4 If, And, Or Functions 2:49
      • 3.5 Business Scenario 1:31
      • 3.6 Demo - If And Or Functions 3:38
      • 3.7 Advanced Sumifs Function 2:44
      • 3.8 Business Scenario 1:40
      • 3.9 Demo - Advanced Sumifs Functions 6:55
      • 3.10 Advanced Countifs Function 2:18
      • 3.11 Business Scenario 1:37
      • 3.12 Demo - Advanced Countifs Functions 3:18
      • 3.13 Advanced Averageifs Function 2:17
      • 3.14 Business Scenario 1:36
      • 3.15 Demo - Advanced Averageifs Functions 4:9
      • 3.16 What-if-analysis Tools 2:32
      • 3.17 Watch Window 2:6
      • 3.18 Business Scenario 1:24
      • 3.19 Demo - Utilize Watch Window 2:26
      • 3.20 Goal Seek 1:55
      • 3.21 Business Scenario 1:37
      • 3.22 Demo - Goal Seek 2:10
      • 3.23 Create Scenarios 2:32
      • 3.24 Business Scenario 1:28
      • 3.25 Demo - Create Scenarios 6:27
      • 3.26 Create Data Table 3:32
      • 3.27 Business Scenario 1:25
      • 3.28 Demo - Data Table 1:41
      • 3.29 Consolidate Data 2:39
      • 3.30 Business Scenario 1:27
      • 3.31 Demo - Consolidate Data 1:57
      • 3.32 Financial Functions 3:55
      • 3.33 Summary 2:2
      • 3.34 Quiz 0:0
    • Lesson 04 - Create Advanced Charts and Objects 17:25
      • 4.1 Introduction 1:25
      • 4.2 Objectives 1:31
      • 4.3 Pivotchart 2:32
      • 4.4 Create New Pivotcharts 5:17
      • 4.5 Business Scenario 1:26
      • 4.6 Demo - Create New Pivotcharts 2:32
      • 4.7 Pivotcharts With Animations 1:38
      • 4.8 Business Scenario 1:34
      • 4.9 Pivotcharts With Animations 1:56
      • 4.10 Manipulate Options In Existing Pivotcharts 1:48
      • 4.11 Business Scenario 1:23
      • 4.12 Manipulate Options In Existing Pivotcharts 2:34
      • 4.13 Pivotchart Styles 1:36
      • 4.14 Business Scenario 1:20
      • 4.15 Demo - Pivotcharts Styles 2:22
      • 4.16 Summary 1:31
      • 4.17 Quiz 0:0
    • Lesson 05 - Excel 2013 Advance New Features 24:45
      • 5.1 Introduction 1:24
      • 5.2 Objectives 1:38
      • 5.3 Introduction To Apps For Office 5:17
      • 5.4 Installing Apps From Office Store 1:48
      • 5.5 Business Scenario 1:28
      • 5.6 Demo - Installing Apps From Office Store 2:31
      • 5.7 Inserting And Managing Apps 1:43
      • 5.8 Business Scenario 1:27
      • 5.9 Demo - Inserting And Managing Apps 2:14
      • 5.10 Timeline Filter 2:59
      • 5.11 Business Scenario 1:32
      • 5.12 Demo - Timeline Filter 2:25
      • 5.13 Introduction To Powerview Report 4:47
      • 5.14 Create Powerview Report 1:0
      • 5.15 Business Scenario 1:27
      • 5.16 Demo - Creating Powerview Reports 2:3
      • 5.17 Powerview Reports Options 2:17
      • 5.18 Business Scenario 1:29
      • 5.19 Demo - Powerview Reports Option 1:37
      • 5.20 Summary 1:39
      • 5.21 Quiz 0:0
    • Lesson 06 - Creating Templates with Advanced Functions 39:58
      • 6.1 Introduction 1:24
      • 6.2 Objectives 1:57
      • 6.3 Creating Excel User Defined Templates 2:5
      • 6.4 Business Scenario 1:39
      • 6.5 Demo 1 - Creating Excel User Defined Templates 10:59
      • 6.6 Multiple List Box 1:58
      • 6.7 Business Scenario 1:37
      • 6.8 Demo 2 - Multiple List Box 3:55
      • 6.9 Advanced Validation Rule With Isnumber 1:41
      • 6.10 Business Scenario 1:37
      • 6.11 Demo 3 - Advanced Validation Rule With Isnumber 2:46
      • 6.12 Advanced Validation Rule With Istext 1:38
      • 6.13 Business Scenario 1:35
      • 6.14 Demo 4 - Advanced Validation Rule With Istext 2:12
      • 6.15 Combine Date And Logical Functions 1:36
      • 6.16 Business Scenario 1:43
      • 6.17 Demo 5 - Combine Date And Logical Functions 4:56
      • 6.18 Eomonth Function 2:26
      • 6.19 Business Scenario 1:30
      • 6.20 Demo 6 - Eomonth Function 2:10
      • 6.21 Match Function 4:6
      • 6.22 Business Scenario 1:26
      • 6.23 Match Function 1:37
      • 6.24 Business Scenario 1:30
      • 6.25 Index With Match Function 2:12
      • 6.26 ndex With Match Function 1:55
      • 6.27 Summary 1:48
  • 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’s training in Microsoft® Excel 2013 advanced certification provides the following benefits:
    • Training for Microsoft® 77-428 exam
    • 18 end of chapter quizzes
    • 3 Microsoft Excel 2013 Simulation Exams
    • Video based e-Learning material
    • 6 hours of High Quality e-Learning content
    • 45 Industry based examples
    • 45 Live Demos
    • Downloadable eBook
    • Course completion certificate
    Additionally, Simplilearn’s training is the best because:
    • We are an accredited, approved and recognized training partner by globally renowned names like Project Management Institute of USA, APMG, CFA Institute, GARP, ASTQB, IIBA and more.
    • We have a network of over 2000 certified and experienced trainers.
    • 40% of our participants receiving our training are from fortune 500 companies.
    • Our exam passing rate is 98.6% and we guarantee passing the exam in your first attempt.
    • Our training packages have attractive discounts and money back guarantee.

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.

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.

  • 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 send an email to support@simplilearn.com. You can also chat with us to get an instant solution.

  • Do you provide money back guarantee for the training programs?

    Yes, we do provide money back guarantee for some of our training programs. You can contact support@simplilearn.com for more information.

  • Do you provide any course completion certificate?

    Yes, we offer course completion certificate after you successfully complete the training program.

Reviews

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.

Drop us a Query
Name *
Email *
Your Query *
Looking for a training for
Myself My team/organization
I agree to be contacted over email
1800-232-5454(9am-7pm)
We are looking into your query.
Our consultants will get in touch with you soon.
 
Group Buy

corporatesales@simplilearn.com

Knowledge Bank

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