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 workbook, then JMC Excel software is your right choice in simplifying your tedious merging work. JMC Excel – Join, Merge, Combine excel worksheets.

This software can merge multiple excel sheets into one new excel sheet or merge multiple excel files into one new excel file with multiple worksheets.

Trial Version

Please download Excel (Trial version, Version 2) here (Free). Trial version can merge up to ten files.

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. Go to Security Tab.

3. Click on “Macro Security…”

4. Select “Medium: You can choose…”” and click OK.

5. Close your Excel and re-launch your Excel application.

6. If you did it correctly, you will be prompt to choose whether to enable the macro or not. Click Enable Macros.

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 sheets created in multiple excel files and wanted to save each of them separately as workbook (or independent .xlsx file), JMC Excel Split will come in very handy.

Below is the download link to the trial version (which can split up to 5 files and 5 sheets each).

Excel Split Download Link

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 the detail. Below are the detail of his guide. Thanks again Alpesh for helping.

Hi Alpesh,
I thought I would let you know that I found the answer to Run-time error 438 appearing whenever I try to use JMC.
I discovered this is from an automatic Microsoft update that downloaded in Dec 2014 and affecting JMC as well as active X controls in Excel.
To repair, I simply had to delete all *.exd files:
del %temp%\vbe\*.exd
del %temp%\excel8.0\*.exd
del %appdata%\microsoft\forms\*.exd
del %appdata%\microsoft\local\*.exd
del %appdata%\Roaming\microsoft\forms\*.exd
del %temp%\word8.0\*.exd
del %temp%\PPT11.0\*.exd
Everything works again!  Hope this helps you should you receive any other emails regarding this error.

Kind Regards,
Alpesh

Below are the reference sites Alpesh quoted:
http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled
http://support.microsoft.com/kb/3025036/EN-US

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

Count and Sum Functions

 

Count | Countif | Countifs | Sum | Sumif | Sumifs

The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.

Count

To count the number of cells that contain numbers, use the COUNT function.

Countif

To count cells based on one criteria (for example, higher than 9), use the following COUNTIF function.

Countifs

To count cells based on multiple criteria (for example, green and higher than 9), use the following COUNTIFS function.

Sum

To sum a range of cells, use the SUM function.

Sumif

To sum cells based on one criteria (for example, higher than 9), use the following SUMIF function (two arguments).

To sum cells based on one criteria (for example, green), use the following SUMIF function (three arguments, last argument is the range to sum).

Sumifs

To sum cells based on multiple criteria (for example, blue and green), use the following SUMIFS function (first argument is the range to sum).

General note: in a similar way, you can use the AVERAGEIF and AVERAGEIFS function to average cells based on one or multiple criteria.