Free tutorials, tested files and tools that run in your browser.
🤯 Wacky fact
Tiny marine plants called phytoplankton carry out a large share of Earth’s photosynthesis.
Free course
From your first variable to UserForms, with a practice workbook that has every macro on a button.
15 of 15 lessons published
Start lesson 1 →India has the second-lowest sleep quality in the world. This evidence-based guide explains the biology of sleep, the specific disruptors affecting Indians (late dinners,…
Read article →A complete guide for Excel VBA users learning Python. Every concept mapped to its Excel equivalent — VLOOKUP becomes merge(), SUMIF becomes groupby(), Pivot…
Read article →10 practical Power Automate workflows you can build today — from saving email attachments to SharePoint, to automated approval workflows, Teams notifications, and scheduled…
Read article →Loop Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells…
Read article →Areas Collection This example illustrates the Areas collection in Excel VBA. Below we have bordered Range("B2:C3,C5:E5"). This range has two areas. The comma separates…
Read article →Union and Intersect The Union method in Excel VBA returns a Range object that represents the union of two or more ranges (borders below…
Read article →Show how you got from last year's profit to this year's with an Excel waterfall chart: data layout, setting totals, colours for increases and…
Read article →Most pencils in America and many elsewhere are painted yellow. The popular story involves Chinese graphite, royalty and a famous Austrian pencil from 1890.…
Read article →Built-in ways to translate a whole web page in Chrome and Edge, a PDF or Word document with Google Translate, and text in a…
Read article →Offset The Offset property in VBA takes the range which is a particular number of rows and columns away from a certain range (border…
Read article →Resize The Resize property in Excel VBA makes a range (border below for illustration only) a specific number of rows and columns larger or…
Read article →CurrentRegion This example illustrates the CurrentRegion property in Excel VBA. The current region is a range bounded by any combination of blank rows and…
Read article →