Posts

Analyzing Date and Time Related Data in Excel

Create Excel Dashboard using OFFSET, SUM and MATCH functions

ADD ERROR TRAP: Wrap your Formulas with IFERROR or ISERROR

How to Prevent Blank Cells from plotting in Excel Charts?

How to send Lotus Notes e-mail using Excel VBA ?

How to use OFFSET Function? (with Examples)

Using Custom Format for Numbers, Dates and Text

17 ways to Optimize VBA Code for FASTER Macros

Excel 2003 Style Menu in Excel 2007/2010

Show Grid on Colored Range (Apply Border)

Replace Characters in the Filenames of a Directory

Square Cells or Create Graph Cells with VBA

3 Things to remember before you go for Excel VBA Job Interview

JOBS for Analysts (INDIA) - Excel, Access, VBA, SQL MIS JOBS

50 Excel VBA Oral Interview Questions

Nth VLookup and HLookup Formulas (User Defined Function)

SHRINK REDUCE EXCEL FILE SIZE

Notifying with Flash Window or Message Beep

Speed up Excel Start up (FASTER EXCEL)

Schedule a VBA Macro (ALARM Setting)