What Will You Learn?

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

Our Excel 2013 Levels 1, 2 & 3 training videos include all the training you need to pass the Excel 2013 Core (77-420) and Expert Part 1 (77-427) and Part 2 (77-428) 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

  • 4

    Editing Worksheets

    • 24. Editing Data
    • 25. Editing Columns Rows Cells
    • 26. Find and Replace
    • 27. GoTo
    • 28. Transpose Data
    • 29. Adjust Columns Rows
    • 30. Spell Check
    • Quiz
  • 5

    Formatting

    • 31. Modifying Fonts
    • 32. Basic Number Formats
    • 33. Basic Custom Number Format
    • 34. Borders Colors
    • 35. Formatting Shortcuts
    • 36. Adding Background
    • 37. Align Positioning Contents
    • 38. Create Manage Styles
    • 39. AutoFormat
    • 40. Applying Themes
    • Quiz!
  • 6

    Printing

    • 41. Print Preview
    • 42. Page Orientation
    • 43. Print Titles
    • 44. Headers Footers
    • 45. Margins
    • 46. Page Breaks
    • 47. Print Range Scaling
    • Quiz
  • 7

    Modifying Worksheet Appearance

    • 48. Managing Worksheets
    • 49. Hide Sheets Workbooks
    • 50. Split Worksheet
    • 51. Freeze Panes
    • 52. Multiple Worksheet Workbook Views
    • 53. Formula Options
    • 54. Speak Cells
    • Quiz!
  • 8

    Advanced Formulas & Functions

    • 55. Name Range
    • 56. Version Control
    • 57. Linking Data
    • 58. UPPER LOWER PROPER
    • 59. CONCATENATE
    • 60. LEFT FIND SEARCH
    • 61. RIGHT FIND LEN
    • 62. IF AND OR
    • 63. Nested IF
    • 64. IFERROR
    • 65. PMT
    • 66. Display Print Formulas
    • 67. SUMIFs COUNTIFs AVERAGEIFs
    • 68. LOOKUP
    • 69. VLOOKUP
    • 70. HLOOKUP
    • Quiz!
  • 9

    Tables

    • 71. Create Table
    • 72. Modify Tables
    • 73. Fomat Tables
    • 74. Custom Table Styles
    • 75. Sorting Filtering
    • 76. DSUM DAVERAGE DCOUNT
    • 77. Time Functions
    • 78. Database Design Flaws Sorting
    • 79. AutoFilter
    • 80. Advanced Filter A
    • 81. Advanced Filter B
    • 82. Subtotals
    • Quiz!
  • 10

    Charts

    • 83. Create Chart
    • 84. Modifying Charts
    • 85. Trend Line
    • 86. Chart Axis Titles
    • 87. Format Chart
    • 88. Dual Axes Chart
    • 89. Chart Template
    • 90. Chart Sharing
    • Quiz
  • 11

    PivotTables & PivotCharts

    • 91. Create PivotTable
    • 92. Customize PivotTable
    • 93. Slicers A
    • 94. Slicers B
    • 95. Create PivotChart
    • Quiz!
  • 12

    Graphics

    • 96. Insert Modify Picture
    • 97. Clip Art
    • 98. Draw Modify Shapes
    • 99. SmartArt Graphics
    • 100. Layering Grouping
    • Quiz!
  • 13

    Customize Excel

    • 101. Comments
    • 102. Hyperlinks
    • 103. Web Research
    • 104. Watermarks
    • 105. Customize Themes
    • 106. Advanced Themes
    • 107. Workbook Templates
    • 108. Custom Template
    • Quiz!
    • Quiz!
  • 14

    Workbook

    • 109. Properties
    • 110. Custom Views
    • 111. Macros A
    • 112. Macros B
    • 113. Edit Macro
    • 114. Absolute Relative Refs
    • 115. Conditional Formatting A
    • 116. Conditional Formatting B
    • 117. Data Validation
    • 118. Quick Analysis
    • Quiz!
  • 15

    Collaborating

    • 119. Protect Worksheets
    • 120. Password Protect Cells
    • 121. Document Inspector
    • 122. Protect Structure
    • 123. Password Open Modify
    • 124. Always Create Backup
    • 125. Share Workbook
    • 126. SkyDrive A
    • 127. SkyDrive B
    • 128. SharePoint Sharing A
    • 129. SharePoint Sharing B
    • 130. Track Changes
    • 131. Protect Share Workbook
    • 132. Merging Workbooks
    • 133. Digital ID A
    • 134. Digital ID B
    • 135. Mark As Final
    • Quiz!
  • 16

    Audit Worksheets

    • 136. Tracer Errors Arrows
    • 137. Invalid Data
    • 138. Watch And Evaluate
    • 139. Outline And Group
    • Quiz!
  • 17

    Analyzing Data

    • 140. Sparklines
    • 141. Scenario Manager
    • 142. Goal Seek
    • 143. Solver
    • 144. Random Samples
    • 145. RAND
    • 146. Descriptive Statistics
    • 147. Power View
    • Quiz!
  • 18

    Import & Export Data

    • 156. Advanced Number Format
    • 157. Camera
    • 148. Consolidating Data
    • 149. Link Workbook
    • 150. Export to Word
    • 151. Import Text File
    • 152. PowerPivot
    • 153. Publish To Web
    • 154. Import From Web
    • 155. XML
    • Quiz!
  • 19

    Next steps

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