Course Overview

Key Features

  • 11 Hrs of HQ e-learning content
  • 75 modules for better understanding
  • 1 Scenario based Practice Test
  • Course Completion Certificate

Training Options

Self-Paced Learning

$ 149

  • Lifetime access to high-quality self-paced e-learning content curated by industry experts
  • 24x7 learner assistance and support

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Course Content

  • Mastering Microsoft Excel 2010 for MOS

    Preview
    • Mastering Microsoft Excel 2010 for MOS

      10:02:31Preview
      • 1.1 Module 1 Introduction
        00:51
      • 1.2 Module 2 Worksheets and Workbooks
        08:37
      • 1.3 Module 3 Adding and Changing Worksheets
        06:37
      • 1.4 Module 4 Basic Text and Number Entry
        12:57
      • 1.5 Module 5 The Excel Interface, Part 1
        06:34
      • 1.6 Module 6 The Excel Interface, Part 2
        15:01
      • 1.7 Module 7 Keyboard Shortcuts
        10:00
      • 1.8 Module 8 File Types
        09:40
      • 1.9 Module 9 Open, Save, and Autosave
        14:36
      • 1.10 Module 10 Templates
        07:48
      • 1.11 Module 11 Autocorrect
        05:45
      • 1.12 Module 12 Undo and Redo
        04:38
      • 1.13 Module 13 Text Formatting, Part 1
        08:59
      • 1.14 Module 14 Text Formatting, Part 2
        09:23
      • 1.15 Module 15 Adding Hyperlinks
        04:30
      • 1.16 Module 16 Scientific Equations
        06:43
      • 1.17 Module 17 The Windows Clipboard
        12:15
      • 1.18 Module 18 The Office Clipboard
        06:30
      • 1.19 Module 19 Find and Replace
        08:08
      • 1.20 Module 20 Spellcheck and References
        09:10
      • 1.21 Module 21 Shapes
        11:17
      • 1.22 Module 22 Shape, Part 2
        08:40
      • 1.23 Module 23 Pictures
        11:11
      • 1.24 Module 24 Pictures + Shapes
        04:03
      • 1.25 Module 25 Clipart and SmartArt
        10:08
      • 1.26 Module 26 Text Boxes
        06:00
      • 1.27 Module 27 Highlighting and Navigating in a Workbook
        11:51
      • 1.28 Module 28 Insert, Delete, Hide, Unhide
        10:13
      • 1.29 Module 29 Entering Data in a Series
        08:52
      • 1.30 Module 30 Formulas and Order of Operations
        13:02
      • 1.31 Module 31 Intro to Functions
        08:57
      • 1.32 Module 32 Financial Functions
        09:53
      • 1.33 Module 33 Date and Time Functions
        09:06
      • 1.34 Module 34 Text Functions
        09:06
      • 1.35 Module 35 Logical, Math, and Statistical Functions
        08:36
      • 1.36 Module 36 vLookup and Misc Functions
        08:33
      • 1.37 Module 37 Formatting Cells and Ranges
        08:08
      • 1.38 Module 38 Number Formatting
        10:40
      • 1.39 Module 39 Tables
        12:33
      • 1.40 Module 40 Sorting and Filtering
        11:52
      • 1.41 Module 41 Subtotals
        06:34
      • 1.42 Module 42 Pivot Tables
        07:47
      • 1.43 Module 43 Customizing Pivot Tables
        14:33
      • 1.44 Module 44 Importing Data
        08:52
      • 1.45 Module 45 Intro to Charts
        04:25
      • 1.46 Module 46 Choosing The Right Chart
        05:34
      • 1.47 Module 47 Chart Data
        03:47
      • 1.48 Module 48 Advanced Chart Formatting
        11:35
      • 1.49 Module 49 Pivot Charts
        02:56
      • 1.50 Module 50 Sparklines
        05:25
      • 1.51 Module 51 Customizing Your Worksheet View, Part 1
        12:45
      • 1.52 Module 52 Customizing Your Worksheet View, Part 2
        03:49
      • 1.53 Module 53 Advanced Formatting
        07:44
      • 1.54 Module 54 Advanced Data Copy Techniques
        08:33
      • 1.55 Module 55 Transforming Data with the Paste Special
        02:51
      • 1.56 Module 56 Manipulating Text with Functions
        08:34
      • 1.57 Module 57 Printing Worksheets
        11:35
      • 1.58 Module 58 Working with Print Area
        05:27
      • 1.59 Module 59 Print Titles, Headers, and Footers
        09:25
      • 1.60 Module 60 Using Data Validation
        10:32
      • 1.61 Module 61 Analyzing Data with Scenario Manager
        07:24
      • 1.62 Module 62 Analyzing Data with Data Tables
        07:47
      • 1.63 Module 63 Analyzing Data with Solver and Goal Seek
        03:01
      • 1.64 Module 64 Text to Columns
        04:34
      • 1.65 Module 65 Consolidating Data
        03:36
      • 1.66 Module 66 Creating Macros
        08:16
      • 1.67 Module 67 Advanced Macros
        05:55
      • 1.68 Module 68 Custom Series
        06:47
      • 1.69 Module 69 Conditional Formatting, Part 1
        06:13
      • 1.70 Module 70 Conditional Formatting, Part 2
        10:03
      • 1.71 Module 71 External References
        03:54
      • 1.72 Module 72 Exporting and Sharing
        05:31
      • 1.73 Module 73 Comments
        03:53
      • 1.74 Module 74 Customizing the Quick Access Toolbar and Ribbon
        09:29
      • 1.75 Module 75 Conclusion
        02:02

Reviews

  • Alejandro Sosa

    Alejandro Sosa

    Senior Application Developer at JPMorgan Chase & Co.

    The course content is comprehensive, meets industry standards, and is aligned with the market demand. The perfect blend of theory and practical training is amazing.

  • Lily Robinson

    Lily Robinson

    I got a practical overview and how Excel could be applied in complicated data analysis. Highly recommended training

  • Lillian Lewis

    Lillian Lewis

    The course offered me a hands-on and completely different perspective of MS Excel. I didn’t know that I could do so much with Excel. Thank you Simplilearn

  • Brooklyn Walker

    Brooklyn Walker

    The course was more than the basics and covered on how Excel could be used in different cases. Awesome Simplilearn

  • Pavitra Rohatgi

    Pavitra Rohatgi

    IT Change & Release Management at British Telecom

    Good course. The information is very crisp and clear.

prevNext

Why Online Bootcamp

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

FAQs

  • How do I enroll for the Online training?

    You can enroll for the training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
    1. Visa debit/credit card
    2. American express and Diners club card
    3. Master Card, or
    4. Through PayPal

  • What will I get along with this training?

    You will have access to the online e-learning and practice tests along with the training.

  • Can I cancel my enrollment? Do I get a refund?

    Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.

  • Do you provide any course completion certificate?

    Yes, we offer course completion certificate after you successfully complete the training program.

  • Where and how can I access the e-learning content? Are there any limitations?

    Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

  • I am not able to access the online course. Whom should I contact for a solution?

    Please raise a request via our Help and Support portal to have your issue resolved.

  • Do you provide money back guarantee for the training programs?

    Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

  • Do you provide any course completion certificate?

    Yes, we offer course completion certificate after you successfully complete the training program.

  • I want to know more about the training program. Whom do I contact?

    Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.