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: 5 Reasons to Use KelaPro Instead of a Canned Report
Watch More Videos >>
Current Playlist >>
- 5 Reasons to Use KelaPro Instead of a Canned Report [Download]
- More KelaPro Calculations in Pivot Tables [Download]
- Calculations Using KelaPro Data in Pivot Tables [Download]
- Grouping KelaPro Data in Pivot Tables [Download]
- 5 More Reasons KelaPro Beats Canned Reports [Download]
- Three Ways to get Your Data in Excel Video 228 [Download]
- Custom Headers and Footers Video 227 [Download]
- Headers and Footers Video 226 [Download]
- Page Setup Video 225 [Download]
- Page Break Preview Video 224 [Download]
- Page Breaks, Backgrounds, and Print Titles Video 223 [Download]
- Setting Margins and Print Area Video 222 [Download]
- Printing Basics Video 221 [Download]
- Recent Workbooks and New Workbooks Video 220 [Download]
- File Menu Basics Video 219 [Download]
- Custom Date Formats Video 218 [Download]
- Number and Date Formats Video 217 [Download]
- Orienting Cells Video 216 [Download]
- Two Ways to Center Data Video 215 [Download]
- Wrap Text and Alt+Enter Video 214 [Download]
- Format Cells Part 3 Video 213 [Download]
- Format Cells Part 2 Video 212 [Download]
- Format Cells Part 1 Video 211 [Download]
- 4 More Navigation Shortcuts Video 210 [Download]
- Shift + End + Arrow Key Video 209 [Download]
- Selecting Cells with the Control and Shift Keys Video 208 [Download]
- Format Painter Video 207 [Download]
- Paste Special Video 206 [Download]
- PASTE Video 205 [Download]
- COPY Video 204 [Download]
- CUT Video 203 [Download]
- Quick Access Toolbar Part 2 Video 202 [Download]
- Quick Access Toolbar, Part 1 Video 201 [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]