Microsoft Office Specialist Excel Training and Certification Program - Batch 5

  • Online Live Training with practical hands-on guidance
  • Microsoft Digital Badging (to enhance your LinkedIn profile, Resume etc..)
  • Training program led by Microsoft Education Partners.
  • Microsoft Global Certification
Course Fee : ₹5000.00/-

Course Curriculum

Topic

Sub-topics

Manage Workbook Options and Settings

February 12

  1. Create Worksheets and Workbooks

  2. Navigate in Worksheets and Workbook

  3. Format Worksheets and Workbook

  4. Customize Options and Views for Worksheets and Workbooks

  5. Configure Worksheets and Workbooks for Distribution

Custom Data Formats and Layouts

February 13

  1. Apply Custom Data Formats and Validation

  2. Apply Advanced Conditional Formatting and Filtering

  3. Create and Modify Custom Workbook Element

  4. Prepare a Workbook for Internationalization

Tables

February 14

  1. Create and Manage Table

  2. Manage Table Styles and Option

  3. Filter and Sort a Table

Operations with Formulas and Functions

February 16

  1. Summarize Data by using Functions

  2. Perform Conditional Operations by using Functions

  3. Format and Modify Text by using Functions

Charts and Objects

February 19

  1. Create Charts

  2. Format Charts

  3. Insert and Format Objects

Workbook Options and Settings

February 20

  1. Manage Workbooks

  2. Manage Workbook Review Restrict editing

Custom Data Formats and Layouts

February 21

  1. Apply Custom Data Formats and Validation

  2. Apply Advanced Conditional Formatting and Filtering

  3. Create and Modify Custom Workbook Elements

  4. Prepare a Workbook for Internationalization

Advanced Formulas

February 22

  1. Apply Functions in Formulas

  2. Look up data by using Functions

  3. Apply Advanced Date and Time Functions

  4. Perform Data Analysis and Business Intelligence

  5. Troubleshoot Formulas

  6. Define Named Ranges and Objects

Advanced Charts and Tables

February 23

  1. Create Advanced Charts

  2. Create and Manage PivotTables

  3. Create and Manage Pivot Charts

Financial functions, Data analysis and Business Intelligence

February 26

  1. Perform calculations by using the pmt , ipmt and ppmt functions
  2. Import , Transform , Combine , Display , and Connect  to data
  3. Data Consolidation
  4. Perform What-if-analysis by using Goal seek , Scenerio Manager and data table.
     
Exam Orientation and Exam Registration

February 27

  1. Familiarizing the students with the exam format , including the types of questions , time limits , and scoring system 
  2. Solving past exam papers with the assistance of the trainer.
  3. Make the students to involve in a series of steps that they need to follow in order to sign up for the Microsoft Office Specialist Examination.

About the course

Our program stands out by offering a unique chance to learn and obtain certification from top experts. Our Microsoft Excel Program is supported by  "Microsoft Authorized Education Partner" company with highly skilled and experienced Microsoft Certified Trainers who possess comprehensive knowledge of Excel. They also provide Microsoft Office Specialist Exam Vouchers for this program. The program consists of 18 hours online live training sessions, creating a dynamic and interactive learning environment. Through practical hands-on instruction, you can apply your knowledge to real-world situations. We prioritize not only theoretical understanding but also practical skills development, enabling you to excel in your professional pursuits. Upon program completion, you will have the opportunity to take the Microsoft Global Examination, which evaluates your Excel proficiency and validates your skills. Attaining the Microsoft Global Certification will give you a competitive advantage in the job market and open doors to exciting career prospects. Additionally, you will have the chance to earn the prestigious Digital Badge.

Eligibility

Individuals desiring to acquire comprehensive skills in the Microsoft Excel Application and obtain Microsoft Certification are welcome.

Requirements

  • A reliable internet connection is necessary.
  • Students must possess a laptop or PC for participating in classes, fulfilling project requirements, and taking remote exams.

Class Timings

Date : 12th February 2024 - 27th February 2024
[11 Days]

Time : 8:30 PM to 10:30 PM IST

Knowledge Partner