What Will You Learn?

Excel 2010 Training Videos will introduce you to the basics of creating a: spreadsheet, with simple formulas and calculations to more powerful ones, and how you can use Excel 2010 as a database with many sorting and filtering options. It's also important to know how to create your database right the first time, like how to avoid common design flaws, and numerous time saving features!

Learn how to create charts from your organized data, how to format your data range into a nice looking table, and more by our Microsoft Certified Trainer training Excel 2010!

Our Excel 2010 Levels 1, 2 & 3 training videos include all the training you need to pass the Excel 2010 Core (77-882) and Expert (77-888) Exams and become certified!


What's Included In The Course?

  • Quizzes
  • Exercise files
  • Instructor's Notes
  • Certificate of Completion

Course Curriculum

  • 1

    Welcome to the course!

    • Before we begin...
    • How to use this course
    • Instructor Notes and Exercise Files!
  • 2

    Basics

  • 3

    Functions & Formulas

    • 12. Basic Formulas
    • 13. SUM and Average
    • 14. MAX MIN
    • 15. COUNT
    • 16. Copying and Pasting Data
    • 17. Clipboard
    • 18. Move
    • 19. AutoFill
    • 20. Absolute References
    • 21. Mixed References
    • 22. Text to Columns
    • Quiz!
  • 4

    Editing Worksheets

    • 23. Editing Data
    • 24. Editing Columns Rows Cells
    • 25. Find and Replace
    • 26. GoTo
    • 27. Transpose Data
    • 28. Adjusting Columns Rows
    • 29. Hide Columns Rows
    • Quiz!
  • 5

    Formatting

    • 30. Modifying Fonts
    • 30. Modifying Fonts
    • 31. Spell Check
    • 31. Spell Check
    • 32. Number Formats
    • 32. Number Formats
    • 33. Basic Custom Number Formats
    • 33. Basic Custom Number Formats
    • 34. Borders and Color Shading
    • 34. Borders and Color Shading
    • 35. Formatting Shortcuts
    • 35. Formatting Shortcuts
    • 36. Applying Background
    • 36. Applying Background
    • 37. Cell Alignment
    • 37. Cell Alignment
    • 38. Merge Cells
    • 38. Merge Cells
    • 39. Cell Text Wrapping
    • 39. Cell Text Wrapping
    • 40. Create and Modify Styles
    • 40. Create and Modify Styles
    • 41. AutoFormat
    • 41. AutoFormat
    • 42. Applying Themes
    • 42. Applying Themes
    • Quiz!
  • 6

    Print

    • 43. Print Preview
    • 44. Page Orientation
    • 45. Print Titles Rows Columns
    • 46. Headers and Footers
    • 47. Print Margins
    • 48. Page Breaks
    • 49. Printing A Range of Data
    • Quiz!
  • 7

    Modifying Worksheet Appearance

    • 50. Modifying Worksheets
    • 51. Hiding Sheets and Workbooks
    • 52. Splitting Worksheets
    • 53. Freeze Panes
    • 54. Multi Worksheet Book Views
    • 55. Text to Speech
    • Quiz!
  • 8

    Advanced Formulas & Functions

    • 56. Name Cells and Ranges
    • 57. Linking Data
    • 58. UPPER LOWER PROPER
    • 59. Combining Columns Concatenate
    • 60. LEFT FIND SEARCH
    • 61. RIGHT FIND LEN
    • 62. IF AND OR
    • 63. Nested IF
    • 64. IFERROR
    • 65. PMT Payment Function
    • 66. Display Print Formulas
    • 67. SUM COUNT AVERAGE IFS
    • 68. VLOOKUP
    • 69. HLOOKUP
    • Quiz!
  • 9

    Tables

    • 70. Create Tables
    • 71. Modifying Tables
    • 72. Formatting Tables
    • 73. Custom Table Style
    • 74. Table Sorting Filtering
    • 75. DSUM DAVERAGE DCOUNT
    • 76. Time Functions
    • 77. Database Design Flaws Sorting
    • 78. AutoFilter
    • 79. Advanced Filter
    • 80. Subtotals
    • Quiz!
  • 10

    Charts

    • 81. Create Charts
    • 82. Modify Charts
    • 83. Chart Titles
    • 84. Format Chart
    • 85. Creating Chart Templates
    • 86. Chart Application Sharing
    • Quiz!
  • 11

    PivotTables & PivotCharts

    • 87. Create PivotTables
    • 88. Customize PivotTables
    • 89. PivotTable Slicers
    • 90. Create PivotChart
    • Quiz!
  • 12

    Graphics

    • 91. Insert Modify Pictures
    • 92. ClipArt
    • 93. Draw Modify Shapes
    • 94. SmartArt Graphics
    • 95. Layering Grouping
    • Quiz!
  • 13

    Customize Excel

    • 96. Comments
    • 97. Hyperlinks
    • 98. Web Research
    • 99. Watermarks Gridlines
    • 100. Customize Themes
    • Quiz!
  • 14

    Workbook

    • 103. Workbook Properties
    • 104. Custom Views
    • 105. Macro Basics
    • 106. Editing Macros
    • 107. Absolute Relative Macro Ref
    • 108. Conditional Formatting
    • 109. Data Validation
    • Quiz!
  • 15

    Collaborating

    • 110. Protect Worksheets
    • 111. Password Protect Cells
    • 112. Document Inspector
    • 113. Protect Structure
    • 114. Password Open Modify
    • 115. Create Backup
    • 116. Share Workbook
    • 117. SkyDrive Sharing
    • 118. SharePoint Sharing
    • 119. Track Changes
    • 120. Protect and Share
    • 121. Merge Workbooks
    • 122. Digital Signatures
    • 123. Restrict Access
    • 124. Mark As Final
    • Quiz!
  • 16

    Audit Worksheets

    • 125. Tracer Arrows Errors
    • 126. Troubleshoot Invalid Data
    • 128. AutoOutline and Grouping
    • 127. Watch and Evaluate Formulas
    • Quiz!
  • 17

    Analyzing Data

    • 129. Trend Line
    • 130. Sparklines
    • 131. Scenarios
    • 132. Goal Seek
    • 133. Solver
    • 134. Random Samples
    • Quiz!
  • 18

    Multiple Workbooks

    • 136. Consolidating Data
    • 137. Link Workbooks
    • 135.Workspace
    • Quiz!
  • 19

    Import & Export Data

    • 138. Export to Word
    • 139. Import Text File
    • Quiz!
  • 20

    Excel & Web

    • 141. Import from Web
    • 140. Publish Worksheet to Web
  • 21

    XML Structuring

    • 142. XML Extensible Markup Language
    • 143. Advanced Custom Number Formats
    • 144. Camera
    • Quiz!
  • 22

    Next steps

    • Congrats! Here's what's next...
    • Before you go...