Excel’s Strangest Behaviours Explained: 15 “Bugs” That Are Actually Features
Why Excel turns 1-2 into a date, drops leading zeros, shows ####, changes long numbers to E+ notation, gives #SPILL!, auto-corrects gene names and…
Read article →Atul Vij
Rust Lesson 6: Project — A CSV Summary Tool
Rust Lesson 6: Project — A CSV Summary Tool
Build a small command-line tool that reads sales.csv, parses rows safely, totals sales by region in a BTreeMap and prints a report, with next…
Read article →Rust Lesson 5: Error Handling With Result
Rust Lesson 5: Error Handling With Result
Handle failures without exceptions: Result and Option, the ? operator, map_err, expect vs unwrap, and returning clear errors.
Read article →Rust Lesson 4: Structs and Enums
Rust Lesson 4: Structs and Enums
Model data with structs and impl blocks, enums with data, and match to handle every case — the patterns behind most Rust programs.
Read article →Rust Lesson 3: Ownership and Borrowing
Rust Lesson 3: Ownership and Borrowing
Rust’s core idea explained simply: each value has one owner, moves, borrowing with & and &mut, and why this removes whole classes of bugs.
Read article →TRUE Function in Excel: The Logical Value TRUE
TRUE Function in Excel: The Logical Value TRUE
TRUE() returns the logical value TRUE. You can also just type TRUE; the function form exists for compatibility.
Read article →Rust Lesson 2: Variables, Mutability and Types
Rust Lesson 2: Variables, Mutability and Types
Rust variables are immutable by default: let and let mut, integer and float types, casting with as, string slices vs String, and formatted printing.
Read article →Rust Lesson 1: Install Rust and Cargo
Rust Lesson 1: Install Rust and Cargo
Install Rust with rustup, create a project with cargo new, build and run with cargo run, and understand Cargo.toml and src/main.rs.
Read article →ISLOGICAL Function in Excel: Is It TRUE or FALSE?
ISLOGICAL Function in Excel: Is It TRUE or FALSE?
ISLOGICAL checks whether a value is a real TRUE/FALSE. Imports often bring the text "TRUE", which looks identical but is not.
Read article →FALSE Function in Excel: The Logical Value FALSE
FALSE Function in Excel: The Logical Value FALSE
FALSE() returns the logical value FALSE, most often seen as the exact-match argument in VLOOKUP.
Read article →PY Function in Excel: Run Python Inside Excel
PY Function in Excel: Run Python Inside Excel
PY (Python in Excel, 2023) runs Python code (pandas, matplotlib and more) in Microsoft's cloud and returns the result to a cell. You don't…
Read article →CUBESETCOUNT Function in Excel: Number of Items in a Set
CUBESETCOUNT Function in Excel: Number of Items in a Set
CUBESETCOUNT counts the items in a set made with CUBESET. Cube functions read from a Power Pivot Data Model (connection "ThisWorkbookDataModel") or an Analysis…
Read article →