GAMMA Function in Excel: The Gamma Function
StatisticsLevel: ExpertAvailable in: Excel 2013+GAMMA extends factorials to non-whole numbers: GAMMA(n) = (n-1)! for whole.
Read article →Atul Vij
Excel Lesson 14: Lookups — VLOOKUP and XLOOKUP
Excel Lesson 14: Lookups — VLOOKUP and XLOOKUP
Fetch a price, name or rate from another table: VLOOKUP exact match step by step, XLOOKUP (easier and more flexible), handling codes that aren’t…
Read article →Google Search Operators Cheat Sheet: Find Anything Faster
Google Search Operators Cheat Sheet: Find Anything Faster
Search operators that make Google far more precise: exact phrases, site search, excluding words, file types, OR, number ranges and more — with practical…
Read article →Excel Lesson 13: Dates — TODAY, EOMONTH, DATEDIF and Date Maths
Excel Lesson 13: Dates — TODAY, EOMONTH, DATEDIF and Date Maths
How Excel stores dates, adding days and months, due dates, month-end with EOMONTH, age and service with DATEDIF, working days with NETWORKDAYS, YEAR/MONTH/WEEKDAY, and…
Read article →Excel Lesson 12: Text Functions — LEFT, RIGHT, MID, TRIM, PROPER and More
Excel Lesson 12: Text Functions — LEFT, RIGHT, MID, TRIM, PROPER and More
Clean and split messy text: TRIM extra spaces, fix case with PROPER/UPPER/LOWER, cut pieces with LEFT, RIGHT and MID, find positions with FIND, replace…
Read article →Excel Lesson 11: Absolute vs Relative References ($)
Excel Lesson 11: Absolute vs Relative References ($)
Why formulas break when copied, and how the $ sign fixes it: relative, absolute ($B$8) and mixed ($A2, B$1) references, the F4 shortcut, named…
Read article →Excel Lesson 10: Printing and Page Setup
Excel Lesson 10: Printing and Page Setup
Print Excel sheets that fit: Print Preview, orientation, Fit to page width, print area, repeating header rows, headers and footers with page numbers, page…
Read article →MINA Function in Excel: Minimum Counting Text and TRUE/FALSE
MINA Function in Excel: Minimum Counting Text and TRUE/FALSE
StatisticsLevel: IntermediateAvailable in: Excel 2007+MINA is MIN that also counts text as 0 and TRUE as 1, FALSE as 0.Syntax=MINA(value1, [value2].
Read article →CALL Function in Excel: Call a DLL Procedure
CALL Function in Excel: Call a DLL Procedure
CALL calls a procedure in a DLL or code resource. It is an old Excel 4.0 macro-era function, disabled by default for security and…
Read article →Excel Lesson 7: Sorting and Filtering Data
Excel Lesson 7: Sorting and Filtering Data
Sort by one or several columns, sort by date or a custom order, filter by values, numbers, dates, text and colour, read totals of…
Read article →GAMMALN Function in Excel: Natural Log of the Gamma Function
GAMMALN Function in Excel: Natural Log of the Gamma Function
GAMMALN returns ln(GAMMA(x)); useful when GAMMA itself would overflow for large x.
Read article →Excel Lesson 6: IF — Making Decisions in a Cell
Excel Lesson 6: IF — Making Decisions in a Cell
Learn IF step by step: comparison operators, returning text or numbers, AND and OR for combined rules, nested IF for grades and ratings, and…
Read article →