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!
-
2
Basics
- 1. Excel 2016 First Look FREE PREVIEW
- 2. Customize Excel Environment FREE PREVIEW
- 3. Quick Access Toolbar FREE PREVIEW
- 4. Ribbon FREE PREVIEW
- 5. Navigating Excel FREE PREVIEW
- 6. Basic Worksheet FREE PREVIEW
- 7. Save, Save as Copy & Backup Workbooks
- 8. Convert to Excel 2016
- 9. Compatibility Checker
- 10. Tell Me or Help
- Quiz!
-
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
- 95. PivotTables FREE PREVIEW
- 96. Customize PivotTables
- 97. PivotTable Slicers
- 98. PivotChart
- Quiz!
-
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
- 109. Workbook Properties FREE PREVIEW
- 110. Custom Views
- 111. Macros
- 112. Edit Macro
- 113. Absolute Relative Referencing
- 114. Advanced Conditional Formatting
- 115. Quick Analysis
- Quiz!
-
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...