Newest Features in Excel
- The advent of “Relational DB” in Excel – PowerPivot!
- 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
- Coloring the scatter plot by groups in Excel
- Box Plot in Excel
- Waterfall Chart in Excel
- The all new Histogram Plot in Excel!
“Back to the Basics” section
- ARRAY FORMULAE
“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 Worksheet Pasword Breaker – 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
Integration with other softwares
- Dynamic Dashboard with MS Access
- Automating MS Powerpoint slides from Excel
- Automating Adobe PDF reports from Excel
- Running SAS prompts from Excel
- Executing R commands and output in Excel
Excel vs Other Data Softwares
- Where Excel fails?!
- Excel 2007: Specifications and Limits