Quality Seal Emagister EMAGISTER CUM LAUDE

Microsoft® Excel 2010

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Online
Description

Simplilearn is the World’s Largest Certification Training Provider, with over 400,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.

Important information

Opinions

R

19/03/2014
What I would highlight Very good course; knowledgeable trainer and well executed training.

Would you recommend this course? Yes.

What you'll learn on the course

Ms Excel
Excel MS

Course programme

Course Preview
  • Mastering Microsoft Excel 2010 for MOS
    • Mastering Microsoft Excel 2010 for MOS1206:2
      • 1.1 Module 1 Introduction1:51
      • 1.2 Module 2 Worksheets and Workbooks9:37
      • 1.3 Module 3 Adding and Changing Worksheets7:37
      • 1.4 Module 4 Basic Text and Number Entry13:57
      • 1.5 Module 5 The Excel Interface, Part 17:34
      • 1.6 Module 6 The Excel Interface, Part 216:1
      • 1.7 Module 7 Keyboard Shortcuts10:0
      • 1.8 Module 8 File Types10:40
      • 1.9 Module 9 Open, Save, and Autosave15:36
      • 1.10 Module 10 Templates8:48
      • 1.11 Module 11 Autocorrect6:45
      • 1.12 Module 12 Undo and Redo5:38
      • 1.13 Module 13 Text Formatting, Part 19:59
      • 1.14 Module 14 Text Formatting, Part 210:23
      • 1.15 Module 15 Adding Hyperlinks5:30
      • 1.16 Module 16 Scientific Equations7:43
      • 1.17 Module 17 The Windows Clipboard13:15
      • 1.18 Module 18 The Office Clipboard7:30
      • 1.19 Module 19 Find and Replace9:8
      • 1.20 Module 20 Spellcheck and References10:10
      • 1.21 Module 21 Shapes12:17
      • 1.22 Module 22 Shape, Part 29:40
      • 1.23 Module 23 Pictures12:11
      • 1.24 Module 24 Pictures + Shapes5:3
      • 1.25 Module 25 Clipart and SmartArt11:8
      • 1.26 Module 26 Text Boxes6:0
      • 1.27 Module 27 Highlighting and Navigating in a Workbook12:51
      • 1.28 Module 28 Insert, Delete, Hide, Unhide11:13
      • 1.29 Module 29 Entering Data in a Series9:52
      • 1.30 Module 30 Formulas and Order of Operations14:2
      • 1.31 Module 31 Intro to Functions9:57
      • 1.32 Module 32 Financial Functions10:53
      • 1.33 Module 33 Date and Time Functions10:6
      • 1.34 Module 34 Text Functions10:6
      • 1.35 Module 35 Logical, Math, and Statistical Functions9:36
      • 1.36 Module 36 vLookup and Misc Functions9:33
      • 1.37 Module 37 Formatting Cells and Ranges9:8
      • 1.38 Module 38 Number Formatting11:40
      • 1.39 Module 39 Tables13:33
      • 1.40 Module 40 Sorting and Filtering12:52
      • 1.41 Module 41 Subtotals7:34
      • 1.42 Module 42 Pivot Tables8:47
      • 1.43 Module 43 Customizing Pivot Tables15:33
      • 1.44 Module 44 Importing Data9:52
      • 1.45 Module 45 Intro to Charts5:25
      • 1.46 Module 46 Choosing The Right Chart6:34
      • 1.47 Module 47 Chart Data4:47
      • 1.48 Module 48 Advanced Chart Formatting12:35
      • 1.49 Module 49 Pivot Charts3:56
      • 1.50 Module 50 Sparklines6:25
      • 1.51 Module 51 Customizing Your Worksheet View, Part 113:45
      • 1.52 Module 52 Customizing Your Worksheet View, Part 24:49
      • 1.53 Module 53 Advanced Formatting8:44
      • 1.54 Module 54 Advanced Data Copy Techniques9:33
      • 1.55 Module 55 Transforming Data with the Paste Special3:51
      • 1.56 Module 56 Manipulating Text with Functions9:34
      • 1.57 Module 57 Printing Worksheets12:35
      • 1.58 Module 58 Working with Print Area6:27
      • 1.59 Module 59 Print Titles, Headers, and Footers10:25
      • 1.60 Module 60 Using Data Validation11:32
      • 1.61 Module 61 Analyzing Data with Scenario Manager8:24
      • 1.62 Module 62 Analyzing Data with Data Tables8:47
      • 1.63 Module 63 Analyzing Data with Solver and Goal Seek4:1
      • 1.64 Module 64 Text to Columns5:34
      • 1.65 Module 65 Consolidating Data4:36
      • 1.66 Module 66 Creating Macros9:16
      • 1.67 Module 67 Advanced Macros6:55
      • 1.68 Module 68 Custom Series7:47
      • 1.69 Module 69 Conditional Formatting, Part 17:13
      • 1.70 Module 70 Conditional Formatting, Part 211:3
      • 1.71 Module 71 External References4:54
      • 1.72 Module 72 Exporting and Sharing6:31
      • 1.73 Module 73 Comments4:53
      • 1.74 Module 74 Customizing the Quick Access Toolbar and Ribbon10:29
      • 1.75 Module 75 Conclusion3:2

Additional information

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


Compare this course with other similar courses
See all