Welcome to the archive


No Article
1 Financial functions – PMT to RATE
2 Financial functions – A to PD
3 Engineering functions – IMD to Z
4 Engineering functions – D to IMC
5 Engineering functions – A to C
6 Date and Time Functions – N to Z
7 Date and Time Functions – A to M
8 Compatibility Functions
9 Array Manipulation Functions
10 How to use the KURT function
11 How to use the HARMEAN function
12 How to use the MAKEARRAY function
13 How to use the BYROW function
14 How to use the BYCOL function
15 How to use the SCAN function
16 How to use the MAP function
17 How to use the REDUCE function
18 How to use the HYPGEOM.DIST function
19 How to track sector performance in the stock market – Excel template
20 How to use the IMPOWER function
21 How to use the asterisk character
22 How to use the VALUETOTEXT function
23 How to use the ARRAYTOTEXT function
24 How to decode URL-encoded strings
25 How to use the IMAGE function
26 How to use the LAMBDA function
27 How to use the REPLACE function
28 How to use the WRAPROWS function
29 How to use the TEXTSPLIT function
30 How to use the TEXTAFTER function
31 How to use the TEXTBEFORE function
32 How to use the STOCKHISTORY function
33 How to use the XMATCH function
34 How to use the LET function
35 How to use the XLOOKUP function
36 How to use the FILTERXML function
37 How to use the ROUND function
38 How to use the RANDARRAY function
39 How to use the SEQUENCE function
40 How to use the SORTBY function
41 How to use the SORT function
42 How to use the FILTER function
43 How to use the UNIQUE function
44 How to solve simultaneous linear equations in Excel
45 How to use the XNPV function
46 How to use the RRI function
47 How to do tiered calculations in one formula
48 How to use the ROUNDDOWN function
49 How to use the ROUNDUP function
50 Excel charts tips and tricks
51 How to use the VDB function
52 How to use the AMORDEGRC function
53 How to use the YIELD function
54 How to use the SYD function
55 How to use the TBILLEQ function
56 How to use the TBILLPRICE function
57 How to use the TBILLYIELD function
58 How to use the UNICODE function
59 How to use the UNICHAR function
60 How to use the PERCENTRANK.EXC function
61 How to use the PERCENTRANK.INC function
62 How to use the QUARTILE.EXC function
63 How to use the LOGNORM.DIST function
64 Conditional Formatting Basics
65 How to use the LOG10 function
66 How to use the LOGEST function
67 How to use the LINEST function
68 How to use the GAMMA.DIST function
69 Calculate the number of weeks between given dates
70 How to add chart elements
71 How to use the F.TEST function
72 Excel VBA functions
73 How to use the INTERCEPT function
74 How to use the F.DIST.RT function
75 How to use the F.DIST function
76 How to use the BINOM.INV function
77 How to use the CHISQ.TEST function
78 How to use the COVARIANCE.S function
79 How to use the COVARIANCE.P function
80 How to use the COTH function
81 How to use the XOR function
82 How to use the CHISQ.INV.RT function
83 How to use the CHISQ.INV function
84 How to use the CHISQ.DIST.RT function
85 How to use the CHISQ.DIST function
86 How to use the BINOM.DIST function
87 How to use the BETA.INV function
88 How to use the BETA.DIST function
89 How to use the RANK.EQ function
90 How to use the CONFIDENCE.T function
91 How to use the CONFIDENCE.NORM function
92 How to use the MODE.SNGL function
93 How to use the FLOOR.PRECISE function
94 How to use the CSC function
95 How to use the GROWTH function
96 How to use the ERROR.TYPE function
97 How to use the GCD function
98 How to use the GEOMEAN function
99 How to use the SLOPE function
100 How to use the RANGE.FIND method
101 How to use the SKEW function
102 How to use the PROB function
103 How to use the PHI function
104 How to use the CONCATENATE function
105 Get date ranges from a schedule
106 How to replace part of formula in all cells
107 Copy data from workbooks in folder and subfolders
108 How to position month and year between chart tick marks
109 How to copy non contiguous cell ranges
110 Search for a file in folder and subfolders [UDF]
111 How to use the MUNIT function
112 How to use the RAND function
113 How to use the MULTINOMIAL function
114 How to use the MINIFS function
115 How to use the MINA function
116 How to use the MINVERSE function
117 How to use the NORM.INV function
118 Advanced Excel Chart Techniques
119 How to use the NORM.DIST function
120 How to use the WEBSERVICE function
121 How to create charts in Excel
122 How to use the VAR.S function
123 How to use the VAR.P function
124 How to use the FORECAST.LINEAR function
125 Count cells with text
126 Count rows containing data
127 How to use the BITLSHIFT function
128 How to use the BITAND function
129 How to use the BASE function
130 How to use the AVEDEV function
131 How to use the ATANH function
132 How to use the ATAN2 function
133 How to use the ATAN function
134 How to use the ASINH function
135 How to use the ASIN function
136 How to use the ASC function
137 How to use the ACOTH function
138 How to use the ACOT function
139 How to use the ACOSH function
140 How to use the ACOS function
141 How to use the NA function
142 How to use the TYPE function
143 How to use the TRUNC function
144 How to use the TRIMMEAN function
145 How to use the TREND function
146 How to use the SERIESSUM function
147 How to use the SECH function
148 How to use the COT function
149 How to use the COSH function
150 How to use the SINH function
151 How to use the TANH function
152 How to use the SUMXMY2 function
153 How to use the SUMX2PY2 function
154 How to use the SUMX2MY2 function
155 How to use the SUMSQ function
156 How to use the STDEVPA function
157 How to use the STANDARDIZE function
158 How to use the STDEV.S function
159 How to use the STDEV.P function
160 How to use the SEC function
161 How to use the RANK.AVG function
162 How to use the QUARTILE.INC function
163 How to use the FLOOR.MATH function
164 How to sum overlapping time
165 How to use the FIXED function
166 How to use the FACTDOUBLE function
167 How to use the EXPON.DIST function
168 How to use the ENCODEURL function
169 How to use the DECIMAL function
170 How to use the CORREL function
171 How to use the CONCAT function
172 How to use the CEILING function
173 How to use the AVERAGEA function
174 How to use the AREAS function
175 How to use the LCM function
176 How to use the SWITCH function
177 How to use the STDEVA function
178 How to use the SHEETS function
179 How to use the SHEET function
180 How to use the MROUND function
181 How to use the NOT function
182 How to use the SQRT function
183 How to use the SIGN function
184 How to use the T function
185 How to use the N function
186 How to use the MODE.MULT function
187 How to use the MEDIAN function
188 How to use the LOG function
189 How to use the LN function
190 How to use the INFO function
191 How to use the PERMUTATIONA function
192 How to use the COMBINA function
193 How to use the PRODUCT function
194 Rearrange values in a cell range to a single column
195 Get the latest revision
196 How to use the TRUE function
197 How to use the DEGREES function
198 How to use the RADIANS function
199 How to use the PI function
200 How to use the FORMULATEXT function
201 How to use the ISFORMULA function
202 How to use the ISODD function
203 How to use the ISERR function
204 How to use the FIND function
205 How to use the ISNA function
206 How to use the ISREF function
207 How to use the ISNONTEXT function
208 How to use the ISLOGICAL function
209 How to use the ISTEXT function
210 How to use the ISERROR function
211 How to use the ISBLANK function
212 How to use the POWER function
213 How to extract numbers from a cell value
214 How to use the VALUE function
215 How to use the DO LOOP statement
216 How to use the TAN function
217 How to use the COS function
218 How to use the SIN function
219 How to use the EVEN function
220 How to use the EXP function
221 How to use the RANDBETWEEN function
222 How to use the FALSE function
223 How to use the FACT function
224 How to use the IFNA function
225 How to use the IFS function
226 How to use the INT function
227 How to use the CLEAN function
228 How to use the COMBIN function
229 How to use the PERMUT function
230 How to use the LEN function
231 How to use the COUNTBLANK function
232 How to use the COUNTA function
233 How to use the COLUMNS function
234 How to use the ROWS function
235 How to use the MAX function
236 How to use the MAXIFS function
237 How to use the LARGE function
238 How to use the CELL function
239 How to use the COUNT function
240 How to use the CHAR function
241 How to use the CODE function
242 How to use the COLUMN function
243 How to use the FOR NEXT statement
244 How to use the AVERAGEIFS function
245 How to use the AVERAGEIF function
246 How to use the AGGREGATE function
247 How to use the ADDRESS function
248 How to use the ISNUMBER function
249 How to use the LOWER function
250 How to use the REPT function
251 How to use the SUBSTITUTE function
252 How to use the UPPER function
253 How to use the EXACT function
254 How to use the IF THEN ELSE ELSEIF END IF statement [VBA]
255 How to use the TRIM function
256 How to remove numbers from a cell value
257 How to use the ABS function
258 Extract specific word based on position in cell value
259 How to use the RIGHT function
260 How to use the LEFT function
261 How to use the MID function
262 How to use the MIN function
263 How to use the SUMIFS function
264 How to use the CHOOSE function
265 Count cells containing text from list
266 AVERAGE based on criteria
267 If cell contains multiple values
268 SMALL function – INDEX MATCH
269 How to ignore zeros using the SMALL function
270 SMALL function – multiple conditions
271 SMALL function for text
272 AVERAGE ignore NA()
273 How to AVERAGE time
274 AVERAGE ignore blanks
275 How to use the AVERAGE function
276 SMALL function ignore duplicates
277 SUMPRODUCT and nested IF functions
278 SUMPRODUCT if not blank
279 SUMPRODUCT and IF function
280 SUMPRODUCT – multiple criteria
281 INDEX MATCH – Case sensitive
282 Excel formula not working
283 INDEX MATCH – multiple results
284 Match two columns and return another value on the same row
285 If cell equals value from list
286 How to use the SUBTOTAL function
287 If cell contains text from list
288 IF with OR function
289 INDEX MATCH with multiple criteria
290 How to use the COUNTIF function to count not blank cells
291 If cell contains text
292 How to use the OR function
293 How to use the AND function
294 Use IF + COUNTIF to evaluate multiple conditions
295 IF function with AND function – multiple conditions
296 How to use nested IF functions
297 How to use the HYPERLINK function
298 How to use the TEXT function
299 How to use the SUMIF function
300 Distribute values across numerical ranges
301 How to create running totals
302 Rearrange values using formulas
303 User opens or closes a workbook creates an event
304 How to extract a case sensitive unique list from a column
305 Count unique distinct values based on a condition
306 Extract a list of alphabetically sorted duplicates based on a condition
307 Extract duplicate values with exceptions
308 Filter duplicate values based on criteria
309 Find last value in a column
310 Lookup and match last value – reverse lookup
311 Use VLOOKUP and return multiple values sorted from A to Z
312 Concatenate unique distinct values
313 How to use the SUM function
314 How to use the HLOOKUP function
315 How to use the VLOOKUP function
316 Partial match and return value with highest level
317 Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses
318 Count matching strings using regular expressions
319 Split search value using a delimiter and search for each substring
320 Fetching values from ThingSpeak programmatically
321 How to use Excel Tables
322 Rotating unique groups with no repeat
323 Time sheet for work
324 Extract cell references from a formula
325 How to extract rows containing digits [Formula]
326 How to use the LIKE OPERATOR
327 Calendar – monthly view
328 How to generate a round-robin tournament
329 List permutations with repetition and how many to choose from
330 How to use DIALOG BOXES
331 List all permutations with a condition
332 How to use Pivot Tables – Excel’s most powerful feature and also least known
333 How to use the TEXTJOIN function
334 Working with ARRAY VARIABLES (VBA)
335 How to calculate and plot pivots on an Excel chart
336 Count identical values if they are on the same row
337 Compare two columns in different worksheets
338 Sort values by corresponding text arranged in a column
339 Sort items by adjacent number in every other value
340 Multiply numbers in each row by entire cell range
341 Resize a range of values (UDF)
342 Follow stock market trends – trailing stop
343 Follow stock market trends – Moving Average
344 Dynamic stock chart
345 Find and return the highest number and corresponding date based on a condition
346 How to add horizontal line to chart
347 A beginners guide to Excel array formulas
348 How to color chart bars based on their values
349 Count overlapping days across multiple date ranges
350 How to improve your Excel Chart
351 How to use the TRANSPOSE function
352 Calculate time between time zones
353 Find and replace strings in file names, folder name and subfolders
354 Sum numerical ranges between two numbers
355 Sort based on frequency row-wise
356 Count overlapping days in multiple date ranges, part 2
357 Count overlapping days in multiple date ranges
358 Find empty dates in a set of date ranges
359 Dynamic scoreboard
360 Working with overlapping date ranges
361 How to calculate overlapping time ranges
362 How to build a Team Generator – different number of people per team
363 Working with LIST BOXES (Form Controls)
364 Split expenses calculator
365 How to count repeating values
366 List all hyperlinks in worksheet programmatically
367 How to automatically add new items to a drop down list
368 How to use the QUOTIENT function
369 Return all combinations
370 Find numbers closest to sum
371 Filter duplicate files in a folder and subfolders
372 Compare file names in two different folder locations and their sub folders
373 How to save specific multiple worksheets to a pdf file programmatically
374 Find cells containing formulas with literal (hardcoded) values
375 How to use the LOOKUP function
376 How to use the INDIRECT function
377 Find the most/least consecutive repeated value [VBA]
378 How to use the TEXTTOCOLUMNS method
379 How to count the number of values separated by a delimiter
380 Extract the most repeated adjacent values in a column
381 Search for a sequence of cells based on wildcard search
382 Search for a sequence of values
383 Search all workbooks in a folder and sub folders – VBA
384 Working with comments – VBA
385 Add pictures to a chart axis
386 How to group items by quarter using formulas
387 Working with Excel tables programmatically
388 How to highlight row of the selected cell programmatically
389 A quicker A * pathfinding algorithm
390 How to use the MOD function
391 Finding the shortest path – A * pathfinding
392 Working with classic ciphers in Excel
393 Move data to workbooks
394 How to use the Subtotal tool
395 Print screen the entire worksheet
396 Highlight unique values in a filtered Excel table
397 Customize Excel maze
398 Solve a maze programmatically in Excel
399 Build a maze programmatically in Excel
400 Merge tables based on a condition
401 Lookup value based on two critera – second criteria is the adjacent value and its position in a given list
402 Find last matching value in an unsorted list
403 Multi-level To-Do list template
404 How to animate an Excel chart
405 Sort by multiple columns
406 Search all workbooks in a folder
407 All you need to know about calculating NAV units for your stock portfolio
408 Lookup and return multiple sorted values based on corresponding values in another column
409 Customize the ribbon and how to add your macros
410 Identify rows of overlapping records
411 Remove print preview lines (Page Breaks)
412 Compare two columns and extract differences
413 How to filter chart data
414 Working with TEXT BOXES [Form Controls]
415 Show / hide a picture using a button
416 Wildcard lookups and include or exclude criteria
417 Lookup with any number of criteria
418 Hide specific worksheets programmatically
419 How to use the Scroll Bar
420 Count Conditionally Formatted cells
421 Count cells based on background color
422 Find earliest and latest overlapping dates in a set of date ranges based on a condition
423 How to select and delete blank cells
424 Prevent duplicate records in a worksheet
425 Color chart columns based on cell color
426 Count unique distinct values by cell color
427 Pivot Table calendar
428 Highlight date ranges overlapping selected record [VBA]
429 Practice basic arithmetic calculations in Excel
430 Which Excel files in folder are password protected?
431 Count text string in all formulas in a worksheet [VBA]
432 Easily select data using hyperlinks
433 Navigate to first empty cell using a hyperlink formula
434 How to use the IFERROR function
435 Create a hyperlink linked to the result of a two-dimensional lookup
436 How to generate random numbers and text
437 Compare data in an Excel chart using drop down lists
438 Locate a shape in a workbook
439 Hover with mouse cursor to change stock in a candlestick chart
440 Find all sequences of consecutive dates
441 How to use the FREQUENCY function
442 Heat map using pictures
443 How to use the SUMPRODUCT function
444 How to build an interactive map in Excel
445 How to use the SEARCH function
446 Yet another Excel Calendar
447 How to use the MMULT function
448 How to use the SMALL function
449 Working with FILES
450 Assign records unique random text strings
451 How to use the ROW function
452 Highlight duplicates in a filtered Excel Table
453 How to use the COUNTIFS function
454 How to use the IF function
455 How to use the COUNTIF function
456 Units contained in a range that overlap another range
457 How to use the MATCH function
458 How to use the INDEX function
459 How to change a picture in a worksheet dynamically [VBA]
460 Count specific multiple text strings in a given cell range
461 Move a shape [VBA]
462 How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
463 Convert array formula to a regular formula
464 Highlight group of values in an x y scatter chart programmatically
465 Highlight a data series in a chart
466 Highlight events in a yearly calendar
467 Repeat values across cells
468 Merge two relational data sets
469 Lookup multiple values in one cell
470 Run a Macro from a Drop Down list [VBA]
471 Advanced Techniques for Conditional Formatting
472 Prevent overlapping date and time ranges using data validation
473 Group rows based on a condition
474 Working with date ranges
475 Analyze trends using pivot tables
476 Compare the performance of your stock portfolio to S&P 500 using Excel
477 How to use VLOOKUP/XLOOKUP with multiple conditions
478 Highlight lookups in relational tables
479 Working with three relational tables
480 Extract unique distinct values from a relational table
481 How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
482 Lookups in relational tables
483 Copy worksheets in active workbook to new workbooks
484 Filter values that exists in all three columns
485 Search related table based on a date and date range
486 Excel calendar
487 Populate drop down list with filtered Excel Table values
488 Use drop down lists and named ranges to filter chart values
489 Shift Schedule
490 Extract cell references populated with values [VBA]
491 How to use mouse hover on a worksheet [VBA]
492 Sort values in a cell based on a delimiting character
493 Macro creates links to all sheets, tables, pivot tables and named ranges
494 Count unique distinct values in a filtered Excel defined Table
495 Create links to all sheets in a workbook programmatically
496 Create new worksheets programmatically based on values in a cell range [VBA]
497 Change chart axis range programmatically
498 List files in folder and create hyperlinks (VBA)
499 Plot buy and sell points in an Excel Chart based on two moving averages
500 Add buy and sell points to a stock chart
501 How to create an interactive Excel chart [VBA]
502 Prepare data for Pivot Table – How to split concatenated values?
503 Lookup multiple values across columns and return a single value
504 Excel template: Getting Things Done [VBA]
505 Create date ranges that stay within month
506 Add values to a two-dimensional table based on conditions [VBA]
507 Unique distinct records sorted based on count or frequency
508 Count groups of repeated values per row
509 Use a drop down list to filter and concatenate unique distinct values
510 Add or remove a value in a drop down list programmatically
511 Open Excel files in a folder [VBA]
512 Auto populate a worksheet
513 Partial match and return multiple adjacent values
514 Toggle a macro on/off using a button
515 Use a drop down list to display data in worksheet header [VBA]
516 Automate data entry [VBA]
517 Apply drop-down lists dynamically
518 Working with Conditional Formatting formulas
519 How to create random numbers, text strings, dates and time values
520 Dependent drop-down lists in multiple rows
521 Watch schedule that populates vacation time
522 Auto resize columns as you type
523 Copy a dynamic cell range [VBA]
524 Label groups of duplicate records
525 Working with COMBO BOXES [Form Controls]
526 Use a drop down list to search and return multiple values
527 How to create permutations
528 Extract unique distinct values in a filtered list
529 Add checkboxes and copy values – VBA
530 Count cells between specified values
531 Add values to a regular drop-down list programmatically
532 Rearrange data
533 Extract unique distinct values based on a filtered Excel defined Table
534 Two-way lookup in multiple cross reference tables simultaneously
535 Remove common records between two data sets
536 Filter unique distinct values, sorted and blanks removed from a range
537 Vlookup across multiple sheets
538 Count unique distinct values that meet multiple criteria
539 Vlookup a cell range and return multiple values
540 How to save custom functions and macros to an Add-In
541 Search each column for a string each and return multiple records – OR logic
542 How to compare two data sets
543 VLOOKUP – Return multiple unique distinct values
544 Filter unique distinct records case sensitive
545 Create a dynamic named range
546 How to create a dynamic pivot table and refresh automatically
547 Bill reminder in excel
548 Running totals based on criteria
549 How to highlight differences and common values in lists
550 Analyze word frequency in a cell range
551 Fuzzy lookups
552 Fuzzy VLOOKUP
553 A Comprehensive Guide to Splitting Text in Excel
554 Filter strings containing a given substring in a cell range
555 Filter overlapping date ranges
556 Concatenate cell values
557 Tracking a stock portfolio #2
558 Create a drop down calendar
559 Monthly calendar template
560 Count unique distinct records
561 Compare tables: Filter records occurring only in one table
562 Lookup and return multiple values concatenated into one cell
563 Create a Print button – macro
564 Save invoice data – VBA
565 Extract unique distinct values based on the 4 last characters
566 Apply dependent combo box selections to a filter
567 Sort rows based on frequency and criteria
568 True round-robin tournament
569 Create a random playlist
570 Team Generator
571 Filter unique strings from a cell range
572 Vlookup with multiple matches returns a different value
573 Extract a unique distinct list and sum amounts based on a condition
574 Populate cells dynamically in a weekly schedule
575 Create numbers based on numerical ranges
576 Find empty hours in a weekly schedule
577 Create dependent drop down lists containing unique distinct values
578 Extract a unique distinct list sorted from A to Z ignore blanks
579 Extract dates from overlapping date ranges
580 Convert date ranges into dates
581 List dates outside specified date ranges
582 Plot date ranges in a calendar
583 How to use absolute and relative references
584 Identify overlapping date ranges
585 Merge two columns with possible blank cells
586 List all unique distinct rows in a given month
587 Filter duplicates within same date, week or month
588 Remove duplicates within same month or year
589 Automate net asset value (NAV) calculation on your stock portfolio
590 Split data across multiple sheets – VBA
591 Merge Ranges Add-In
592 Match two criteria and return multiple records
593 Create number series
594 Extract unique distinct values if the value contains the given string
595 How to return a value if lookup value is in a range
596 VLOOKUP/XLOOKUP of three columns to pull a single record
597 Excel solver examples
598 Identify numbers in sum using Excel solver
599 Formula for matching a date within a date range
600 Find the most recent date that meets a particular condition
601 Most frequent value between two dates
602 Create a quartely date range
603 5 easy ways to VLOOKUP and return multiple values
604 Extract unique distinct values sorted based on sum of adjacent values
605 Filter unique values from a cell range
606 Filter unique values sorted from A to Z
607 Extract all rows from a range that meet criteria in one column
608 Create unique distinct list sorted based on text length
609 How to list unique distinct values sorted by frequency
610 Extract unique distinct values sorted from A to Z
611 Extract numbers from a column
612 Extract unique distinct values A to Z from a range and ignore blanks
613 Find min and max unique and duplicate numerical values
614 Reverse a list ignoring blanks
615 Perform multiple partial matches and return records – AND logic
616 Filter values in common between two cell ranges
617 Filter values occurring in range 1 but not in range 2
618 Sort a range from A to Z [Array formula]
619 Extract duplicates from a multi-column cell range
620 Search for a text string in a data set and return multiple records
621 Count a specific text string in a cell
622 Sort text cells alphabetically from two columns
623 Merge cell ranges into one list
624 How to perform a two-dimensional lookup
625 Extract a list of duplicates from three columns combined
626 Extract a list of duplicates from a column
627 Extract a unique distinct list from three columns
628 Extract a unique distinct list from two columns
629 How to create date ranges in Excel
630 Find missing numbers
631 Count unique distinct values
632 Split values equally into groups
633 Populate drop down list with unique distinct values sorted from A to Z
634 How to highlight duplicate values
635 Lookup the nearest date
636 Partial match with two conditions and return multiple results
637 Filter unique distinct values based on a date range
638 Advanced Date Highlighting Techniques in Excel
639 How to rank text uniquely without duplicates
640 Sort column based on frequency
641 Partial match for multiple strings – AND logic
642 Sum unique numbers
643 Extract a unique distinct list sorted from A to Z
644 How to quickly find the maximum or minimum value [Formula]
645 Working with unique values
646 5 easy ways to extract Unique Distinct Values
647 Sort a column alphabetically
648 Extract unique distinct values from a multi-column cell range
649 Calculate machine utilization
650 Extract a unique distinct list and ignore blanks
651 Extract records between two dates
652 Extract shared values between two columns
653 How to extract email addresses from an Excel sheet
654 Filter unique distinct records
655 What values are missing in List 1 that exists i List 2?
656 Find closest value
657 How to use the OFFSET function
658 Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
659 Find the smallest number in a list that is larger than a given number
660 Print consecutive page numbers across multiple worksheets
661 Excel chart components
662 How to improve worksheet readability in Excel