Quality Seal Emagister EMAGISTER CUM LAUDE

Microsoft® Excel 2013-Advanced

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Online
Description

Simplilearn is the World’s Largest Certification Training Provider, with over 400,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.

Important information

Opinions

A

26/03/2014
What I would highlight An excellent primer and deep dive to the scrum master role. The course has helped me gain strong understanding on the agile methodologies.

Would you recommend this course? Yes.

What you'll learn on the course

Advanced
Excel MS
Ms Excel

Course programme

Course Preview
  • Microsoft® Excel 2013 Advanced: MOS Certification (Exam – 77-428)
    • Lesson 01 - Manage and Share Workbooks71:4
      • 1.1 Introduction1:26
      • 1.2 Objectives1:57
      • 1.21 Business Scenario1:30
      • 1.22 Demo - Protect Workbooks For Sharing1:39
      • 1.23 Protect Worksheet Structure1:52
      • 1.24 Business Scenario1:32
      • 1.25 Demo - Protect Worksheet Structure2:1
      • 1.26 Set Tracking Options2:13
      • 1.27 Business Scenario1:25
      • 1.29 Restrict Editing And Limiting Editors1:35
      • 1.3 Modify Workbook Templates1:31
      • 1.4 - Business Scenario1:30
      • 1.5 Demo - Modify Workbook Templates2:27
      • 1.6 Merge Multiple Workbooks1:52
      • 1.7 Business Scenario1:30
      • 1.8 Demo - Merge Multiple Workbooks3:12
      • 1.9 Manage Multiple Versions Of A Workbook1:45
      • 1.10 Remove Workbook Metadata1:54
      • 1.11 Copy Styles Between Tables1:28
      • 1.12 Business Scenario1:27
      • 1.13 Demo - Copy Styles Between Templates1:51
      • 1.14 Copy Macros Between Workbooks1:35
      • 1.15 Business Scenario1:26
      • 1.16 Demo - Copy Macros Between Workbooks2:4
      • 1.17 External Data Connections2:13
      • 1.18 Business Scenario1:27
      • 1.19 Demo - External Data Connections3:26
      • 1.30 Business Scenario1:31
      • 1.31 Demo - Restrict Editing And Limiting Editors3:1
      • 1.32 Encrypt Workbooks With A Password1:48
      • 1.33 Business Scenario1:37
      • 1.34 Demo - Encrypt Workbook With A Password3:17
      • 1.35 Business Scenario1:32
      • 1.36 Demo - Mark Workbooks As Final1:45
      • 1.37 Control Calculations Options2:2
      • 1.38 Business Scenario1:30
      • 1.39 Demo - Control Calculations Options2:27
      • 1.40 - Summary1:55
      • 1.41 Mark Workbooks As Final1:49
      • 1.42 Quiz0:0
    • Lesson 02 - Apply Custom Formats and Layouts79:2
      • 2.1 Apply Custom Formats and LAyouts1:25
      • 2.2 Objectives1:49
      • 2.3 Create Custom Formats (number, Time, Date)7:14
      • 2.4 Business Scenario1:25
      • 2.5 Demo - Create Custom Formats Number Date3:48
      • 2.6 Create Custom Accounting Formats1:57
      • 2.7 Advanced Fill Series Options2:56
      • 2.8 Business Scenario1:32
      • 2.9 Demo - Advanced Fill Series Options3:1
      • 2.10 Create Custom Templates2:14
      • 2.11 Create And Modify Cell Styles1:57
      • 2.12 Business Scenario1:30
      • 2.13 Demo - Create And Modify Cell Styles4:6
      • 2.14 Create Custom Color Formats1:52
      • 2.15 Business Scenario1:24
      • 2.16 Demo - Create Custom Color Formats2:46
      • 2.17 Create Custom Font Formats1:40
      • 2.18 Business Scenario1:23
      • 2.19 Demo - Create Custom Font Formats3:41
      • 2.20 Create Themes1:37
      • 2.21 Business Scenario1:25
      • 2.22 Demo - Create Themes2:4
      • 2.23 Create Form Fields3:50
      • 2.24 Business Scenario1:29
      • 2.25 Demo - Create Form Fields4:11
      • 2.26 Control The Tab Order Of Objects1:56
      • 2.27 Summary1:49
      • 2.28 Quiz0:0
    • Lesson 03 - Create Advanced Formulas102:2
      • 3.1 Introduction1:26
      • 3.2 Objectives2:12
      • 3.3 Nested Functions2:6
      • 3.4 If, And, Or Functions2:49
      • 3.5 Business Scenario1:31
      • 3.6 Demo - If And Or Functions3:38
      • 3.7 Advanced Sumifs Function2:44
      • 3.8 Business Scenario1:40
      • 3.9 Demo - Advanced Sumifs Functions6:55
      • 3.10 Advanced Countifs Function2:18
      • 3.11 Business Scenario1:37
      • 3.12 Demo - Advanced Countifs Functions3:18
      • 3.13 Advanced Averageifs Function2:17
      • 3.14 Business Scenario1:36
      • 3.15 Demo - Advanced Averageifs Functions4:9
      • 3.16 What-if-analysis Tools2:32
      • 3.17 Watch Window2:6
      • 3.18 Business Scenario1:24
      • 3.19 Demo - Utilize Watch Window2:26
      • 3.20 Goal Seek1:55
      • 3.21 Business Scenario1:37
      • 3.22 Demo - Goal Seek2:10
      • 3.23 Create Scenarios2:32
      • 3.24 Business Scenario1:28
      • 3.25 Demo - Create Scenarios6:27
      • 3.26 Create Data Table3:32
      • 3.27 Business Scenario1:25
      • 3.28 Demo - Data Table1:41
      • 3.29 Consolidate Data2:39
      • 3.30 Business Scenario1:27
      • 3.31 Demo - Consolidate Data1:57
      • 3.32 Financial Functions3:55
      • 3.33 Summary2:2
      • 3.34 Quiz0:0
    • Lesson 04 - Create Advanced Charts and Objects33:50
      • 4.1 Introduction1:25
      • 4.2 Objectives1:31
      • 4.3 Pivotchart2:32
      • 4.4 Create New Pivotcharts5:17
      • 4.5 Business Scenario1:26
      • 4.6 Demo - Create New Pivotcharts2:32
      • 4.7 Pivotcharts With Animations1:38
      • 4.8 Business Scenario1:34
      • 4.9 Pivotcharts With Animations1:56
      • 4.10 Manipulate Options In Existing Pivotcharts1:48
      • 4.11 Business Scenario1:23
      • 4.12 Manipulate Options In Existing Pivotcharts2:34
      • 4.13 Pivotchart Styles1:36
      • 4.14 Business Scenario1:20
      • 4.15 Demo - Pivotcharts Styles2:22
      • 4.16 Summary1:31
      • 4.17 Quiz0:0
    • Lesson 05 - Excel 2013 Advance New Features48:30
      • 5.1 Introduction1:24
      • 5.2 Objectives1:38
      • 5.3 Introduction To Apps For Office5:17
      • 5.4 Installing Apps From Office Store1:48
      • 5.5 Business Scenario1:28
      • 5.6 Demo - Installing Apps From Office Store2:31
      • 5.7 Inserting And Managing Apps1:43
      • 5.8 Business Scenario1:27
      • 5.9 Demo - Inserting And Managing Apps2:14
      • 5.10 Timeline Filter2:59
      • 5.11 Business Scenario1:32
      • 5.12 Demo - Timeline Filter2:25
      • 5.13 Introduction To Powerview Report4:47
      • 5.14 Create Powerview Report1:0
      • 5.15 Business Scenario1:27
      • 5.16 Demo - Creating Powerview Reports2:3
      • 5.17 Powerview Reports Options2:17
      • 5.18 Business Scenario1:29
      • 5.19 Demo - Powerview Reports Option1:37
      • 5.20 Summary1:39
      • 5.21 Quiz0:0
    • Lesson 06 - Creating Templates with Advanced Functions78:56
      • 6.1 Introduction1:24
      • 6.2 Objectives1:57
      • 6.3 Creating Excel User Defined Templates2:5
      • 6.4 Business Scenario1:39
      • 6.5 Demo 1 - Creating Excel User Defined Templates10:59
      • 6.6 Multiple List Box1:58
      • 6.7 Business Scenario1:37
      • 6.8 Demo 2 - Multiple List Box3:55
      • 6.9 Advanced Validation Rule With Isnumber1:41
      • 6.10 Business Scenario1:37
      • 6.11 Demo 3 - Advanced Validation Rule With Isnumber2:46
      • 6.12 Advanced Validation Rule With Istext1:38
      • 6.13 Business Scenario1:35
      • 6.14 Demo 4 - Advanced Validation Rule With Istext2:12
      • 6.15 Combine Date And Logical Functions1:36
      • 6.16 Business Scenario1:43
      • 6.17 Demo 5 - Combine Date And Logical Functions4:56
      • 6.18 Eomonth Function2:26
      • 6.19 Business Scenario1:30
      • 6.20 Demo 6 - Eomonth Function2:10
      • 6.21 Match Function4:6
      • 6.22 Business Scenario1:26
      • 6.23 Match Function1:37
      • 6.24 Business Scenario1:30
      • 6.25 Index With Match Function2:12
      • 6.26 ndex With Match Function1:55
      • 6.27 Summary1:48

Additional information

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


Compare this course with other similar courses
See all