What Will You Learn?

Microsoft Excel 2016 Training Videos - Master Microsoft Excel from Beginner To Advanced! 

  • Build a solid understanding on the Basics of Microsoft Excel:
    • Creating a spreadsheet from scratch
    • Simple first steps in formulas and calculations
    • How to use Excel as a database with sorting and filtering options
    • Build your database right the first time and avoid common design flaws

  • Expand your knowledge with Advanced features:
    • Become more efficient with advanced functions and formulas
    • Learn the most common Excel functions used in the Office
    • Learn how to create charts from you organized database
    • Format your data range into a nice looking, functionable table

Unique tips, tricks, shortcuts and other Excel time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass both the Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified, guaranteed.

What's Included In The Course?

  • 16 Hours of Excel 2016 Training Videos
  • 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!
  • 3

    Functions & Formulas

    • 11. Basic Formulas FREE PREVIEW
    • 12. SUM & AVERAGE
    • 13. MIN & MAX
    • 14. COUNT & COUNTA
    • 15. Move Copy Cut Paste Data
    • 16. Absolute & Relative References
    • 17. Mixed References
    • 18. AutoFill
    • 19. FlashFill
    • 20. Text To Columns
    • Quiz!
  • 4

    Editing Worksheets

    • 21. Editing Cell Data
    • 22. Editing Cells, Columns & Rows
    • 23. Find & Replace
    • 24. GoTo
    • 25. Transpose Data
    • 26. Adjust Cells, Columns & Rows
    • 27. Spell Check
    • 28. SmartLookup & Thesaurus
    • 29. Formatting Text
    • Quiz!
  • 5

    Formatting

    • 30. Basic Number Formats
    • 31. Basic Custom Number Format
    • 32. Borders & Colors
    • 33. Formatting Shortcuts
    • 34. Adding Background
    • 35. Align, Merge & Wrap Cell Contents
    • 36. Cell Styles
    • 37. AutoFormat
    • 38. Applying Themes
    • 39. Basic Conditional Formatting
    • 40. Conditional Formatting Manager
    • Quiz!
  • 6

    Print

    • 41. Print Preview & Grid
    • 42. Page Orientation
    • 43. Print Row and Column Titles
    • 44. Headers & Footers
    • 45. Page Margins & Centering Horizontal and Vertical
    • 46. Page Breaks
    • 47. Print Range and Scaling
    • Quiz!
  • 7

    Modifying Worksheet Appearance

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

    Advanced Formulas & Functions

    • 55. Create Name Ranges FREE PREVIEW
    • 56. Version Control
    • 57. Linking Data
    • 58. UPPER LOWER PROPER
    • 59. CONCATENATE
    • 60. LEFT, FIND & SEARCH
    • 61. RIGHT, FIND & LEN
    • 62. MID
    • 63. AND & OR
    • 64. IF
    • 65. Nesting Functions
    • 66. IFERROR
    • 67. PMT
    • 68. Display & Print Formulas
    • 69. SUMIFs, COUNTIFs & AVERAGEIFs
    • 70. CONVERT
    • 71. MATCH & INDEX
    • 72. LOOKUP
    • 73. VLOOKUP
    • 74. HLOOKUP
    • 75. Single & Multicell Array Formulas
    • Quiz!
  • 9

    Tables

    • 76. Create Tables
    • 77. Modifying Tables
    • 78. Format Tables
    • 79. Custom Table Styles
    • 80. Table Sorting Filtering
    • 81. DSUM, DAVERAGE & DCOUNT
    • 82. Date & Time Functions
    • 83. Sort
    • 84. AutoFilter
    • 85. Advanced Filter
    • 86. Subtotals
    • Quiz!
  • 10

    Charts

    • 87. Create Charts
    • 88. Modifying Charts
    • 89. Trendlines
    • 90. Chart Axis Titles
    • 91. Format Chart
    • 92. Dual Axis Chart
    • 93. Chart Templates
    • 94. Chart Sharing & Embedding
    • Quiz!
  • 11

    PivotTables & PivotCharts

  • 12

    Graphics

    • 99. Insert & Modify Pictures
    • 100. Draw & Modify Shapes
    • 101. SmartArt Graphics
    • 102. Layering Grouping Graphics
    • Quiz!
  • 13

    Customize Excel

    • 103. Insert Comments
    • 104. Web, Internal & Email Hyperlinks
    • 105. Create Watermarks
    • 106. Customizing Themes
    • 107. Intermediate Conditional Formatting
    • 108. Free Custom Templates
    • Quiz!
  • 14

    Workbook

  • 15

    Collaborating

    • 116. Data Validation FREE PREVIEW
    • 117. Protect Worksheets
    • 118. Password Protect Cells
    • 119. Document Inspector
    • 120. Protect Workbook Structure
    • 121. Password Open Modify
    • 122. Always Create Backup
    • 123. Share Workbook
    • 124. OneDrive
    • 125. Track Changes
    • 126. Protect Share Workbook
    • 127. Merging Workbooks
    • 128. Digital Signature ID
    • 129. Mark As Final
    • Quiz!
  • 16

    Audit Worksheets

    • 130. Tracer Errors & Arrows
    • 131. Invalid Data
    • 132. Watch & Evaluate Formulas
    • 133. Outline & Group Data
    • Quiz!
  • 17

    Analyzing Data

    • 134. Sparklines
    • 135. 3D Map
    • 136. Data Table
    • 137. Scenario Manager
    • 138. Forecast Sheet
    • 139. Goal Seek
    • 140. Solver
    • 141. Random Samples
    • 142. RAND
    • 143. Descriptive Statistics
    • 144. Power View
    • Quiz!
  • 18

    Import & Export Data

    • 145. Consolidating Data
    • 146. Link Workbooks
    • 147. Form Data
    • 148. Export Data
    • 149. Import Text File
    • 150. Power Pivot
    • 151. Publish to Web
    • 152. XML
    • 153. Advanced Custom Number Formats
    • 154. Camera
    • Quiz!
  • 19

    Next steps

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