JMC Excel – Join, Merge, Combine multiple Excel sheets or Excel workbooks

Excel Useful — 03:39:00

Still bothered by the cumbersome job of merging multi-worksheet excel files into one worksheet? You may have to merge excel files into one new sheet or merge multiple excel workbooks into one new... More

How to enable macro in Excel 2003

Excel Useful — 03:36:00

Microsoft allows embedded macro (one type of script that is written by programmer) to run on it’s Office suite. To enable it in Excel 2003, you will need to: 1. Fired up Excel. Go to Tools > Options. 2.... More

Excel Split – Split excel worksheets into separate workbooks

Excel Useful — 03:34:00

This tool helps splitting multiple excel sheets and save each of them as an independent file. It was created following a feature request in another tool that I created - Alpesh If you have many excel... More

Excel Run-time error 438: JMC Excel Error Fix

Excel Useful — 03:27:00

If you run into Error 438 recently with JMC Excel please use this fix below found by one of Excel user (Alpesh patel). Thanks to Alpesh for being kind enough to find the solution himself and send me... More

Microsoft Build PowerPoint Themes from 2011 to 2015

Excel Useful — 03:25:00

I’m always impressed by the theme Microsoft used on the Build. Here’s my compilation of their PowerPoint themes from 2011 to 2015. ... More

Count & Sum function

Excel Useful — 04:05:00

Count and Sum Functions   Count | Countif | Countifs | Sum | Sumif | Sumifs The most used functions in Excel are the functions... More