Key features

MONEY BACK GUARANTEE

How this works :

At Simplilearn, we greatly value the trust of our patrons. Our courses were designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Self Placed Learning :

Raise refund request within 7 days of purchase of course. Money back guarantee is void if the participant has accessed more than 25% content.

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

Course description

  • What is this course about?

    Microsoft® Excel 2010 training enables professionals to gain proficiency in handling MS Excel tools and applications. MS Excel 2010 is a spreadsheet application distributed by Microsoft. Microsoft Excel 2010 enables users to function with calculation, graphic tools, pivot tools and macro programming language. MS Excel 2010 is the current version of this application for Microsoft windows. MS Excel 2010 Training is an end user course that will enable you to understand the complete capabilities of Microsoft Excel 2010 – the de facto standard in spreadsheet software.

  • Why Simplilearn?

    • Simplilearn is the World’s Largest Certification Training Provider, with over 500,000+ professionals trained globally
    • Trusted by the Fortune 500 companies as their learning provider for career growth and training
    • 2000+ certified and experienced trainers conduct trainings for various courses across the globe
    • All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt
    • Accredited, Approved and Recognized as a training organization, partner, education provider and examination center by globally renowned names like Project Management Institute of USA, APMG, CFA Institute, GARP, ASTQB, IIBA and others

Course preview

    • Mastering Microsoft Excel 2010 for MOS 10:02:31
      • 1.1 Module 1 Introduction00:51
      • 1.2 Module 2 Worksheets and Workbooks08:37
      • 1.3 Module 3 Adding and Changing Worksheets06:37
      • 1.4 Module 4 Basic Text and Number Entry12:57
      • 1.5 Module 5 The Excel Interface, Part 106:34
      • 1.6 Module 6 The Excel Interface, Part 215:01
      • 1.7 Module 7 Keyboard Shortcuts10:00
      • 1.8 Module 8 File Types09:40
      • 1.9 Module 9 Open, Save, and Autosave14:36
      • 1.10 Module 10 Templates07:48
      • 1.11 Module 11 Autocorrect05:45
      • 1.12 Module 12 Undo and Redo04:38
      • 1.13 Module 13 Text Formatting, Part 108:59
      • 1.14 Module 14 Text Formatting, Part 209:23
      • 1.15 Module 15 Adding Hyperlinks04:30
      • 1.16 Module 16 Scientific Equations06:43
      • 1.17 Module 17 The Windows Clipboard12:15
      • 1.18 Module 18 The Office Clipboard06:30
      • 1.19 Module 19 Find and Replace08:08
      • 1.20 Module 20 Spellcheck and References09:10
      • 1.21 Module 21 Shapes11:17
      • 1.22 Module 22 Shape, Part 208:40
      • 1.23 Module 23 Pictures11:11
      • 1.24 Module 24 Pictures + Shapes04:03
      • 1.25 Module 25 Clipart and SmartArt10:08
      • 1.26 Module 26 Text Boxes06:00
      • 1.27 Module 27 Highlighting and Navigating in a Workbook11:51
      • 1.28 Module 28 Insert, Delete, Hide, Unhide10:13
      • 1.29 Module 29 Entering Data in a Series08:52
      • 1.30 Module 30 Formulas and Order of Operations13:02
      • 1.31 Module 31 Intro to Functions08:57
      • 1.32 Module 32 Financial Functions09:53
      • 1.33 Module 33 Date and Time Functions09:06
      • 1.34 Module 34 Text Functions09:06
      • 1.35 Module 35 Logical, Math, and Statistical Functions08:36
      • 1.36 Module 36 vLookup and Misc Functions08:33
      • 1.37 Module 37 Formatting Cells and Ranges08:08
      • 1.38 Module 38 Number Formatting10:40
      • 1.39 Module 39 Tables12:33
      • 1.40 Module 40 Sorting and Filtering11:52
      • 1.41 Module 41 Subtotals06:34
      • 1.42 Module 42 Pivot Tables07:47
      • 1.43 Module 43 Customizing Pivot Tables14:33
      • 1.44 Module 44 Importing Data08:52
      • 1.45 Module 45 Intro to Charts04:25
      • 1.46 Module 46 Choosing The Right Chart05:34
      • 1.47 Module 47 Chart Data03:47
      • 1.48 Module 48 Advanced Chart Formatting11:35
      • 1.49 Module 49 Pivot Charts02:56
      • 1.50 Module 50 Sparklines05:25
      • 1.51 Module 51 Customizing Your Worksheet View, Part 112:45
      • 1.52 Module 52 Customizing Your Worksheet View, Part 203:49
      • 1.53 Module 53 Advanced Formatting07:44
      • 1.54 Module 54 Advanced Data Copy Techniques08:33
      • 1.55 Module 55 Transforming Data with the Paste Special02:51
      • 1.56 Module 56 Manipulating Text with Functions08:34
      • 1.57 Module 57 Printing Worksheets11:35
      • 1.58 Module 58 Working with Print Area05:27
      • 1.59 Module 59 Print Titles, Headers, and Footers09:25
      • 1.60 Module 60 Using Data Validation10:32
      • 1.61 Module 61 Analyzing Data with Scenario Manager07:24
      • 1.62 Module 62 Analyzing Data with Data Tables07:47
      • 1.63 Module 63 Analyzing Data with Solver and Goal Seek03:01
      • 1.64 Module 64 Text to Columns04:34
      • 1.65 Module 65 Consolidating Data03:36
      • 1.66 Module 66 Creating Macros08:16
      • 1.67 Module 67 Advanced Macros05:55
      • 1.68 Module 68 Custom Series06:47
      • 1.69 Module 69 Conditional Formatting, Part 106:13
      • 1.70 Module 70 Conditional Formatting, Part 210:03
      • 1.71 Module 71 External References03:54
      • 1.72 Module 72 Exporting and Sharing05:31
      • 1.73 Module 73 Comments03:53
      • 1.74 Module 74 Customizing the Quick Access Toolbar and Ribbon09:29
      • 1.75 Module 75 Conclusion02:02
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Reviews

Insightful, the topics covered are informative and short. Provides enough information needed to learn the topics. Well presented, makes it easy to follow.

Read more Read less

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

Read more Read less

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

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

Good course. The information is very crisp and clear.

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.