BETA

Believe in yourself and you can do unbelievable things.

MS Excel Basic

Home MS Office MS Excel Basic

  • OVERVIEW:

     

    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 basic beginners level course.

     

    DURATION:

     

    9 hours

     

    OBJECTIVES:

     

    To be able to work and do basic calculations and data formation through excel, applying basic formulas, sorting, filtering, and creating charts and pivots.

     

    TARGET AUDIENCE:

     

    Ideal for school students

     

    ELIGIBILITY:

     

    Those who have basic operating knowledge of computers.

     

     

    PRE-REQUISITES:

     

    • PC/Laptop,
    • Microsoft Excel 2007 and above, Internet connection(for online classes)

     

  • COURSE STRUCTURE:

     

     

    LESSON 1:  Basics review                                                                                                                                         1 hour

     

    • Overview of Excel
    • Sheets, Workbooks, Cell, Row, Column
    • Basic formulas
    • Keyboard Shortcuts

     

    LESSON 2: Addressing Method                                                                                                                                  1 hour

     

    • Absolute referencing
    • Mixed Referencing

     

    LESSON 3. Conditional Functions                                                                                                                              2 hour

     

    • Benefits And Purpose
    • IF Statements
    • COUNTIF

     

    LESSON 4: Lookup Functions                                                                                                                                    1 hour

     

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

     

    LESSON 5: Applying and Managing Conditional Formatting                                                                                     1 hour

     

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

     

    LESSON 6: Working with Dates                                                                                                                          30 minutes

     

    • Getting current date & Time
    • Formatting dates

     

    LESSON 7: Working with Text                                                                                                                            30 minutes

     

    • Changing text cases
    • Extracting required characters
    • Concatenation
    • Removing extra spaces

     

     

    LESSON 8: Charts/Graphs                                                                                                                                          1 hour

     

    • Creating Chart
    • Formatting and Editing Series, Plot Area, Data Points Chart Area, legends, etc...

     

    LESSON 9: Pivot Tables                                                                                                                                          1.5 hour

     

    • Introduction to Pivot
    • 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 Basic

    You will be able to work with all the basic formulas, create charts, pivots and perform basic functions 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 worksheets with theoretical answers.

    You should have be comfortable with typing along with basic knowledge of computers.

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

    We can customize the course in your desired time frame. Please contact our customer service team for details

    We would be happy to develop a course to meet your requirements.

    If you are aware of the classes or dates you may be missing, please inform the trainer in advance and we will be happy to reschedule it for you or provide you alternate options.

    Edusmart Skills is an online education platform and has no engagement in the job placement. However, our trainers will be glad to guide you in the right direction.

  • 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 Basic