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 βExcel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards β from basics to clever tricks.
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 βExcel Lesson 5: SUM, AVERAGE, COUNT, MIN and MAX
Excel Lesson 5: SUM, AVERAGE, COUNT, MIN and MAX
The five functions you will use every day: SUM, AVERAGE, COUNT/COUNTA/COUNTBLANK, MIN and MAX, plus AutoSum, LARGE/SMALL, how blanks and text are treated, andβ¦
Read article βExcel Lesson 4: Your First Formulas and Cell References
Excel Lesson 4: Your First Formulas and Cell References
Write formulas that start with =, use + - * / and ^, follow the order of operations, refer to cells instead of typingβ¦
Read article βExcel Lesson 2: Entering Data, AutoFill and Flash Fill
Excel Lesson 2: Entering Data, AutoFill and Flash Fill
Enter numbers, text and dates correctly, fill series with the fill handle, use Ctrl+Enter and Ctrl+D, and let Flash Fill split and join namesβ¦
Read article βExcel Lesson 1: The Excel Screen and Moving Around Fast
Excel Lesson 1: The Excel Screen and Moving Around Fast
Your first Excel lesson: workbooks, sheets, rows, columns and cells, the ribbon, Name Box and formula bar, and the keyboard shortcuts that make youβ¦
Read article βSUMX2PY2 Function in Excel: Sum of Sums of Squares
SUMX2PY2 Function in Excel: Sum of Sums of Squares
Maths & trigLevel: ExpertAvailable in: Excel 2007+SUMX2PY2 returns Ξ£(xΒ² + yΒ²).Syntax=SUMX2PY2(array_x, array_y)ArgumentWhat it meansarray_x.
Read article βExcel for Finance Lesson 3: Receivables Ageing and Collections
Excel for Finance Lesson 3: Receivables Ageing and Collections
Track receivables in Excel: outstanding per invoice, days past due from the due date, ageing buckets, customer-wise outstanding, collection efficiency and a DSO estimate,β¦
Read article βDebtors Ageing Report in Excel: 0β30, 31β60, 61β90 and 90+ Days
Debtors Ageing Report in Excel: 0β30, 31β60, 61β90 and 90+ Days
Build a receivables ageing report in Excel: days overdue from the due date, bucket labels, SUMIFS totals by bucket and customer, a pivot version,β¦
Read article β