BETA

Believe in yourself and you can do unbelievable things.

MS Excel Intermediate

Home MS Office MS Excel Intermediate

  • OVERVIEW:

     

    Enroll the EXCEL INTERMEDIATE Level Course for a strong knowledge and skills so that you can excel in your career with ease.

    Excel can be a complex and confusing program to use, but this course breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel or spreadsheets is required to get the most out of this excel beginners to intermediate level course

     

    OBJECTIVES:

     

    To be able to work and do basic accounting and reporting through excel, applying formulas, sorting, filtering, and creating charts and pivots.

     

    TARGET AUDIENCE:

     

    Ideal for professionals and college students

     

    ELIGIBILITY:

     

    Operating knowledge of computers, basic idea about the purpose of MS EXCEL and how to use internet.

     

     

    PRE-REQUISITES:

     

    • PC/Laptop,
    • Microsoft Excel 2007 and above
    • Internet connection

     

  • COURSE STRUCTURE:

     

     

    LESSON 1:  Basics review                                                                                                                                         1 hour

     

    • Basic formulas
    • Keyboard Shortcuts

     

    LESSON 2: Addressing Method                                                                                                                                  1 hour

     

    • Absolute referencing
    • Mixed Referencing

     

    LESSON 3. Conditional Functions                                                                                                                              1 hour

     

    • Benefits And Purpose
    • IF Statements
    • Nested If
    • SUMIF
    • AVERAGEIF
    • COUNTIF
    • IFERROR

     

    LESSON 4: Lookup Functions                                                                                                                             30 minutes

     

    • Vertical Lookup (Vlookup)
    • Horizontal Lookup (Hlookup)

     

    LESSON 5: Applying and Managing Conditional Formatting                                                                              30 minutes

     

    • Applying Rules
    • Data Bars
    • Color Scales
    • Icon Sets
    • Top/Bottom

     

    LESSON 6: Working with Dates                                                                                                                                 1 hour

     

    • Getting current date & Time
    • Date difference
    • Formatting dates
    • Working with Text
    • Changing text cases
    • Extracting required characters
    • Concatenation
    • Removing extra spaces

     

    LESSON 7: Charts/Graphs Advanced Techniques                                                                                                      1 hour

     

    • Creating Chart Using Shortcut Keys
    • Saving Custom Chart as Templates
    • Setting Chart as Default
    • Applying Trendlines
    • Formatting and Editing Series, Plot Area, Data Points Chart Area, legends, etc

     

     

    LESSON 8: Summarizing Data with Pivot Tables                                                                                                       1 hour

     

    • Inserting calculated fields
    • Manipulating Fields
    • Changing Value Filed Settings
    • Using Report Filter
    • Grouping Data containing Dates and Numbers
    • Formatting Pivot Table
    • Showing and Hiding the Grand Totals
    • Refreshing Data In Pivot Table
    • Changing The Scope Of The Data source
    • Summarizing Values by Sum, Count, Average, Max, and Product
    • Show Values As % of Grand Total, % of Column Total, % of Row Total
    • Pivot Table Options
    • Pivot Chart

     

    Tips & Tricks to use Excel efficiently

  • Below mentioned training methodologies will be adopted while training:

     

    • Pre & Post Assessment
      • Objective and fair assessment of trainees post training
      • Demarcation between Theory and In class Practicals
      • Be as much interactive as possible
      • Encourage participants to share their ”burning questions” about the topic
      • Launching a poll question for participants to answer
      • Try to explain using famous models and studies
      • Incorporate Case based learning (case videos/ movies) and storytelling, if applicable
      • Integrate soft skills in the training, if applicable
      • Motivate learners to apply concepts from domain subjects in a real world situation
      • Practical Home work
      • Provision of skill Certification information to trainees, wherever applied and required
      • Encourage regular trainee interaction during , in-between and after the course
      • Aim to design a module that engages participants every 4 minutes
      • Encourage participants to use platform tools like Poll, Chat, Raise Hand, Screen Sharing etc.
      • Provision of learning/ reference material to the trainees
      • Regular post session response to the trainees
      • Record of participation and Certificate of achievement issued by EduSmart Skills
  • Frequently Asked Questions about MS Excel Intermediate

    You will be able to work with all the basic formulas, formatting charts, pivots and will be able to generate reports and logically visualize end results in excel.

    Everything will be explained through Live examples, the structure of the course takes you through the contents one at a time. There will be practice questions for you to attempt at the end of each topic.

    Yes, you will get an elaborate handout with theoretical answers.

    Understanding about what excel is and what it do.

    The sessions will be interactive and you can ask as many questions you want.

  • EDUSMART SKILLS CERTIFICATION

     

    The entire training course content is in line with respective certification program and helps you clear the requisite exams with ease and get the best jobs in the top MNCs.

    As part of this training you will be working on the assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.

    During the program there will be assessments that perfectly reflect the type of questions asked in the exams and helps you score better.

    EduSmart Skills Course Completion certificate will be awarded on the completion of course.

  • Students Reviews for MS Excel Intermediate