Curriculum
- 6 Sections
- 95 Lessons
- 2 Days
Expand all sectionsCollapse all sections
- Lesson 00 – Overview Of MOS Intermediate Course12
- 1.00.2 Overview Of MOS Intermediate Course
- 1.10.3 Table Of Content
- 1.20.5 Course Overview
- 1.30.4 Course Objectives
- 1.40.6 Value Of Excel For Professionals
- 1.50.1 Welcome
- 1.60.8 Lessons Covered
- 1.70.7 Value Of Excel For Organizations
- 1.80.9 Exam Pattern
- 1.90.10 Microsoft Excel 2013 Mos Intermediate Certification
- 1.100.11 Sources Of Information
- 1.110.12 Thank You
- Lesson 01 – Manage And Share Workbooks In Ms Excel 201320
- 2.01.2 Objectives
- 2.11.1 Manage And Share Workbooks In Ms Excel 2013
- 2.21.4 Share workbooks (Contd.)
- 2.31.3 Share Workbooks
- 2.41.5 Business Scenario
- 2.51.6 Demo Summary
- 2.61.7 Track Changes
- 2.71.8 Highlight Changes And Comments
- 2.81.9 Business Scenario
- 2.91.10 Demo Summary
- 2.101.11 Accept And Reject Changes
- 2.111.12 Business Scenario
- 2.121.13 Demo Summary
- 2.131.14 Formula Errors
- 2.141.15 Error Tracing
- 2.151.16 Business Scenario
- 2.161.17 Demo Summary
- 2.171.18 Quiz
- 2.181.19 Summary
- 2.191.20 Thank You
- Lesson 02 – Apply Custom Formats and Layouts46
- 3.02.1 Apply Custom formats and layouts
- 3.12.2 Objectives
- 3.22.3 Create Custom Conditional formats
- 3.32.5 Business Scenario
- 3.42.4 Conditional Formatting Rule Types
- 3.52.7 Formatting cells Using Formulas
- 3.62.11 Manage Conditional Format Rules
- 3.72.8 Formatting Celis Using Formulas (contd.)
- 3.82.12 Manage conditional format Rules (contd.)
- 3.92.15 Create Advance Filters by Search
- 3.102.10 Demo Summary
- 3.112.11 Manage Conditional Format Rules
- 3.122.13 Business Scenario
- 3.132.14 Demo Summary
- 3.142.16 Business Scenario
- 3.152.17 Demo Summary
- 3.162.20 Demo Summary
- 3.172.18 Create Advance Filters Using Values
- 3.182.19 Business Scenario
- 3.192.23 Demo Summary
- 3.202.22 Business Scenario
- 3.212.21 Create Advance Filters by Colors
- 3.222.25 Modify Worksheets with Accessibility Tools (Contd.)
- 3.232.26 Business Scenario
- 3.242.24 Modify Worksheets with Accessibility Tools
- 3.252.27 Demo Summary
- 3.262.28 Display Data in Multiple international Formats
- 3.272.29 Business Scenario
- 3.282.30 Demo Summary
- 3.292.31 Proofing in other languages
- 3.302.32 Proofing in Other languages (Contd.)
- 3.312.33 Business Scenario
- 3.322.34 Demo Summary
- 3.332.35 Use international symbols
- 3.342.36 Use international Symbols (contd.)
- 3.352.34 Demo Summary
- 3.362.37 Business Scenario
- 3.372.35 Use international symbols
- 3.382.38 Demo Summary
- 3.392.39 Manage body and heading fonts
- 3.402.40 Manage body and Heading fonts (contd.)
- 3.412.41 Business Scenario
- 3.422.42 Demo Summary
- 3.432.43 Quiz
- 3.442.44 Summary
- 3.452.45 Thank You
- Lesson 03 – Create Advanced Formulas in Excel 201317
- 4.03.1 Create Advanced Formulas in Excel 2013
- 4.13.2 Objectives
- 4.23.3 LOOKUP Functions
- 4.33.4 VLOOKUP Function
- 4.43.5 Syntax Arguments in VLOOKUP Function
- 4.53.6 Business Scenario
- 4.63.7 Demo Summary
- 4.73.8 HLOOKUP Function
- 4.83.9 Syntax Arguments in HLOOKUP Function
- 4.93.10 Business Scenario
- 4.103.11 Demo Summary
- 4.113.12 LOOKUP Function
- 4.123.16 TRANSPOSE Function
- 4.133.15 Demo Summary
- 4.143.14 Business Scenario
- 4.153.17 Business Scenario
- 4.153.18 Demo Summary
- Lesson 04 – Create Advanced Charts in Excel 20130
- Lesson 05 – Create and Manage PivotTables0
0.3 Table Of Content
Next