BASIC AND INTERMEDIATE EXCEL TRAINING
Basic And Intermediate Excel Training enables professionals to learn to handle advanced formulas and tools. This certification training helps the users enhance their function skills with calculation, graphic tools, pivot tools, converting lists to a table and more.
Overview
Curriculum
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
FAQs
MS Excel Intermediate training program is ideal for-
Candidates who are interested in extending their knowledge and understanding of Microsoft excel.
Professionals who use Microsoft Excel to perform daily activities.
Professionals working in marketing, accounting and is also best suited for pricing analysts and business analysts.
Exam Type: Closed book, Multiple choice, multiple responses, matching, hotspot, etc.
No Of Questions: 180 questions per paper, 175 scored
Exam duration: 230 Minutes
Result: The passing score is determined through psychometric analysis
Reviews
Features
- JK Michaels is a PMI accredited ATP(Authorized Training Partner)
- Earn 30 PDUs with Practical, live instructor led sessions
- Ace the exam with 30 day, 60 day study plan by experts 2000 Free exam simulation question bank
- Introduction to predictive and Agile software(microsoft project +JIRA) Poject Leadership Quotients Assessment
- Regular monthly webinars,revisions and exam support.
- Action-oriented learning through case studies,role plays ,games e.t.c