Slide 201 [Counting only text (non-numeric, non-error, non-empty) entries in a range]
Slide 202 [Formatting numbers for Indian Rupee.]
Slide 203 [Converting seconds to minutes and seconds, or to hours, minutes, and seconds]
Slide 204 [Counting numbers in a list that are positive, negative, or zero]
Slide 205 [Counting odd and even numbers in a range]
Slide 206 [Summing and averaging the last 3 (for example) numbers along a row]
Slide 207 [Returning the year's week number of a date]
Slide 208 [Verifying a text entry's true upper case]
Slide 209 [Conditionally formatting a month's number as even or odd based on dates]
Slide 210 [Getting information about a month based on one of its dates]
Slide 211 [Analyzing data based on specified alphanumeric characters]
Slide 212 [Summing or averaging numbers in alphanumeric strings beginning with specified characters]
Slide 213 [Using the spacebar operator to sum the intersection of two named ranges.]
Slide 214 [Formatting a zero to look like -0- (with a dash on either side)]
Slide 215 [Expanding the formula bar -- two methods]
Slide 216 [Averaging numbers between upper and lower limits]
Slide 217 [Summing and averaging numbers based on dates in a specified month]
Slide 218 [Returning the last row of a filtered table]
Slide 219 [Using the name box to enter and get help with functions]
Slide 220 [Parsing a decimalized number into its integer and decimal portions]
Slide 221 [Toggling to show or hide the Ribbon -- two methods]
Slide 222 [Listing a few rules and tips for VBA variable names]
Slide 223 [Explaining VBA's OR logical operator]
Slide 224 [From a list of values, randomly return any one cell's value]
Slide 225 [Explaining the VBA IIF (yes, that's I-I-F) conditional function]
Slide 226 [Generating a random whole number between any two numbers]
Slide 227 [Conditionally format the largest number in each row]
Slide 228 [Creating a list without blanks from a list with blanks]
Slide 229 [Filling the space in a cell from its left edge to the start of its numeric contents]
Slide 230 [Filling cell contents with a trailing character]
Slide 231 [Preventing the addition of new worksheets]
Slide 232 [Printing pages with the workbook's name in all footers]
Slide 233 [Automatically go to cell A1 for any activated worksheet]
Slide 234 [Controlling the times of day a workbook can be saved]
Slide 235 [Pre-sorting your UserForm's ListBox and ComboBox items]
Slide 236 [Showing the Add-Ins dialog box with a keyboard shortcut]
Slide 237 [Parsing a cell's value into 1 character per cell]
Slide 238 [Showing your computer's System information with a keyboard shortcut]
Slide 239 [Exporting data from each worksheet into its own text file]
Slide 240 [Recording the dates and times in a text file that your workbook gets saved]
Slide 241 [Formatting cell values to their column width without changing font size or column width]
Slide 242 [Showing your File Explorer directory with a keyboard shortcut]
Slide 243 [Finding your Excel Templates path]
Slide 244 [Converting military time to conventional AM/PM time]
Slide 245 [Looking up the column and row header labels of minimum and maximum numbers in a range]
Slide 246 [Showing an example of the PMT function]
Slide 247 [Returning the first and last numbers in a row, ignoring text and blank cells]
Slide 248 [Looking up the oldest date for a specified name having many repeats]
Slide 249 [Looking up the cell address of a unique item in a list]
Slide 250 [Calculating ages in years, months, and days]
Slide 251 [Returning everything to the right of the nth character]
Slide 252 [Finding the row of the first empty cell in a list]
Slide 253 [Counting multiple criteria items in a list with various other items]
Slide 254 [Summing every other cell along a row]
Slide 255 [Doing a horizontal lookup to find a cell's address]
Slide 256 [Extracting the first word in a string, or the entire text if there are no spaces]
Slide 257 [Summing two cells, but if both cells are blank, the sum cell is blank not showing zero]
Slide 258 [Creating a named range with the keyboard shortcut Ctrl+Shift+F3]
Slide 259 [Searching for a word or string inside another string]
Slide 260 [Using the last number in a list in a formula]
Slide 261 [Fusing 2 staggered lists into 1 list with Paste Special's Skip blanks]
Slide 262 [Bypassing data validation with a custom formatted reminder text for improper data entry.]
Slide 263 [Further customizing Social Security Numbers beyond the built-in Special category]
Slide 264 [Counting cells in a range that contain an error value]
Slide 265 [Calculating the percentage of numbers in a list that are positive, negative, and zero]
Slide 266 [Rounding a number to its nearest Nth whole number]
Slide 267 [Isolating and/or omitting parentheses and their contents]
Slide 268 [Converting a decimal number to an AM/PM time]
Slide 269 [Summing numbers in one column depending on text values in 3 other columns on the same row]
Slide 270 [Concatenating text with a formatted percentage calculation]
Slide 271 [Counting weekdays in a list of dates]
Slide 272 [Returning the first positive or negative number in a list]
Slide 273 [Counting numbers in a list that are greater than or equal to a specified number]
Slide 274 [Summing numbers in one column for a matching criteria date of varying formats]
Slide 275 [Counting specified text in two columns on the same row]
Slide 276 [Counting dates in a list that fall into a specified year]
Slide 277 [Counting occupied or blank cells while disregarding one cell]
Slide 278 [Adding or removing borders around selected cells using keyboard shortcuts]
Slide 279 [Locating a specified character's first position in a string]
Slide 280 [Calculating the absolute sum of differences]
Slide 281 [Showing 2 options to round numbers to their nearest hundred thousand]
Slide 282 [Showing the Spelling dialog box with a keyboard shortcut]
Slide 283 [Showing the Thesaurus in Excel using a keyboard shortcut]
Slide 284 [Getting the most-repeated value in a list]
Slide 285 [Getting the column number and letter of the last cell in a row that contains a number]
Slide 286 [Generating a random time between two times]
Slide 287 [Rounding times to their previous, next, and nearest quarter hour]
Slide 288 [Filling a range of cells with the value from a single cell]
Slide 289 [Finding the row and column with the largest and smallest number]
Slide 290 [Ranking to ignore zeroes and blank cells]
Slide 291 [Counting for a month, and for a year and month, in a list of dates]
Slide 292 [Listing a running count of repeated items]
Slide 293 [Counting blank and non-blank cells in a range]
Slide 294 [Showing different function results for parsed positive and negative decimal numbers]
Slide 295 [Getting your operating system's name and version from Excel]
Slide 296 [Counting unique entries in a list, ignoring text]
Slide 297 [Getting the first, second, and third most frequent value in a list, considering blank cells]
Slide 298 [Returning the last positive or negative number in a list]
Slide 299 [Summing a range of numbers formatted as Text]
Slide 300 [Showing the HYPERLINK function's link address with descriptive text ]