13-April-2021 Tuesday
RMB and Drag & Drop in Excel
10-April-2021 Saturday
Summarizing by color in Excel
27-March-2021 Saturday
VLOOKUP and TRUE: Calculate grades, commissions, etc. in Excel
20-March-2021 Saturday
Protect sheet vs. Protected cell in Excel – Protect by cell color!
13-March-2021 Saturday
Intersection operator in Excel
10-March-2021 Wednesday
When I got my diploma so I could copy and paste in Excel all day
07-March-2021 Sunday
Register -> Register -> REGISTER: Simple, fast and convenient!
06-March-2021 Saturday
Excel: How to change negative numbers to positive and vice versa (negative to positive values)
27-February-2021 Saturday
Excel: How to fill empty cells below with values
20-February-2021 Saturday
Excel: Diagonal cell split (two headers in one cell)
06-February-2021 Saturday
Multi-level sorting of arrays in VBA: example analysis
30-January-2021 Saturday
Finding Incorrect Records – Excel Task
25-January-2021 Monday
Visualization of how cells work in Excel
16-January-2021 Saturday
Why does time go faster with age?
09-January-2021 Saturday
Split function in VBA
26-December-2020 Saturday
VBA: Listing unique values ??using collections
20-December-2020 Sunday
On Error in VBA
12-December-2020 Saturday
Excel: How to create a set of random unique numbers
05-December-2020 Saturday
Editable and more Excel tables in Word
28-November-2020 Saturday
VPR vs. INDEX & MATCH
21-November-2020 Saturday
Dynamic Excel Dropdown Lists
19-November-2020 Thursday
January, February, Marar, April... Excel?!
16-November-2020 Monday
Dynamic graph with map - works with any version of Excel!
14-November-2020 Saturday
Extract numbers from text in Excel
07-November-2020 Saturday
VPR and Coffee (?!)
v20240901
