Python Lesson 5: Loops
Repeat work with for loops over lists, dictionaries and ranges, count and total inside loops, list comprehensions, while loops, and break/continue — the code…
Read article →Atul Vij
Python Lesson 4: Lists and Dictionaries
Python Lesson 4: Lists and Dictionaries
Hold many values with lists (indexing, append, sort, slices) and look things up with dictionaries (keys, get, items) — Python’s versions of a column…
Read article →Python Lesson 3: Decisions With if, elif and else
Python Lesson 3: Decisions With if, elif and else
Make decisions in Python: comparisons, if/elif/else blocks and indentation, and/or/not, one-line conditional expressions, and the IF patterns from Excel translated to Python.
Read article →Python Lesson 2: Variables, Numbers and Text
Python Lesson 2: Variables, Numbers and Text
Store values in variables, use int, float, str and bool, do maths with rounding, format output with f-strings including thousands separators, and convert between…
Read article →Python Lesson 1: Install Python and Run Your First Program
Python Lesson 1: Install Python and Run Your First Program
Install Python on Windows the right way, use VS Code or IDLE, run a script from the terminal, use the interactive prompt, and install…
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 →SUMX2MY2 Function in Excel: Sum of Differences of Squares
SUMX2MY2 Function in Excel: Sum of Differences of Squares
Maths & trigLevel: ExpertAvailable in: Excel 2007+SUMX2MY2 returns Σ(x² - y²) for two matching ranges.Syntax=SUMX2MY2(array_x, array_y)ArgumentWhat it.
Read article →Calculate Age and Tenure in Excel: Years, Months and Days (DATEDIF and YEARFRAC)
Calculate Age and Tenure in Excel: Years, Months and Days (DATEDIF and YEARFRAC)
Exact age or service tenure as "5 years 3 months 12 days", completed years for gratuity, age on a specific date, decimal years with…
Read article →Excel for Finance Lesson 8: Financial Ratios From the P&L and Balance Sheet
Excel for Finance Lesson 8: Financial Ratios From the P&L and Balance Sheet
Calculate and read the key ratios in Excel: gross and net margin, current and quick ratio, debt-equity, interest coverage, debtor and inventory days, ROE…
Read article →Excel for Finance Lesson 7: Fixed Asset Register and Depreciation
Excel for Finance Lesson 7: Fixed Asset Register and Depreciation
Keep a fixed asset register in Excel: SLM depreciation with SLN, WDV at block rates, months of use in the first year, the half-rate…
Read article →