This page is the home of a variety of short training videos using Microsoft Excel. I hope you find the videos useful. If you'd like to download the mp4 file to watch on a different device, right-click or control-click the download link next to the video you want to save. Thanks for watching.
Now Playing: INDEX Video 178
Watch More Videos >>
Current Playlist >>
- ROUND in an Array [Download]
- LEN in an Array Video 357 [Download]
- SUM with Or Criteria in an Array Video 356 [Download]
- SUM and Multiple IFs in an Array Video 355 [Download]
- SUM and IF in an Array Video 354 [Download]
- Using Arrays to Copy Data [Download]
- Transposing Arrays Video 352 [Download]
- Changing Named Array Contstants Video 351 [Download]
- Naming an Array Video 350 [Download]
- Using Constants in an Array Formula Video 349 [Download]
- Constants in Array Formulas Video 348 [Download]
- Deleting, Moving, and Expanding Array Formulas Video 347 [Download]
- Multi-Cell Array Formulas Video 346 [Download]
- Introducing Arrays Video 345 [Download]
- Data Tables Tips and Tricks Video 344 [Download]
- Data Tables with Three Variables Video 343 [Download]
- Data Tables with Two Variables Video 342 [Download]
- Introducing Data Tables Video 341 [Download]
- Scenario Manager Pivot Table and Merging Scenarios Video 340 [Download]
- Scenario Manager Summary Video 339 [Download]
- Introducing Scenario Manager Video 338 [Download]
- Loading and Saving Solver Scenarios Video 337 [Download]
- Solving for Min and Max Video 336 [Download]
- Solver Reports Video 335 [Download]
- Changing Constraints in Solver Video 334 [Download]
- Introducing Solver Video 333 [Download]
- Goal Seek Part 2 Video 332 [Download]
- Introducing Goal Seek Video 331 [Download]
Excel 2010 Pivot Tables Playlist >>
- Create a Pivot Table Video 280 [Download]
- Pivoting Rows and Columns in a Pivot Table Video 281 [Download]
- Sorting Pivot Table Data Video 282 [Download]
- Manually Sorting Pivot Table Data Video 283 [Download]
- Manual Filters Video 284 [Download]
- Label Filters Video 285 [Download]
- Date Filters Video 286 [Download]
- Value Filters Video 287 [Download]
- Top 10 Filters Video 288 [Download]
- Slicers Part 1 Video 289 [Download]
- Slicers Part 2 Video 290 [Download]
- Search Box Filter Part 1 Video 291 [Download]
- Search Box Filter Part 2 Video 292 [Download]
- Drill-Down to Detail Video 293 [Download]
- Grouping Dates Video 294 [Download]
- Grouping Text Part 1 Video 295 [Download]
- Grouping Text Part 2 Video 296 [Download]
- Expanding and Collapsing Groups Video 297 [Download]
- Sum, Count and Average Values Video 298 [Download]
- Percentages of the Total Video 299 [Download]
- Percentages of the Parent Row Total Video 300 [Download]
- Percentages of the Parent Column Total Video 301 [Download]
- "Show Values As" Shortcuts Video 302 [Download]
- Percentage of a Baseline Video 303 [Download]
- Difference From a Baseline Video 304 [Download]
- Percentage Difference from a Baseline Video 305 [Download]
- Running Totals Video 306 [Download]
- Ranking in Pivot Tables Video 307 [Download]
- Show Values as an Index in Pivot Tables Video 308 [Download]
- Basic Formulas with Pivot Table Data Video 309 [Download]
- GETPIVOTDATA Part 1 Video 310 [Download]
- GETPIVOTDATA Part 2 Video 311 [Download]
- GETPIVOTDATA Part 3 Video 312 [Download]
- Calculated Fields in Pivot Tables Part 1 Video 313 [Download]
- Calculated Fields in Pivot Tables Part 2 Video 314 [Download]
- Pivot Table Field List Video 315 [Download]
- Refreshing Pivot Table Data Video 316 [Download]
- Pivot Table Menu Tips Video 317 [Download]
- Show Report Filter Pages Video 318 [Download]
- Pivot Table Layout Options Video 319 [Download]
- Pivot Table Format Options Video 320 [Download]
- Allow Multiple Filters per Field Video 321 [Download]
- Sort Pivot Tables with Custom Lists Video 322 [Download]
- Pivot Table Display Options Video 323 [Download]
- Remove Deleted Items from Pivot Table Drop Down List Video 324 [Download]
- Pivot Table Style Options Video 325 [Download]
- Pivot Table Layouts Video 326 [Download]
- Pivot Table Custom Subtotals Video 327 [Download]
- Introducing Pivot Charts Video 328 [Download]
- Pivot Chart Field Buttons Video 329 [Download]
- Create a Pivot Chart from Scratch Video 330 [Download]
Excel Basics Playlist >>
- Quick Access Toolbar, Part 1 Video 201 [Download]
- Quick Access Toolbar Part 2 Video 202 [Download]
- CUT Video 203 [Download]
- COPY Video 204 [Download]
- PASTE Video 205 [Download]
- Paste Special Video 206 [Download]
- Format Painter Video 207 [Download]
- Selecting Cells with the Control and Shift Keys Video 208 [Download]
- Shift + End + Arrow Key Video 209 [Download]
- 4 More Navigation Shortcuts Video 210 [Download]
- Format Cells Part 1 Video 211 [Download]
- Format Cells Part 2 Video 212 [Download]
- Format Cells Part 3 Video 213 [Download]
- Wrap Text and Alt+Enter Video 214 [Download]
- Two Ways to Center Data Video 215 [Download]
- Orienting Cells Video 216 [Download]
- Number and Date Formats Video 217 [Download]
- Custom Date Formats Video 218 [Download]
- File Menu Basics Video 219 [Download]
- Recent Workbooks and New Workbooks Video 220 [Download]
- Printing Basics Video 221 [Download]
- Setting Margins and Print Area Video 222 [Download]
- Page Breaks, Backgrounds, and Print Titles Video 223 [Download]
- Page Break Preview Video 224 [Download]
- Page Setup Video 225 [Download]
- Headers and Footers Video 226 [Download]
- Custom Headers and Footers Video 227 [Download]
- Three Ways to get Your Data in Excel Video 228 [Download]
- Text to Columns Video 229 [Download]
- Downloading Data from the Internet Video 230 [Download]
- Add, Subtract, Multiply and Divide Video 231 [Download]
- Fee Schedule Example Part 1 Video 232 [Download]
- Fee Schedule Example Part 2 Video 233 [Download]
- Fee Schedule Example Part 3 Video 234 [Download]
- Cell Styles Video 235 [Download]
- Hide and Unhide Video 236 [Download]
- Custom Views Video 237 [Download]
- Comments Video 238 [Download]
- More Comments Video 239 [Download]
- Comments on the Review Tab Video 240 [Download]
- Navigating through Excel with the Enter Key Video 241 [Download]
- AutoComplete Video 242 [Download]
- Save Frustration and Save Time with AutoCorrect Video 243 [Download]
- Freeze Panes Video 244 [Download]
- Insert and Delete Part 1 Video 245 [Download]
- Insert and Delete Part 2 Video 246 [Download]
- Introducing Tabs Video 247 [Download]
- Moving and Copying Tabs Video 248 [Download]
- Writing Formulas Between Tabs Video 249 [Download]
- Changing Multiple Tabs at Once Video 250 [Download]
- Formulas Across Multiple Tabs Video 251 [Download]
- Relative Cell References Video 252 [Download]
- Absolute Cell References Video 253 [Download]
- Mixed Cell References Video 254 [Download]
- Format Menu Video 255 [Download]
- Shortcuts to Sum Video 256 [Download]
- Fill Down, Right, Up or Left Video 257 [Download]
- Fill Series Video 258 [Download]
- Fill Trends Video 259 [Download]
- Use Fill Justify to Manage Text Video 260 [Download]
- Sorting in Excel Video 261 [Download]
- Custom Sorting in Excel Video 262 [Download]
- Using Tables to Sort Video 263 [Download]
- Filtering in Excel Video 264 [Download]
- Using Tables to Filter Video 265 [Download]
- Clear Video 266 [Download]
- Find and Replace Video 267 [Download]
- Using Wildcards to Find Video 268 [Download]
- Options in the Find and Replace Window Video 269 [Download]
- Find Formats and Find All Video 270 [Download]
- Go To and Go To Special Video 271 [Download]
- Use Go To Constants to Create a Reusable Form Video 272 [Download]
- Finding and Selecting Visible Cells Video 273 [Download]
- Finding and Selecting Precedents and Dependents Video 274 [Download]
- Finding Row Differences Video 275 [Download]
- Finding and Deleting Blank Rows Video 276 [Download]
- Filling Blank Cells with Data Video 277 [Download]
- Finding Merged Cells Video 278 [Download]
- Excel and Word Video 279 [Download]
Functions Playlist >>
- The Formulas Tab Video 139 [Download]
- Insert Function Window Video 140 [Download]
- Basic Excel Functions Video 141 [Download]
- PV Present Value Video 142 [Download]
- PMT to Calculate Payments Video 143 [Download]
- Text to Speech for April Fools Video 144 [Download]
- Rate and Future Value Video 145 [Download]
- IF Video 146 [Download]
- Nesting IF Functions Video 147 [Download]
- AND Video 148 [Download]
- OR Video 149 [Download]
- NOT Video 150 [Download]
- Using IFERROR to Trap Errors Video 151 [Download]
- CONCATENATE Video 152 [Download]
- EXACT Video 153 [Download]
- FIND and LEN Excel Video 154 [Download]
- LEFT Video 155 [Download]
- RIGHT Video 156 [Download]
- MID Video 157 [Download]
- Combining Text Functions Video 158 [Download]
- UPPER, lower, and Proper Video 159 [Download]
- TRIM Video 160 [Download]
- REPT Video 161 [Download]
- Converting Values to Text and Text to Values Video 162 [Download]
- NOW and TODAY Video 163 [Download]
- DATEVALUE Video 164 [Download]
- WEEKDAY Video 165 [Download]
- DATE, YEAR, MONTH and DAY Video 166 [Download]
- Using TODAY, DATE, YEAR, and MONTH to Automatically Update a Rolling Report Video 167 [Download]
- TIME Video 168 [Download]
- Time to Format Times Video 169 [Download]
- HOUR, MINUTE, and SECOND Video 170 [Download]
- CHOOSE Video 171 [Download]
- Hyperlinks Video 172 [Download]
- VLOOKUP Review Video 173 [Download]
- COLUMN with VLOOKUP Video 174 [Download]
- HLOOKUP Video 175 [Download]
- ROW with HLOOKUP Video 176 [Download]
- Drop-Down Selection Box Video 177 [Download]
- INDEX Video 178 [Download]
- MATCH Video 179 [Download]
- INDEX and MATCH Video 180 [Download]
- INDEX and MATCH x2 Video 181 [Download]
- INDEX with Areas Video 182 [Download]
- INDEX and MATCH as a Lookup Video 183 [Download]
- SUMIF Video 184 [Download]
- SUMIFS Video 185 [Download]
- COUNTIF and COUNTIFS Video 186 [Download]
- AVERAGEIF Video 187 [Download]
- AVERAGEIFS Video 188 [Download]
- Counting in Excel Video 189 [Download]
- Rounding Video 190 [Download]
- INT, LEN, and MOD Video 191 [Download]
- Convert Minutes to Hours:Minutes Video 192 [Download]
- SUMPRODUCT Video 193 [Download]
- RANDBETWEEN Video 194 [Download]
- LARGE and SMALL Video 195 [Download]
- Ranking Video 196 [Download]
- Tracing Precedents and Dependents Video 197 [Download]
- Error Checking Video 198 [Download]
- Showing and Evaluating Formulas Video 199 [Download]
- Watch Window and Calculation Options Video 200 [Download]
Advanced Charts Playlist >>
- Getting Started with OFFSET Video 87 [Download]
- Using OFFSET With Data in Columns Video 88 [Download]
- Multiple OFFSETs and COUNTA Video 89 [Download]
- Get a Drop-Down Box Without Programming Video 90 [Download]
- Using OFFSET to Create Interactive Charts Video 91 [Download]
- Using OFFSET with Bigger Ranges Video 92 [Download]
- Adding A Scroll Bar to Control Your Chart Range Video 93 [Download]
- Controlling Your Chart Range With a Spin Button Video 94 [Download]
- Check Boxes and Group Boxes Video 95 [Download]
- Turn Chart Data On and Off Video 96 [Download]
- Modifying and Deleting Chart Ranges Video 97 [Download]
- Changing Plot Order Video 98 [Download]
- Charting Hidden and Empty Cells Video 99 [Download]
- Trendlines Video 100 [Download]
- Forecasting Part 1 Video 101 [Download]
- Forecasting Part 2 Video 102 [Download]
- Forecasting Part 3 Video 103 [Download]
- Moving Averages Video 104 [Download]
- Clinical Charts Video 105 [Download]
- Error Bars Video 106 [Download]
- Introducing Sparklines Video 107 [Download]
- Adding Sparklines Video 108 [Download]
- Sparkline Groups Video 109 [Download]
- Sparklines with Text Video 110 [Download]
- Creating a Sparkline Dashboard Part 1 Video 111 [Download]
- Creating a Sparkline Dashboard Part 2 Video 112 [Download]
- Creating a Sparkline Dashboard Part 3 Video 113 [Download]
- Sparkline Markers Video 114 [Download]
- Formatting with Sparklines Video 115 [Download]
- Thermometer Charts Video 116 [Download]
- Speedometer Charts Part 1 Video 117 [Download]
- Speedometer Charts Part 2 Video 118 [Download]
- Speedometer Charts Part 3 Video 119 [Download]
- Speedometer Charts Part 4 Video 120 [Download]
- Fancier Speedometers Video 121 [Download]
- Floating Columns Video 122 [Download]
- Multiple Chart Series Types Video 123 [Download]
- Two Y Axes Video 124 [Download]
- Filling Column Charts With Pictures Video 125 [Download]
- Highlighting Chart Conclusions Video 126 [Download]
- Exploding Pie Charts Video 127 [Download]
- Pie of Pie Charts Video 128 [Download]
- Frequency Video 129 [Download]
- Frequency Charts Video 130 [Download]
- Moving Charts vs Camera Video 131 [Download]
- Copying Charts into Dashboards Video 132 [Download]
- Scrolling Chart Overview Video 133 [Download]
- Prepare the Scrolling Chart Data Video 134 [Download]
- Creating the Scrolling Charts Video 135 [Download]
- Using OFFSET to Update the Scrolling Chart Video 136 [Download]
- Updating the Scrolling Chart Data Video 137 [Download]
- Adding the Scroll Bar to the Scrolling Chart Video 138 [Download]
Basic Charts Playlist >>
- Introducing Excel 2007 Charts Video 70 [Download]
- Chart Design Options Video 71 [Download]
- Column Charts Video 72 [Download]
- Inserting Highlights Into Charts Video 73 [Download]
- Chart Titles Video 74 [Download]
- Axis Titles Video 75 [Download]
- Chart Legends Video 76 [Download]
- Data Labels Video 77 [Download]
- Data Tables Video 78 [Download]
- Horizontal Axis Options Video 79 [Download]
- Vertical Axis Options Video 80 [Download]
- Gridlines Video 81 [Download]
- Plot Area Video 82 [Download]
- Adding Contiguous Data to a Chart Manually and Automatically Video 83 [Download]
- Adding Noncontiguous Data to a Chart Video 84 [Download]
- Automatically Updating Charts with OFFSET Video 85 [Download]
- Creating and Using Names in Charts Video 86 [Download]
VLOOKUP Playlist >>
- Introducing VLOOKUP Video 61 [Download]
- Multiple VLOOKUP Columns Video 62 [Download]
- Exact vs Approximate Match and IFERROR Video 63 [Download]
- Matching Data Types for VLOOKUP Video 64 [Download]
- Concatenate to VLOOKUP Video 65 [Download]
- When VLOOKUP is True Video 66 [Download]
- VLOOKUP in Two Tables Video 67 [Download]
- Nesting Functions in VLOOKUP Video 68 [Download]
- VLOOKUP x 2 Video 69 [Download]
Conditional Formatting Playlist >>
- Introducing Conditional Formatting Video 44 [Download]
- Highlight Cells Rules Part 1 Video 45 [Download]
- Highlight Cells Rules Part 2 Video 46 [Download]
- Top Bottom Rules Video 47 [Download]
- Data Bars Video 48 [Download]
- Color Scales Video 49 [Download]
- Icon Sets, Part 1 Video 50 [Download]
- Icon Sets, Part 2 Video 51 [Download]
- Format Based on Values Video 52 [Download]
- Conditional Formatting Errors and Blanks Video 53 [Download]
- Top or Bottom Rules Video 54 [Download]
- Above or Below Average Video 55 [Download]
- Formulas in Conditional Formatting Video 56 [Download]
- Find and Clear Conditional Formatting Video 57 [Download]
- Manage Rules Video 58 [Download]
- Manage Conflicting Rules Video 59 [Download]
- Stop if True Video 60 [Download]
Tables Playlist >>
- Introducing Tables in Excel 2007 Video 30 [Download]
- Adding Data to a Table Video 31 [Download]
- Totals in Tables Video 32 [Download]
- Filtering Dates in Tables Video 33 [Download]
- Filtering Text in Tables Video 34 [Download]
- Filtering Numbers in Tables Video 35 [Download]
- Filtering by Color in Tables Video 36 [Download]
- Advanced Table Filtering Video 37 [Download]
- Sorting Tables Video 38 [Download]
- More Sorting Tricks in Tables Video 39 [Download]
- Table Styles Video 40 [Download]
- More Design Tricks in Tables Video 41 [Download]
- Table Design Tools Video 42 [Download]
- Table References Video 43 [Download]
Pivot Table Playlist >>
- Create a Pivot Table Video 1 [Download]
- Sorting a Pivot Table Video 2 [Download]
- Filtering a Pivot Table Video 3 [Download]
- Grouping Pivot Table Fields Video 4 [Download]
- Grouping Text in Pivot Tables Video 5 [Download]
- Drilling Down in Pivot Tables Video 6 [Download]
- Multiple Rows and Columns in Pivot Tables Video 7 [Download]
- Label Filters in Pivot Tables Video 8 [Download]
- Value Filters in Pivot Tables Video 9 [Download]
- Multiple Pivot Table Value Fields Video 10 [Download]
- Sum and Count Pivot Table Values Video 11 [Download]
- Pivot Table Design Tricks Video 12 [Download]
- GETPIVOTDATA Video 13 [Download]
- Pivot Table Formulas Video 14 [Download]
- Refreshing Pivot Table Data Video 15 [Download]
- Pivot Table Calculated Fields Video 16 [Download]
- Top x Value Filter Video 17 [Download]
- Consolidating Multiple Ranges into one Pivot Table, Part 1 Video 18 [Download]
- Consolidating Multiple Ranges into one Pivot Table, Part 2 Video 19 [Download]
- Consolidating Multiple Ranges into one Pivot Table, Part 3 Video 20 [Download]
- Consolidating Multiple Ranges into one Pivot Table, Part 4 Video 21 [Download]
- Pivot Table Options, Part 1 Video 22 [Download]
- Grand Totals and Custom Lists Video 23 [Download]
- Pivot Table Display Options Video 24 [Download]
- Pivot Table Printing and Data Options Video 25 [Download]
- Grouping Numbers in Pivot Tables Video 26 [Download]
- Introduction to Pivot Charts Video 27 [Download]
- Pivot Chart Example Video 28 [Download]
- Quick Pivot Charts from Existing Pivot Tables Video 29 [Download]
