Articles with this tag assume no knowledge prior to reading them.
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.…
Leveraging Excel to deliver analytics. Averages Chart – Bar Chart Chi-Squared: Validate Results Combine Worksheets Convert Column Headers to Rows Cumulative Frequency Database Reporting Designing Data Tables Images-Batch-Rename Merging Worksheet Data Optimization Power Query Introduction Power Query Transformations Power Query Transformations (Advanced) Print Headers with Page Numbers and Last Edited Dates Repeat Headers when Printing…
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…
Ensuring Tables Intuitively Communicate Data During most data analysis, team members must review many small to large data sets. Often, these data sets resides within poorly designed tables, wasting much time when they should have first re-designed those tables to make the data more intuitive and easier to discern patterns. In this article, I will…
