Quality Seal Emagister EMAGISTER CUM LAUDE

Microsoft® Excel 2013 Intermediate

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

V

19/03/2014
What I would highlight Good faculty; have broad knowledge base and was able to communicate and explain all concepts very well, without even referring to slides . All doubts were explained multiple times aligned with real life examples.

Would you recommend this course? Yes.

What you'll learn on the course

Ms Excel
Excel MS
Intermediate

Course programme

Course Preview
  • Microsoft® Excel® 2013 Intermediate: MOS Certification
    • Lesson 00 - Overview Of MOS Intermediate Course15:36
      • 0.1 Welcome1:8
      • 0.2 Overview Of MOS Intermediate Course1:44
      • 0.3 Table Of Content1:53
      • 0.4 Course Objectives1:27
      • 0.5 Course Overview1:55
      • 0.6 Value Of Excel For Professionals1:38
      • 0.7 Value Of Excel For Organizations1:50
      • 0.8 Lessons Covered1:15
      • 0.9 Exam Pattern1:29
      • 0.10 Microsoft Excel 2013 Mos Intermediate Certification2:29
      • 0.11 Sources Of Information1:19
      • 0.12 Thank You1:11
    • Lesson 01 - Manage And Share Workbooks In Ms Excel 201337:34
      • 1.1 Manage And Share Workbooks In Ms Excel 20131:22
      • 1.2 Objectives1:21
      • 1.3 Share Workbooks1:59
      • 1.4 Shareworkbooks (Contd.)1:42
      • 1.5 Business Scenario1:58
      • 1.6 Demo Summary1:11
      • 1.7 Track Changes3:6
      • 1.8 Highlight Changes And Comments2:13
      • 1.9 Business Scenario3:16
      • 1.10 Demo Summary1:23
      • 1.11 Accept And Reject Changes2:1
      • 1.12 Business Scenario3:38
      • 1.13 Demo Summary1:16
      • 1.14 Formula Errors2:21
      • 1.15 Error Tracing1:55
      • 1.16 Business Scenario2:9
      • 1.17 Demo Summary1:16
      • 1.18 Quiz0:0
      • 1.19 Summary1:59
      • 1.20 Thank You1:11
    • Lesson 02 - Apply Custom Formats and Layouts87:34
      • 2.1 Apply Custom formats and layouts1:28
      • 2.2 Objectives1:28
      • 2.3 Create Custom Conditional formats1:56
      • 2.4 Conditional Formatting Rule Types2:32
      • 2.5 Business Scenario2:48
      • 2.6 Demo Summary1:14
      • 2.7 Formatting cells Using Formulas1:35
      • 2.8 Formatting Celis Using Formulas (contd.)1:31
      • 2.9 Business Scenario4:37
      • 2.10 Demo Summary1:20
      • 2.11 Manage Conditional Format Rules2:13
      • 2.12 Manage conditional format Rules (contd.)1:48
      • 2.13 Business Scenario5:8
      • 2.14 Demo Summary1:21
      • 2.15 Create Advance Filters by Search1:39
      • 2.16 Business Scenario3:12
      • 2.17 Demo Summary1:19
      • 2.18 Create Advance Filters Using Values1:18
      • 2.19 Business Scenario3:57
      • 2.20 Demo Summary1:24
      • 2.21 Create Advance Filters by Colors1:23
      • 2.22 Business Scenario2:4
      • 2.23 Demo Summary1:17
      • 2.24 Modify Worksheets with Accessibility Tools2:8
      • 2.25 Modify Worksheets with Accessibility Tools (Contd.)2:9
      • 2.26 Business Scenario1:57
      • 2.27 Demo Summary1:9
      • 2.28 Display Data in Multiple international Formats1:0
      • 2.29 Business Scenario2:14
      • 2.30 Demo Summary1:19
      • 2.31 Proofing in other languages1:50
      • 2.32 Proofing in Other languages (Contd.)1:38
      • 2.33 Business Scenario3:18
      • 2.34 Demo Summary1:19
      • 2.35 Use international symbols1:50
      • 2.36 Use international Symbols (contd.)1:28
      • 2.37 Business Scenario2:5
      • 2.38 Demo Summary1:17
      • 2.39 Manage body and heading fonts1:48
      • 2.40 Manage body and Heading fonts (contd.)1:24
      • 2.41 Business Scenario3:12
      • 2.42 Demo Summary1:20
      • 2.43 Quiz0:0
      • 2.44 Summary2:9
      • 2.45 Thank You1:11
    • Lesson 03 - Create Advanced Formulas in Excel 2013119:46
      • 3.1 Create Advanced Formulas in Excel 20131:22
      • 3.2 Objectives1:20
      • 3.3 LOOKUP Functions1:48
      • 3.4 VLOOKUP Function1:56
      • 3.5 Syntax Arguments in VLOOKUP Function3:28
      • 3.6 Business Scenario4:5
      • 3.7 Demo Summary1:10
      • 3.8 HLOOKUP Function1:46
      • 3.9 Syntax Arguments in HLOOKUP Function3:11
      • 3.10 Business Scenario3:58
      • 3.11 Demo Summary1:10
      • 3.12 LOOKUP Function2:3
      • 3.13 Syntax Arguments in LOOKUP Function3:6
      • 3.14 Business Scenario3:37
      • 3.15 Demo Summary1:11
      • 3.16 TRANSPOSE Function1:58
      • 3.17 Business Scenario2:58
      • 3.18 Demo Summary1:10
      • 3.19 TODAY and NOW Functions1:41
      • 3.20 Business Scenario2:34
      • 3.21 Demo Summary1:11
      • 3.22 DAY MONTH and YEAR Functions1:0
      • 3.23 Business Scenario3:58
      • 3.24 Demo Summary1:12
      • 3.25 HOUR MINUTE and SECOND Functions2:18
      • 3.26 Business Scenario4:8
      • 3.27 Demo Summary1:10
      • 3.28 DATEVALUE and TIMEVALUE Functions1:50
      • 3.29 Business Scenario3:15
      • 3.30 Demo Summary1:13
      • 3.31 CONCATENATE Function1:56
      • 3.32 WEEKDAY and WEEKNUM Functions1:46
      • 3.33 Syntax Arguments in WEEKDAY and WEEKNUM Function2:9
      • 3.34 Business Scenario4:42
      • 3.35 Demo Summary1:14
      • 3.36 WORKDAY and WORKDAY INTL Functions3:11
      • 3.37 Business Scenario5:23
      • 3.38 Demo Summary1:16
      • 3.39 NETWORKDAYS and NETWORKDAYS INTL Functions2:51
      • 3.40 Business Scenario5:32
      • 3.41 Demo Summary1:27
      • 3.42 Quiz0:0
      • 3.43 Summary2:3
      • 3.44 Thank you1:6
    • Lesson 04 - Create Advanced Charts in Excel 201354:26
      • 4.1 Create Advanced Charts in Excel 20131:26
      • 4.2 Objectives1:23
      • 4.3 Trendlines2:24
      • 4.4 Linear Trendline1:39
      • 4.5 Logarithmic Trendline1:54
      • 4.6 Polynomial Trendline2:7
      • 4.7 Power Trendline1:50
      • 4.8 Exponential Trendline1:45
      • 4.9 Moving Average Trendline2:2
      • 4.10 Business Scenario6:8
      • 4.11 Demo Summary1:21
      • 4.12 Chart Elements2:22
      • 4.13 Filters in Charts1:26
      • 4.14 Dual Axis Charts2:11
      • 4.15 Business Scenario5:9
      • 4.16 Demo Summary1:27
      • 4.17 Create Custom Chart Templates2:16
      • 4.18 Business Scenario3:49
      • 4.19 Demo Summary1:51
      • 4.20 Quiz0:0
      • 4.21 Summary2:7
      • 4.22 Thank You1:6
    • Lesson 05 - Create and Manage PivotTables99:12
      • 5.1 Create and Manage PivotTables1:21
      • 5.2 Objectives1:22
      • 5.3 PivotTables1:0
      • 5.4 Create PivotTables1:55
      • 5.5 Create PivotTables contd2:36
      • 5.6 Create PivotTables contd3:5
      • 5.7 Create PivotTables contd1:28
      • 5.8 Business Scenario3:4
      • 5.9 Demo Summary1:13
      • 5.10 Recommended PivotTables Button1:38
      • 5.11 Business Scenario2:7
      • 5.12 Demo Summary1:12
      • 5.13 Format Pivot tables0:0
      • 5.14 Business Scenario3:18
      • 5.15 Demo Summary1:14
      • 5.16 Modify Field Headers1:52
      • 5.17 Business Scenario3:3
      • 5.18 Demo Summary1:14
      • 5.19 Change the View of Data1:45
      • 5.20 Group Records1:36
      • 5.21 Business Scenario2:59
      • 5.22 Demo Summary1:12
      • 5.23 Calculated Field and Calculated Item1:45
      • 5.24 Calculated Field and Calculated Item contd1:43
      • 5.25 Business Scenario3:44
      • 5.26 Demo Summary1:19
      • 5.27 Slicers2:6
      • 5.28 Slicers contd1:30
      • 5.29 Business Scenario3:10
      • 5.30 Demo Summary1:12
      • 5.31 View Chart Animations1:36
      • 5.32 Business Scenario3:38
      • 5.33 Demo Summary1:15
      • 5.34 Install PowerPivot Add in1:25
      • 5.35 Business Scenario2:12
      • 5.36 Demo Summary1:15
      • 5.37 PowerPivot1:45
      • 5.38 PowerPivot contd1:33
      • 5.39 Business Scenario1:53
      • 5.40 Demo Summary1:9
      • 5.41 PowerPivot Relationships1:53
      • 5.42 Create Relationship between Tables1:17
      • 5.43 Create Relationship between Tables contd2:10
      • 5.44 Business Scenario3:17
      • 5.45 Demo Summary1:15
      • 5.46 Edit and Delete Relationship1:15
      • 5.47 Business Scenario2:55
      • 5.48 Demo Summary1:16
      • 5.49 Create PowerPivot Hierarchy1:34
      • 5.50 Business Scenario2:32
      • 5.51 Demo Summary1:13
      • 5.52 Modify PowerPivot Hierarchy1:54
      • 5.53 Business Scenario1:59
      • 5.54 Demo Summary1:11
      • 5.55 Quiz0:0
      • 5.56 Summary1:57
      • 5.57 Thank You1:4

Additional information

  • What is this course about?

    Microsoft® Excel 2013 Intermediate certification enables the professionals’ to gain proficiency in handling advanced formulas and tools. This certification training helps the users to enhance their skills in function with calculation, graphic tools, pivot tools, converting lists to a table and more. It is ideal for those who are looking to improve their job prospects by adopting Excel 2013 advanced skills and knowledge.


Compare this course with other similar courses
See all