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 →Atul Vij
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 →Python Lesson 12: Project — Automate a Monthly Report
Python Lesson 12: Project — Automate a Monthly Report
Build a real automation: combine every monthly CSV in a folder, clean and summarise with pandas, write a multi-sheet Excel report with KPIs, and…
Read article →Python Lesson 11: Excel Files With openpyxl
Python Lesson 11: Excel Files With openpyxl
Create formatted Excel reports from Python: write DataFrames to sheets, style headers, set number formats and column widths, add formulas and a chart with…
Read article →AI Agents and Tool Calling Explained (With a 20-Line Example)
AI Agents and Tool Calling Explained (With a 20-Line Example)
What people mean by AI agents: a model in a loop that can call tools such as search, a calculator or your database. How…
Read article →Python Lesson 10: pandas — Summaries and Pivot Tables
Python Lesson 10: pandas — Summaries and Pivot Tables
Summarise data with pandas: groupby with sum and count, several aggregations with agg, pivot_table with totals, top-N with nlargest, monthly summaries, and percentage of…
Read article →Python Lesson 9: pandas — Cleaning Messy Data
Python Lesson 9: pandas — Cleaning Messy Data
Clean a real-world messy export with pandas: tidy column names, trim and fix case, turn “Rs 1,23,000” into numbers, parse mixed date formats, remove…
Read article →Python Lesson 8: pandas — Reading and Exploring Data
Python Lesson 8: pandas — Reading and Exploring Data
Start with pandas: read CSV and Excel files into a DataFrame, check shape and data types, view rows, add calculated columns, and filter rows…
Read article →Python Lesson 7: Reading and Writing Files
Python Lesson 7: Reading and Writing Files
Read and write CSV files with Python’s standard library: open with a with-block, csv.DictReader, totals with defaultdict, writing a result file, encodings, and file…
Read article →Python Lesson 6: Functions
Python Lesson 6: Functions
Write your own reusable functions with def: parameters, default values, return, docstrings, and practical examples like GST, financial-year labels and grading — Python’s version…
Read article →