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