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 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
    • {{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.

Contact Us

+1-844-532-7688

(Toll Free)

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
/index/hidden/ - Never remove this line