- Array Formulas in Excel – 3D Arrays
- Extract text from right of string in Excel
- Converting Monthly to Weekly Data
- Round “time” in Excel
- Excel Short-cuts – A Quickie…
- Removing Duplicates in Excel 2003 or earlier
Working with Graphs
“Back to the Basics” section
“Did you Know” series
A lot of the time, there are things that totally baffle you when you least expected them – limitations, extensions, workarounds, unavailability etc. And that’s exactly what I’d like to uncover in my ‘Did you know’ series!
- File Access from Excel VBA
- ‘Preserve’ing an Array in Excel VBA
- Removing Line Returns in Excel
- Array Formulas in Excel – Using VBA
- Excel doesn’t calculate?!
- Getting filenames of all files in a DIRectory ~
- VBA Error – “code execution has been interrupted”
- Error 1004: Select method of Class Failed
- WAIT for Excel?
- Using the RefEdit Control in Excel
- Event Handling in Excel
- MS Query in Excel
- Static & Public Declaration – Scope of variables in VBA
Excel vs Other Data Softwares
- Where Excel fails?!
- Excel 2007: Specifications and Limits
- Excel Security?!
- Excel as a tool for Analytics