Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
What Oracle Essbase is, how cubes, dimensions and members work, the difference between BSO and ASO, and a first look at calc scripts —…
Read article →Practical tutorials since 2016, by Atul Vij
Learn Excel, automation & code — the practical way
Step-by-step tutorials with downloadable practice files, free browser tools and a daily dose of wacky facts.
0articles
0practice files
0free tools
0wacky facts
Free course
Excel VBA in 15 lessons
From your first variable to UserForms, with a practice workbook that has every macro on a button.
8 of 15 lessons published
Start lesson 1 →Latest articles
5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
Five ways to find the last used row in Excel VBA — End(xlUp), UsedRange, Find, CurrentRegion and ListObject — with the traps each one…
Read article →SAP SE16N and SQVI: Pull Table Data Without ABAP
SAP SE16N and SQVI: Pull Table Data Without ABAP
Use SE16N to browse SAP tables and SQVI QuickViews to join them into your own reports — with the most useful table names for…
Read article →Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
Step-by-step: enable SAP GUI Scripting, record a transaction, and run it from Excel VBA to export a report automatically.
Read article →LET and LAMBDA: Write Your Own Excel Functions (No VBA)
LET and LAMBDA: Write Your Own Excel Functions (No VBA)
Use LET to name parts of long formulas and LAMBDA to create reusable custom functions like CLEANTEXT or FYEAR — saved in Name Manager,…
Read article →Why Do We Have Leap Years? (And Why 1900 Was Not One)
Why Do We Have Leap Years? (And Why 1900 Was Not One)
A year is about 365.2422 days, not 365. How leap years fix the drift, why century years are usually skipped, and how this affects…
Read article →SAP Transaction Codes Every Business User Should Know
SAP Transaction Codes Every Business User Should Know
A practical cheat sheet of SAP transaction codes for finance, purchasing, sales and reporting users — plus the navigation tricks that save time every…
Read article →Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Learn Oracle Smart View ad hoc analysis step by step — connect, zoom, pivot, keep only, POV and suppression options — explained for Excel…
Read article →The Complete Guide to Excel Lookups: VLOOKUP, XLOOKUP, INDEX-MATCH and Beyond
The Complete Guide to Excel Lookups: VLOOKUP, XLOOKUP, INDEX-MATCH and Beyond
Everything about looking up data in Excel in one place: exact and approximate matches, left lookups, two-way lookups, multiple criteria, last match, returning all…
Read article →Build Your Own LLM, Lesson 5: Self-Attention From Scratch
Build Your Own LLM, Lesson 5: Self-Attention From Scratch
Understand and code the attention mechanism behind transformers: queries, keys, values, the causal mask and softmax — first with NumPy on four tokens, then…
Read article →Build Your Own LLM, Lesson 4: Embeddings and Your First Neural Language Model
Build Your Own LLM, Lesson 4: Embeddings and Your First Neural Language Model
Rebuild the bigram model as a neural network in PyTorch, train it with gradient descent, and add embeddings — the vectors that let language…
Read article →Build Your Own LLM, Lesson 3: A Language Model Made of Counting
Build Your Own LLM, Lesson 3: A Language Model Made of Counting
Build a bigram language model with plain Python dictionaries, generate text from it, and measure it with loss — the same number every LLM…
Read article →