Word Lesson 3: Page Layout — Margins, Orientation, Breaks and Sections
Control how pages look: margins and paper size, page breaks instead of repeated Enter, section breaks for a landscape page in a portrait document,…
Read article →Atul Vij
Word Lesson 2: Headings, Navigation Pane and Table of Contents
Word Lesson 2: Headings, Navigation Pane and Table of Contents
Use heading levels to structure a document, jump and reorganise sections with the Navigation Pane, insert an automatic table of contents, update it, and…
Read article →Word Lesson 1: Styles — The One Word Skill That Saves Hours
Word Lesson 1: Styles — The One Word Skill That Saves Hours
Stop formatting text by hand. Use Word styles for headings and body text, modify a style once to change the whole document, clear manual…
Read article →CEILING Function in Excel: Round Up to a Multiple (Classic)
CEILING Function in Excel: Round Up to a Multiple (Classic)
CEILING rounds up to the nearest multiple — prices ending in 5 or 9, pack sizes. CEILING.MATH is the newer version that handles negatives…
Read article →MINUTE Function in Excel: Minute From a Time
MINUTE Function in Excel: Minute From a Time
DateLevel: BeginnerAvailable in: Excel 2007+MINUTE returns 0–59 from a time.Syntax=MINUTE(serial_number)ArgumentWhat it.
Read article →Linear Regression From Scratch in Python: How a Model Actually Learns
Linear Regression From Scratch in Python: How a Model Actually Learns
Code linear regression with gradient descent in plain NumPy, watch the model learn slope and intercept, then check it against NumPy and scikit-learn. The…
Read article →A Neural Network From Scratch in 30 Lines of NumPy
A Neural Network From Scratch in 30 Lines of NumPy
Build and train a two-layer neural network in plain NumPy to solve XOR — forward pass, backpropagation and gradient descent explained line by line.
Read article →SQL Lesson 12: Project — A Sales Report in SQL
SQL Lesson 12: Project — A Sales Report in SQL
Put the course together: build a half-year sales report from shop.db with total sales, GST, top customer, best month, cancellation rate and a region…
Read article →SQL Lesson 11: Views
SQL Lesson 11: Views
Save a query as a view: build an order_lines view joining orders, customers and products, query it like a table, use views for reports…
Read article →SQL Lesson 10: INSERT, UPDATE and DELETE Safely
SQL Lesson 10: INSERT, UPDATE and DELETE Safely
Change data without disasters: INSERT rows, UPDATE with a WHERE you have tested, DELETE carefully, transactions with BEGIN/ROLLBACK/COMMIT, and habits that prevent “I updated…
Read article →SQL Lesson 9: Working With Dates
SQL Lesson 9: Working With Dates
Filter and group by dates in SQL: ISO date format, month and year ranges, strftime/date functions in SQLite (and SQL Server/PostgreSQL equivalents), adding days,…
Read article →SQL Lesson 8: CASE — If-Then in SQL
SQL Lesson 8: CASE — If-Then in SQL
Use CASE to label rows (price bands, order sizes), count conditions side by side with SUM(CASE…), handle NULLs with readable labels, and build pivot-style…
Read article →