How To: Merge Multiple Workbooks or Sheets in to one

Productivity Tools

Have you ever encountered a file with table split into multiple tabs/sheets? Or, have you ever been in a situation, wherein, you need to merge same table from multiple Workbooks into a single file?

So, how do you merge those multiple sheets? Below are the 3 methods:

• Copy and paste all and append them into a single tab/sheet. That's is manual method. Just don't miss out to select a column or Columns. Or, miss a row or even Rows. This the same approach if you need to merge same tables from multiple workbooks. Tedious, but, what could you have done better.
• Power Query this an advance MS Excel feature made easy with a click of a button. It comes as an AddIn you can install on your spreadsheet. Click LINK to download the app from Microsoft. A complete GUIDE will introduce you Power Query and will post an article about merging spreadsheets with this feature.
• If you are not confident with advance tools and manual, tedious approach. I'm offering a Productivity Tool you can have with your MS Excel spreadsheets. It's a very simple to use and you can have them for only $10. Click Buy Now below to download the app.

After successful download go to LINK for the instructions on how to install this app in your MS Excel. The Feature will be in your Data tab with "Productivity Tools" name. Two features will be available for you to use, Merge Worksheets and Merge Workbooks.

How To: Make a calendar in excel

How to make a calendar in Excel. This could be a weird question for some. But, trust it's still valid. I still hear this question from an average Excel user and been using for years. We are talking of the method wherein we could just lay out full calendar for a month for a year. Or, for a number of years.

So, is there a quick way? The answer is, Yes. There is what you call templates. It's just a two step approach basically:

1. Open MS Excel
2. In here you have two options to get to templates
• When you have just opened Excel fresh, you'll be prompted with the list of the templates. In there, you get to select various templates. Including the Calendar templates
• On a currently opened Excel, go to Files>New then it will bring up you same templates view above

It's that simple! Now, the other question. Does excel have a feature where in, instead of typing a date in a cell. You will select the date from a calendar box? Well, in MS Excel currently distributed. There's none. But, you can download an AddIn for $10. Click below buy button for the AddIn.

After successful download go to LINK for the instructions on how to install on your MS Excel. It the AddIn will be shown in the Insert tab as Date & Time with a calendar icon.

Customized Charts AddIn for MS Excel

Have ever asked yourself, is there an available chart type in MS Excel for Pareto Chart? Are you tired of manually configuring the necessary formula to arrive the corresponding cumulative values and then selecting a chart and changing the the corresponding data series to arrive at the Column and Line chart configuration. What if you have the ability to just select the ranges and click a feature within Excel to create the Pareto chart you've want to generate quickly.

Click buy now button below to download the AddIn. For $10, you will have the ability on your MS Excel Sheets to create quick Pareto chart and a bonus custom chart Box and Whisker and xy Chart. These charts takes multiple steps to create conventionally. So, download now.
After successful download go to LINK for the instructions on how to install on your MS Excel. You will see the new feature on insert tab of your spreadsheet. With labels shown above image.