Welcome to the archive


No Article
1 How to use the GROUPBY function
2 Complex Calculations: A Guide to Excel’s IM Functions
3 Engineering functions – D to IMC
4 Compatibility Functions
5 How to use the KURT function
6 How to use the HARMEAN function
7 How to use the MAKEARRAY function
8 How to use the BYROW function
9 How to use the BYCOL function
10 How to use the SCAN function
11 How to use the MAP function
12 How to use the REDUCE function
13 How to use the HYPGEOM.DIST function
14 How to track sector performance in the stock market – Excel template
15 How to use the asterisk character
16 How to use the VALUETOTEXT function
17 How to use the ARRAYTOTEXT function
18 How to use the HEX2BIN function
19 How to use the HEX2DEC function
20 How to use the IMAGE function
21 How to use the LAMBDA function
22 How to use the REPLACE function
23 How to use the EXPAND function
24 How to use the CHOOSECOLS function
25 How to use the CHOOSEROWS function
26 How to use the DROP function
27 How to use the TAKE function
28 How to use the WRAPCOLS function
29 How to use the WRAPROWS function
30 How to use the TOROW function
31 How to use the TOCOL function
32 How to use the HSTACK function
33 How to use the VSTACK function
34 How to use the TEXTSPLIT function
35 How to use the TEXTAFTER function
36 How to use the TEXTBEFORE function
37 How to use the STOCKHISTORY function
38 How to use the XMATCH function
39 How to use the LET function
40 How to use the XLOOKUP function
41 How to use the FILTERXML function
42 How to use the ROUND function
43 How to use the RANDARRAY function
44 How to use the SEQUENCE function
45 How to use the SORTBY function
46 How to use the SORT function
47 How to use the FILTER function
48 How to use the UNIQUE function
49 How to solve simultaneous linear equations in Excel
50 How to use the XNPV function
51 How to use the RRI function
52 How to do tiered calculations in one formula
53 How to use the ROUNDDOWN function
54 How to use the ROUNDUP function
55 Excel charts tips and tricks
56 How to use the VDB function
57 How to use the YIELD function
58 How to use the SYD function
59 How to use the TBILLEQ function
60 How to use the TBILLPRICE function
61 How to use the TBILLYIELD function
62 How to use the UNICODE function
63 How to use the UNICHAR function
64 How to use the PERCENTRANK.EXC function
65 How to use the PERCENTRANK.INC function
66 How to use the QUARTILE.EXC function
67 How to use the LOGNORM.DIST function
68 Conditional Formatting Basics
69 How to use the LOG10 function
70 How to use the WEEKNUM function
71 How to use the LOGEST function
72 How to use the LINEST function
73 How to use the GAMMA.DIST function
74 How to add chart elements
75 How to use the F.TEST function
76 Excel VBA functions
77 How to use the NETWORKDAYS.INTL function
78 How to use the INTERCEPT function
79 How to use the F.DIST.RT function
80 How to use the F.DIST function
81 How to use the BINOM.INV function
82 How to use the CHISQ.TEST function
83 How to use the COVARIANCE.S function
84 How to use the COVARIANCE.P function
85 How to use the XOR function
86 How to use the CHISQ.INV.RT function
87 How to use the CHISQ.INV function
88 How to use the CHISQ.DIST.RT function
89 How to use the CHISQ.DIST function
90 How to use the BINOM.DIST function
91 How to use the BETA.INV function
92 How to use the BETA.DIST function
93 How to use the RANK.EQ function
94 How to use the CONFIDENCE.T function
95 How to use the CONFIDENCE.NORM function
96 How to use the MODE.SNGL function
97 How to use the FLOOR.PRECISE function
98 How to use the CSC function
99 How to use the GROWTH function
100 How to use the ERROR.TYPE function
101 How to use the GCD function
102 How to use the GEOMEAN function
103 How to use the WORKDAY function
104 How to use the YEARFRAC function
105 How to use the SLOPE function
106 How to use the SKEW function
107 How to use the PROB function
108 How to use the PHI function
109 How to use the CONCATENATE function
110 Get date ranges from a schedule
111 Copy data from workbooks in folder and subfolders
112 How to copy non contiguous cell ranges
113 Search for a file in folder and subfolders – UDF
114 How to use the MUNIT function
115 How to use the RAND function
116 How to use the MULTINOMIAL function
117 How to use the MINIFS function
118 How to use the MINA function
119 How to use the MINVERSE function
120 How to use the NORM.INV function
121 Advanced Excel Chart Techniques
122 How to use the NORM.DIST function
123 How to use the WEBSERVICE function
124 How to create charts in Excel
125 How to use the VAR.S function
126 How to use the VAR.P function
127 How to use the DVARP function
128 How to use the DSTDEVP function
129 How to use the DSTDEV function
130 How to use the DPRODUCT function
131 How to use the DMIN function
132 How to use the DMAX function
133 How to use the DGET function
134 How to use the DCOUNTA function
135 How to use the DCOUNT function
136 How to use the DAVERAGE function
137 How to use the FORECAST.LINEAR function
138 How to use the BITXOR function
139 How to use the BITRSHIFT function
140 How to use the BITOR function
141 How to use the BITLSHIFT function
142 How to use the BITAND function
143 How to use the BIN2OCT function
144 How to use the BIN2HEX function
145 How to use the BIN2DEC function
146 How to use the BASE function
147 How to use the AVEDEV function
148 How to use the ATAN2 function
149 How to use the ATAN function
150 How to use the ASIN function
151 How to use the ACOT function
152 How to use the ACOS function
153 How to use the NA function
154 How to use the TYPE function
155 How to use the TRUNC function
156 How to use the TRIMMEAN function
157 How to use the TREND function
158 How to use the COT function
159 How to use the SUMXMY2 function
160 How to use the SUMX2MY2 function
161 How to use the SUMSQ function
162 How to use the STDEVPA function
163 How to use the STANDARDIZE function
164 How to use the STDEV.S function
165 How to use the STDEV.P function
166 How to use the SEC function
167 How to use the RANK.AVG function
168 How to use the QUARTILE.INC function
169 How to use the FLOOR.MATH function
170 How to use the FIXED function
171 How to use the EXPON.DIST function
172 How to use the EOMONTH function
173 How to use the ENCODEURL function
174 How to use the EDATE function
175 How to use the DEC2OCT function
176 How to use the DEC2BIN function
177 How to use the DECIMAL function
178 How to use the DAYS function
179 How to use the CONVERT function
180 How to use the CORREL function
181 How to use the CONCAT function
182 How to use the CEILING function
183 How to use the AVERAGEA function
184 How to use the AREAS function
185 How to use the LCM function
186 How to use the NOW function
187 How to use the TIMEVALUE function
188 How to use the SWITCH function
189 How to use the STDEVA function
190 How to use the SHEETS function
191 How to use the SHEET function
192 How to use the MROUND function
193 How to use the NOT function
194 How to use the SQRT function
195 How to use the SIGN function
196 How to use the T function
197 How to use the N function
198 How to use the MODE.MULT function
199 How to use the MEDIAN function
200 How to use the LOG function
201 How to use the LN function
202 How to use the INFO function
203 How to use the PERMUTATIONA function
204 How to use the COMBINA function
205 How to use the PRODUCT function
206 How to use the DEGREES function
207 How to use the RADIANS function
208 How to use the PI function
209 How to use the FORMULATEXT function
210 How to use the ISFORMULA function
211 How to use the ISODD function
212 How to use the ISERR function
213 How to use the FIND function
214 How to use the ISNA function
215 How to use the ISREF function
216 How to use the ISNONTEXT function
217 How to use the ISLOGICAL function
218 How to use the ISTEXT function
219 How to use the ISERROR function
220 How to use the ISBLANK function
221 How to use the POWER function
222 How to extract numbers from a cell value
223 How to use the VALUE function
224 How to use the TODAY function
225 How to use the DATEVALUE function
226 How to use the DATEDIF function
227 How to use the TAN function
228 How to use the COS function
229 How to use the SIN function
230 How to use the EVEN function
231 How to use the MINUTE function
232 How to use the EXP function
233 How to use the RANDBETWEEN function
234 How to use the SECOND function
235 How to use the HOUR function
236 How to use the FACT function
237 How to use the IFNA function
238 How to use the IFS function
239 How to use the INT function
240 How to use the CLEAN function
241 How to use the COMBIN function
242 How to use the PERMUT function
243 How to use the LEN function
244 How to use the COUNTBLANK function
245 How to use the COUNTA function
246 How to use the COLUMNS function
247 How to use the ROWS function
248 How to use the MAX function
249 How to use the MAXIFS function
250 How to use the LARGE function
251 How to use the CELL function
252 How to use the COUNT function
253 How to use the CHAR function
254 How to use the CODE function
255 How to use the COLUMN function
256 How to use the AVERAGEIFS function
257 How to use the AVERAGEIF function
258 How to use the AGGREGATE function
259 How to use the NETWORKDAYS function
260 How to use the ADDRESS function
261 How to use the TIME function
262 How to use the ISNUMBER function
263 How to use the WEEKDAY function
264 How to use the DAY function
265 How to use the MONTH function
266 How to use the LOWER function
267 How to use the REPT function
268 How to use the SUBSTITUTE function
269 How to use the UPPER function
270 How to use the EXACT function
271 How to use the TRIM function
272 How to use the ABS function
273 Extract specific word based on position in cell value
274 How to use the RIGHT function
275 How to use the LEFT function
276 How to use the MID function
277 How to use the MIN function
278 How to use the SUMIFS function
279 How to use the CHOOSE function
280 Count cells containing text from list
281 How to use the AVERAGE function
282 Excel formula not working
283 INDEX MATCH – multiple results
284 How to use the SUBTOTAL function
285 If cell contains text from list
286 How to use the OR function
287 How to use the AND function
288 How to use the YEAR function
289 How to use the HYPERLINK function
290 How to use the DATE function
291 How to use the TEXT function
292 How to use the SUMIF function
293 Rearrange values using formulas
294 User opens or closes a workbook creates an event
295 Filter duplicate values based on criteria
296 How to use the SUM function
297 How to use the HLOOKUP function
298 How to use the VLOOKUP function
299 Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses
300 How to use Excel Tables
301 Rotating unique groups with no repeat
302 Time sheet for work
303 How to use the LIKE OPERATOR
304 How to generate a round-robin tournament
305 How to use DIALOG BOXES
306 How to use Pivot Tables – Excel’s most powerful feature and also least known
307 How to use the TEXTJOIN function
308 Working with ARRAY VARIABLES (VBA)
309 Compare two columns in different worksheets
310 Follow stock market trends – Moving Average
311 Find and return the highest number and corresponding date based on a condition
312 How to add horizontal line to chart
313 A beginners guide to Excel array formulas
314 How to improve your Excel Chart
315 How to use the TRANSPOSE function
316 Dynamic scoreboard
317 Working with overlapping date ranges
318 Working with LIST BOXES (Form Controls)
319 Split expenses calculator
320 List all hyperlinks in worksheet programmatically
321 How to use the QUOTIENT function
322 Find numbers closest to sum
323 How to save specific multiple worksheets to a pdf file programmatically
324 How to use the LOOKUP function
325 How to use the INDIRECT function
326 Search for a sequence of values
327 Working with comments – VBA
328 Working with Excel tables programmatically
329 How to use the MOD function
330 Finding the shortest path – A * pathfinding
331 Working with classic ciphers in Excel
332 How to use the Subtotal tool
333 Highlight unique values in a filtered Excel table
334 Build a maze programmatically in Excel
335 Merge tables based on a condition
336 How to animate an Excel chart
337 Search all workbooks in a folder
338 Customize the ribbon and how to add your macros
339 Identify rows of overlapping records
340 Compare two columns and extract differences
341 Working with TEXT BOXES [Form Controls]
342 Show / hide a picture using a button
343 Wildcard lookups and include or exclude criteria
344 Lookup with any number of criteria
345 How to use the Scroll Bar
346 Count cells based on color
347 Prevent duplicate records in a worksheet
348 How to use the IFERROR function
349 Find all sequences of consecutive dates
350 How to use the FREQUENCY function
351 How to use the SUMPRODUCT function
352 How to use the SEARCH function
353 Yet another Excel Calendar
354 How to use the MMULT function
355 How to use the SMALL function
356 Working with FILES
357 How to use the ROW function
358 How to use the COUNTIFS function
359 How to use the IF function
360 How to use the COUNTIF function
361 How to use the MATCH function
362 How to use the INDEX function
363 How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
364 Highlight a data series in a chart
365 Repeat values across cells
366 Run a Macro from a Drop Down list [VBA]
367 Advanced Techniques for Conditional Formatting
368 Working with date ranges
369 Compare the performance of your stock portfolio to S&P 500 using Excel
370 How to use VLOOKUP/XLOOKUP with multiple conditions
371 How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges
372 Working with Relational Tables in Excel
373 Excel calendar
374 Create new worksheets programmatically based on values in a cell range [VBA]
375 How to create an interactive Excel chart
376 Lookup multiple values across columns and return a single value
377 Excel template: Getting Things Done [VBA]
378 Unique distinct records sorted based on count or frequency
379 Partial match and return multiple adjacent values
380 Working with Conditional Formatting formulas
381 Auto resize columns as you type
382 Working with COMBO BOXES [Form Controls]
383 Use a drop down list to search and return multiple values
384 How to create permutations
385 Extract unique distinct values from an Excel Table filtered list
386 Add checkboxes and copy values – VBA
387 Add values to a regular drop-down list programmatically
388 How to compare two data sets
389 VLOOKUP – Return multiple unique distinct values
390 Filter unique distinct records case sensitive
391 Create a dynamic named range
392 Working with running totals
393 How to highlight differences and common values in lists
394 Fuzzy VLOOKUP
395 A Comprehensive Guide to Splitting Text in Excel
396 Monthly calendar template
397 Count unique distinct records
398 Compare tables: Filter records occurring only in one table
399 Lookup and return multiple values concatenated into one cell
400 Create a Print button – macro
401 Save invoice data – VBA
402 Team Generator
403 Create dependent drop down lists containing unique distinct values
404 Extract dates from overlapping date ranges
405 Plot date ranges in a calendar
406 Automate net asset value (NAV) calculation on your stock portfolio
407 Split data across multiple sheets – VBA
408 Match two criteria and return multiple records
409 Create number series
410 How to return a value if lookup value is in a range
411 Excel solver examples
412 Identify numbers in sum using Excel solver
413 Formula for matching a date within a date range
414 Find the most recent date that meets a particular condition
415 5 easy ways to VLOOKUP and return multiple values
416 Extract all rows from a range that meet criteria in one column
417 How to list unique distinct values sorted by frequency
418 Extract duplicates from a multi-column cell range
419 Search for a text string in a data set and return multiple records
420 Merge cell ranges into one list
421 How to perform a two-dimensional lookup
422 Extract a list of duplicates from a column
423 Extract a unique distinct list from multiple non adjacent cell ranges
424 How to create date ranges in Excel
425 Find missing numbers
426 Count unique distinct values
427 Populate drop down list with unique distinct values sorted from A to Z
428 How to highlight duplicate values
429 Advanced Date Highlighting Techniques in Excel
430 Partial match for multiple strings – AND logic
431 Extract a unique distinct list sorted from A to Z
432 Working with unique values
433 5 easy ways to extract Unique Distinct Values
434 Sort a column alphabetically
435 Extract unique distinct values from a multi-column cell range
436 Calculate machine utilization
437 Extract records between two dates
438 Filter unique distinct records
439 How to use the OFFSET function
440 Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
441 Excel chart components