Excel TEXT Function: 20 Format Codes You Will Actually Use
The TEXT function turns numbers and dates into exactly the text you want: dd-mmm-yyyy, day names, leading zeros, lakh/crore commas, percentages and times. 20…
Read article →Excel Formulas
Lookup, text, date and dynamic-array formulas with worked examples.
Excel Date Formulas Cheat Sheet: 25 Formulas You Will Actually Use
Excel Date Formulas Cheat Sheet: 25 Formulas You Will Actually Use
The 25 Excel date formulas used most at work: today and month-end, adding months, age and tenure, working days with holidays, weekday names, week…
Read article →Excel Lesson 18: Final Project — Build a Monthly Sales Report
Excel Lesson 18: Final Project — Build a Monthly Sales Report
Put the whole course together: turn raw orders into a one-page quarterly sales report with KPIs, region vs target with Met/Missed, a monthly chart,…
Read article →Excel Lesson 15: Data Validation and Drop-Down Lists
Excel Lesson 15: Data Validation and Drop-Down Lists
Stop typing mistakes before they happen: drop-down lists from a range or Table, whole-number and date limits, custom rules for PAN and mobile numbers,…
Read article →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 →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 →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 →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 →