Core Excel

Purchase this course to access all lessons and start learning.

Introduction
Video Time
Save Video 1. Welcome Watched 2:26
A Tour of Excel
Video Time
Save Video 2. What is Excel? Watched 2:32
Save Video 3. A tour of the Excel interface Watched 2:34
Save Video 4. A tour of the Excel Ribbon Watched 3:09
Save Video 5. A tour of the File tab Watched 2:44
Getting started
Video Time
Save Video 6. How to create a new workbook Watched 2:06
Save Video 7. How to save a workbook Watched 2:16
Save Video 8. How to save a workbook in a different format Watched 2:48
Save Video 9. How to navigate a workbook Watched 2:32
Save Video 10. How to find and open recent workbooks Watched 2:03
Save Video 11. How to undo and redo changes in Excel Watched 2:39
Save Video 12. How to use the Quick Access Toolbar Watched 2:59
The worksheet
Video Time
Save Video 13. How to select cells in Excel Watched 2:21
Save Video 14. How to select rows and columns in Excel Watched 1:43
Save Video 15. Shortcuts for selecting cells in Excel Watched 2:09
Save Video 16. How to insert and delete columns in Excel Watched 1:55
Save Video 17. How to insert and delete rows in Excel Watched 1:49
Save Video 18. How to insert and delete cells in Excel Watched 3:15
Save Video 19. How to change column widths in Excel Watched 2:29
Save Video 20. How to change row heights in Excel Watched 2:29
Save Video 21. How to hide and unhide columns and rows in Excel Watched 2:31
Entering data
Video Time
Save Video 22. How to enter data in Excel Watched 1:42
Save Video 23. How to delete data in Excel Watched 2:00
Save Video 24. How to edit data in Excel Watched 1:22
Save Video 25. How to enter dates in Excel Watched 1:19
Save Video 26. How to enter historical dates in Excel Watched 2:14
Save Video 27. How to enter times in Excel Watched 1:46
Save Video 28. Shortcuts for the current Date and Time in Excel Watched 0:55
Save Video 29. How to enter numbers as text in Excel Watched 2:29
Save Video 30. Shortcut for entering data in more than one cell in Excel Watched 1:14
Save Video 31. How to use the fill handle to enter data in Excel Watched 2:09
Save Video 32. How to enter custom patterns with the fill handle in Excel Watched 1:50
Save Video 33. How to move data in Excel Watched 2:44
Save Video 34. How to duplicate data in Excel Watched 2:44
Save Video 35. How to use drag and drop in Excel Watched 1:56
Building a Workbook
Video Time
Save Video 36. How to insert and delete worksheets Watched 2:30
Save Video 37. How to name and format worksheet tabs Watched 2:21
Save Video 38. How to move and copy worksheets in Excel Watched 2:20
Save Video 39. How to move and copy worksheets to other workbooks Watched 2:47
Save Video 40. How to hide and unhide worksheets Watched 2:12
Find and replace
Video Time
Save Video 41. How to find a value in Excel Watched 3:25
Save Video 42. How to search in formulas and values in Excel Watched 2:41
Save Video 43. How to find a formatted value in Excel Watched 2:53
Save Video 44. How to find all matches at once in Excel Watched 2:43
Save Video 45. How to find and replace a value Watched 2:36
Save Video 46. How to find and replace formatted values in Excel Watched 2:51
Formula basics
Video Time
Save Video 47. What is a cell reference? Watched 2:15
Save Video 48. What is a formula? Watched 2:28
Save Video 49. What is a function? Watched 2:16
Save Video 50. How to enter a formula with cell references Watched 2:28
Save Video 51. How to edit a formula Watched 2:26
Save Video 52. How to use addition in a formula Watched 2:20
Save Video 53. How to use subtraction in a formula Watched 1:51
Save Video 54. How to use multiplication in a formula Watched 2:07
Save Video 55. How to use division in a formula Watched 2:06
Save Video 56. How to use exponents in a formula Watched 2:13
Save Video 57. The order of operations Watched 2:54
Cell references
Video Time
Save Video 58. What's a relative reference? Watched 2:38
Save Video 59. How to use relative references - example 1 Watched 2:28
Save Video 60. How to use relative references - example 2 Watched 2:37
Save Video 61. What's an absolute reference? Watched 3:00
Save Video 62. How to use absolute references - example 1 Watched 2:37
Save Video 63. How to use absolute references - example 2 Watched 2:49
Save Video 64. Named ranges as absolute references Watched 2:16
Formatting numbers
Video Time
Save Video 65. What is a number format in Excel? Watched 3:21
Save Video 66. How to apply general formatting in Excel Watched 2:31
Save Video 67. How to use number formatting in Excel Watched 2:47
Save Video 68. How to use currency formatting in Excel Watched 2:51
Save Video 69. How to use accounting formatting in Excel Watched 2:39
Save Video 70. How to use percentage formatting in Excel Watched 3:03
Save Video 71. How to use fraction formatting in Excel Watched 3:16
Save Video 72. How to use scientific formatting in Excel Watched 2:32
Save Video 73. How to use text formatting in Excel Watched 2:43
Save Video 74. How to use special formatting in Excel Watched 2:58
Save Video 75. How to create a custom number format in Excel Watched 2:48
Formatting dates and times
Video Time
Save Video 76. How Excel stores dates and times Watched 2:44
Save Video 77. How to use date formatting in Excel Watched 2:53
Save Video 78. How to use time formatting in Excel Watched 2:49
Save Video 79. How to create a custom date format Watched 2:54
Save Video 80. How to create a custom time format Watched 3:41
Alignment
Video Time
Save Video 81. How to wrap text in cells in Excel Watched 2:41
Save Video 82. How to apply horizontal alignment in Excel Watched 2:39
Save Video 83. How to use fill, justify, and distributed in Excel Watched 3:04
Save Video 84. How to align text vertically in Excel Watched 3:08
Save Video 85. How to indent cell content in Excel Watched 3:02
Save Video 86. How to align text across cells with merge in Excel Watched 2:55
Save Video 87. How to use Center Across Selection in Excel Watched 2:54
Save Video 88. How to use Shrink to fit in Excel Watched 2:42
Save Video 89. How to use text orientation in Excel Watched 3:08
Font formatting
Video Time
Save Video 90. How to format font and font size in Excel Watched 3:05
Save Video 91. How to apply bold, italic, underlining styles in Excel Watched 2:38
Save Video 92. How to change the font color in Excel Watched 2:40
Save Video 93. Using Format Cells to apply font settings in Excel Watched 2:36
Save Video 94. How to apply different underline options in Excel Watched 2:41
Save Video 95. How to apply subscript, superscript, and strikethrough formatting in Excel Watched 3:03
Save Video 96. How to insert symbols and special characters in Excel Watched 3:18
Save Video 97. How to format individual characters in Excel Watched 2:42
Borders and fills
Video Time
Save Video 98. How to apply a border to cells in Excel Watched 3:11
Save Video 99. How to apply a fill to cells in Excel Watched 2:48
Save Video 100. How to draw borders and border grids in Excel Watched 2:50
Save Video 101. How to apply a border using ribbon presets in Excel Watched 2:51
Save Video 102. How to use borders and fills together in Excel Watched 2:30
Save Video 103. How to remove existing borders and fills in Excel Watched 2:09
Productivity tips
Video Time
Save Video 104. How to use the format painter Watched 3:13
Save Video 105. How to select visible cells only Watched 2:33
Save Video 106. How to move around big lists fast Watched 2:40
Save Video 107. How to quickly remove blank rows Watched 2:01
Save Video 108. How to quickly remove rows that have empty values Watched 3:46
Conditional Formatting
Video Time
Save Video 109. What is conditional formatting? Watched 2:33
Save Video 110. How to create a conditional formatting rule Watched 2:27
Save Video 111. How to revise a conditional formatting rule Watched 2:56
Save Video 112. How to add additional conditional formatting rules Watched 2:58
Save Video 113. How to delete conditional formatting rules Watched 2:20
Working with data and lists
Video Time
Save Video 114. How to freeze columns or rows in a list Watched 2:27
Save Video 115. How to quick sort using one column in Excel Watched 2:36
Save Video 116. How to sort using more than one column Watched 2:56
Save Video 117. How to filter a list Watched 2:44
Save Video 118. How to filter with multiple criteria Watched 3:07
Save Video 119. How to highlight duplicates in a list Watched 2:33
Charting
Video Time
Save Video 120. Anatomy of an Excel chart Watched 2:28
Save Video 121. How to create a basic chart Watched 2:26
Save Video 122. How to move and resize a chart in Excel Watched 2:45
Save Video 123. How to create a standalone chart Watched 2:31
Save Video 124. How to edit and add to chart data Watched 2:25
Save Video 125. How to add a title and legend to a chart Watched 3:00