How to Combine Data from Multiple Worksheets into One Master Worksheet

  • combine Multiple Worksheets Using Excel Macros

One of the common headaches I have come across in the course of my career as a Trainer in Excel Dashboards is the question of how to combine data from multiple worksheets into one master worksheet, so that you can analyze smartly.

Many general users of Excel retire to the time consuming method of copy and pasting, which works, if you have few worksheets. It doesn’t have to be that way! Learn at least 3 ways at your disposal to combine multiple worksheets into a consolidated position. Continue reading “How to Combine Data from Multiple Worksheets into One Master Worksheet”

Using Shapes for Stylish Excel Dashboards

Creating an Excel Dashboard for data visualization is one of the key skills analysts in vast majority of organizations require. The good news is that Microsoft Excel has continued to make improvements that allow the process and available visualizations (charts) easy to generate. For instance, with Excel 2016, you have a Waterfall chart as a standard chart. With Excel 2013 and prior versions, creating a waterfall chart would require some tweaking, but yes, it is achievable (follow the link to learn the 4 steps). I will discuss some key concepts among the undermentioned. You can download a copy of the file used in this example at the bottom of this article.

  1. Custom calculations in Pivot Tables
  2. Adding interaction to dashboards with slicers
  3. Custom number formats and conditional formatting
  4. Using shapes for a prettier excel dashboard
  5. Applications of VLOOKUP + MATCH and named ranges

Continue reading “Using Shapes for Stylish Excel Dashboards”

Top Managers Love for Beautiful Things “Dashboards”

If you are involved in management reporting, the statement above resonates with you. You need an appealing, interactive dashboard that articulately gives you the insights you need to make a decision.

Continue reading “Top Managers Love for Beautiful Things “Dashboards””