``` 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 ] ```