Consolidating data into one Excel worksheet. This post describes how to merge data in an Excel workbook containing worksheets with data where each worksheet has differing number of columns and rows. I will use a spreadsheet which contains three tabs/worksheets with the following columns. Sheet1 will be the first source worksheet used to import data.…

Table features: Conditional-Formatting, Filters, and Charts. In this article, I’ll illustrate powerful Excel features provided with tables such as: Conditional-Formatting, Filters, and Charts. First, I’ll begin with a simple data set. You’ll notice some of the values are truncated, so I’ll click the top-left cell to select all cells, then double-click the dividing line between…

Using statistic formulas to deliver key metrics. Beginning with a simple set of test sales data, I employed some simple statistic Excel formulas to display metrics regarding the data. In addition to using Conditional Formatting to show revenue values in both the high (green) and low (red) ranges, I also show for all the values…

Have you printed a worksheet with multiple pages, but wished the header would appear on each page? 1) Click Print Titles. 2) On the Sheet ta, click once in Rows to repeat at top:, then click the far-left of the row to repeat (A1), click OK, the print. Now my header Header 1, Header 2,……

Using Excel to create a script to batch-rename images. First, I’ll begin with a simple set of images I intend to rename. Then, I’ll create a new Excel spreadsheet from which I’ll delete the last two worksheets, leaving only one. In my new spreadsheet, I’ll enter those image names into an Excel spreadsheet (or use…

Presenting column headers as rows. If you have ever worked with a long list of column headers – too long so it displays off the screen to the right, you know how arduous such a list can be to work with – use Transpose. I’ll begin with a list of columns which goes up to…