Beautiful Charts in R with ggplot2 (for Excel Users)
Build bar, line and scatter charts in R with ggplot2, and learn the “grammar of graphics” idea that makes every chart the same few…
Read article →Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained
Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained
Get the latest price, last status or most recent date for an item with the famous LOOKUP(2,1/(range=value)) formula — explained step by step, plus…
Read article →12 Browser Tricks That Make You Faster (Chrome, Edge, Firefox)
12 Browser Tricks That Make You Faster (Chrome, Edge, Firefox)
Reopen closed tabs, search specific sites from the address bar, group tabs, read without clutter and more — browser shortcuts that save time every…
Read article →Link Excel Charts to PowerPoint and Refresh Them Automatically
Link Excel Charts to PowerPoint and Refresh Them Automatically
Paste Excel charts into PowerPoint as linked objects so monthly decks update with one click — plus a VBA macro that refreshes every link…
Read article →Smart View Functions: Build Cell-Based Reports with HsGetValue
Smart View Functions: Build Cell-Based Reports with HsGetValue
Use Oracle Smart View functions such as HsGetValue to pull single numbers from Essbase or EPM into any Excel layout — syntax, POV defaults,…
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 →VBA String Functions: Left, Mid, InStr, Replace, Split and More
VBA String Functions: Left, Mid, InStr, Replace, Split and More
Clean and reshape text in Excel VBA with Left, Right, Mid, Len, InStr, Replace, Trim, UCase, Split and Join — with real data-cleaning examples.
Read article →VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
Handle errors in Excel VBA properly with On Error GoTo, find bugs with breakpoints, Watch and the Immediate window, and write comments that help.
Read article →VBA Loops Explained: For, For Each, Do While and Do Until
VBA Loops Explained: For, For Each, Do While and Do Until
Learn every Excel VBA loop — For…Next, For Each, Do While, Do Until — when to use each, how to exit early, and how…
Read article →5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
Five small, useful Excel VBA macros explained: the Mod operator, finding the second highest value, summing by cell colour, deleting blank rows and highlighting…
Read article →Decisions in VBA: If…Then, And/Or and Select Case
Decisions in VBA: If…Then, And/Or and Select Case
Make Excel macros decide: If…Then…ElseIf, logical operators And/Or/Not, and Select Case — with real examples and common mistakes.
Read article →Power Automate: Save Email Attachments to OneDrive Automatically
Power Automate: Save Email Attachments to OneDrive Automatically
Build a Power Automate cloud flow that saves attachments from specific Outlook emails into OneDrive or SharePoint folders — with filters, date folders and…
Read article →