What Will You Learn?

Excel 2007 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 2007 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 2007!

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


What's Included In The Course?

  • Certificate of Completion

Course Curriculum

  • 1

    Welcome to the course!

    • Before we begin...
    • How to use this course
  • 2

    Basics

    • 1. Excel Getting Started
    • 2. Quick Access Toolbar
    • 3. Data Entry
    • 4. Converting To 2007
    • 5. Converting To Previous
    • 6. Move Copy Cut Data
    • 7. AutoFill Feature
    • 8. Editing Data
    • 9. Find and Replace
    • 10. GoTo Feature
    • 11. Spell Check
  • 3

    Functions & Formulas

    • 12. Basic Formulas
    • 13. SUM and AVERAGE
    • 14. MAX and MIN
    • 15. COUNT and COUNTA
    • 16. Absolute Reference
    • 17. Mixed References
    • 18. Text To Columns
    • 19. Combine Columns
  • 4

    Formatting

    • 20. Modifying Fonts
    • 21. Borders and Shading
    • 22. Adding Backgrounds
  • 5

    Editing Worksheets

    • 23. Adjusting Columns Rows
    • 24. Text Wrapping
    • 25. Hide Columns Rows
    • 26. Merge Cells
    • 27. Formatting Numbers
    • 28. Create Modify Styles
    • 29. AutoFormat
    • 30. Applying Themes
    • 31. Modifying Worksheets
  • 6

    Modifying Worksheet Appearance

    • 32. Print Titles
    • 33. Headers and Footers
    • 34. Margins
    • 35. Page Orientation
    • 36. Page Breaks
    • 37. Print Scaling
    • 38. Set Print Area
    • 39. Split Window
    • 40. Freeze Panes
    • 41. Arranging Worksheets
    • 42. Hide Worksheets Books
    • 43. Speak Cells
  • 7

    Customize

    • 44. Customize Interface
    • 45. Watermarks and Gridlines
    • 46. Customize Themes
    • 47. Comments
    • 48. Create Hyperlinks
    • 49. Web Research
    • 50. Custom Templates
  • 8

    Tables

    • 51. Create Tables
    • 52. Modifying Tables
    • 53. Custom Table Style
  • 9

    Charts

    • 54. Creating Charts
    • 55. Modify Charts
    • 56. Chart Templates
    • 57. Chart Sharing
  • 10

    PivotTable & Charts

    • 58. Create PivotTables A
    • 59. Create PivotTables B
    • 60. Create PivotCharts
  • 11

    Graphics

    • 61. Insert Pictures
    • 62. Draw Modify Shapes
    • 63. SmartArt Process
    • 64. Clip Art
    • 65. Layering Grouping
  • 12

    Advanced Formulas

    • 66. Create Name Ranges
    • 67. Link Data
    • 68. Time Functions
    • 69. LEFT and SEARCH A
    • 70. RIGHT SEARCH and LEN B
    • 71. PROPER LOWER UPPER
    • 72. SUM COUNT AVG IFS
    • 73. HLOOKUP
    • 74. VLOOKUP
    • 75. IF AND and OR
    • 76. Nested IF
    • 77. IFERROR
    • 78. Display Print Formulas
    • 79. PMT Payment
    • 80. Sorts Consecutive Sorts
    • 81. Advanced AutoFilter
    • 82. DSUM DAVG DCNT
    • 83. Subtotals
  • 13

    Workbook

    • 84. Macro Basics
    • 85. Editing Macros
    • 86. Filters and Macros
    • 87. Conditional Formatting
    • 88. Validation Rule
    • 89. Workbook Properties
    • 90. Default Settings
  • 14

    Collaborating

    • 91. Protect Worksheet
    • 92. Protect Structure Windows
    • 93. Protect Workbook Backup A
    • 94. Protect Workbook Backup B
    • 95. Share Workbook
    • 96. Share Track Protect Workbook
    • 97. Merge Workbooks
    • 98. Macro Settings
    • 99. Digital Signatures
    • 100. Restrict Access by User
  • 15

    Audit Worksheets

    • 101. Formula Auditing
    • 102. Circle Invalid Data
    • 103. Watch Evaluate Formulas
    • 104. Automatic Outline and Groups
  • 16

    Analyzing Data

    • 105. Chart Trend Lines
    • 106. Scenario Manager
    • 107. Goal Seek
    • 108. Solver
    • 109. Random Samples
    • 110. Workspace
    • 111. Consolidate Data
    • 112. Link Workbooks
  • 17

    Import & Export Data

    • 113. Export To Word
    • 114. Import Text Files
    • 115. Publish To Web.camrec
    • 116. Import Data From Web
    • 117. XML Structuring
    • 118. Advanced Number Formats
  • 18

    Next steps

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