Curriculum
- 6 Sections
- 95 Lessons
- 2 Days
Expand all sectionsCollapse all sections
- Lesson 00 – Overview Of MOS Intermediate Course12
- 1.10.2 Overview Of MOS Intermediate Course
- 1.20.3 Table Of Content
- 1.30.5 Course Overview
- 1.40.4 Course Objectives
- 1.50.6 Value Of Excel For Professionals
- 1.60.1 Welcome
- 1.70.8 Lessons Covered
- 1.80.7 Value Of Excel For Organizations
- 1.90.9 Exam Pattern
- 1.100.10 Microsoft Excel 2013 Mos Intermediate Certification
- 1.110.11 Sources Of Information
- 1.120.12 Thank You
- Lesson 01 – Manage And Share Workbooks In Ms Excel 201320
- 2.11.2 Objectives
- 2.21.1 Manage And Share Workbooks In Ms Excel 2013
- 2.31.4 Share workbooks (Contd.)
- 2.41.3 Share Workbooks
- 2.51.5 Business Scenario
- 2.61.6 Demo Summary
- 2.71.7 Track Changes
- 2.81.8 Highlight Changes And Comments
- 2.91.9 Business Scenario
- 2.101.10 Demo Summary
- 2.111.11 Accept And Reject Changes
- 2.121.12 Business Scenario
- 2.131.13 Demo Summary
- 2.141.14 Formula Errors
- 2.151.15 Error Tracing
- 2.161.16 Business Scenario
- 2.171.17 Demo Summary
- 2.181.18 Quiz
- 2.191.19 Summary
- 2.201.20 Thank You
- Lesson 02 – Apply Custom Formats and Layouts46
- 3.12.1 Apply Custom formats and layouts
- 3.22.2 Objectives
- 3.32.3 Create Custom Conditional formats
- 3.42.5 Business Scenario
- 3.52.4 Conditional Formatting Rule Types
- 3.62.7 Formatting cells Using Formulas
- 3.72.11 Manage Conditional Format Rules
- 3.82.8 Formatting Celis Using Formulas (contd.)
- 3.92.12 Manage conditional format Rules (contd.)
- 3.102.15 Create Advance Filters by Search
- 3.112.10 Demo Summary
- 3.122.11 Manage Conditional Format Rules
- 3.132.13 Business Scenario
- 3.142.14 Demo Summary
- 3.152.16 Business Scenario
- 3.162.17 Demo Summary
- 3.172.20 Demo Summary
- 3.182.18 Create Advance Filters Using Values
- 3.192.19 Business Scenario
- 3.202.23 Demo Summary
- 3.212.22 Business Scenario
- 3.222.21 Create Advance Filters by Colors
- 3.232.25 Modify Worksheets with Accessibility Tools (Contd.)
- 3.242.26 Business Scenario
- 3.252.24 Modify Worksheets with Accessibility Tools
- 3.262.27 Demo Summary
- 3.272.28 Display Data in Multiple international Formats
- 3.282.29 Business Scenario
- 3.292.30 Demo Summary
- 3.302.31 Proofing in other languages
- 3.312.32 Proofing in Other languages (Contd.)
- 3.322.33 Business Scenario
- 3.332.34 Demo Summary
- 3.342.35 Use international symbols
- 3.352.36 Use international Symbols (contd.)
- 3.362.34 Demo Summary
- 3.372.37 Business Scenario
- 3.382.35 Use international symbols
- 3.392.38 Demo Summary
- 3.402.39 Manage body and heading fonts
- 3.412.40 Manage body and Heading fonts (contd.)
- 3.422.41 Business Scenario
- 3.432.42 Demo Summary
- 3.442.43 Quiz
- 3.452.44 Summary
- 3.462.45 Thank You
- Lesson 03 – Create Advanced Formulas in Excel 201317
- 4.13.1 Create Advanced Formulas in Excel 2013
- 4.23.2 Objectives
- 4.33.3 LOOKUP Functions
- 4.43.4 VLOOKUP Function
- 4.53.5 Syntax Arguments in VLOOKUP Function
- 4.63.6 Business Scenario
- 4.73.7 Demo Summary
- 4.83.8 HLOOKUP Function
- 4.93.9 Syntax Arguments in HLOOKUP Function
- 4.103.10 Business Scenario
- 4.113.11 Demo Summary
- 4.123.12 LOOKUP Function
- 4.133.16 TRANSPOSE Function
- 4.143.15 Demo Summary
- 4.153.14 Business Scenario
- 4.163.17 Business Scenario
- 4.173.18 Demo Summary
- Lesson 04 – Create Advanced Charts in Excel 20130
- Lesson 05 – Create and Manage PivotTables0