Excel Tips & Tricks

Excel on Steroids Tips and Tricks will help you make the most of the business reporting features in Excel. If you enjoy our tips, consider subscribing.

3 Easy steps to hide zero values in Excel

In order to have neat looking reports in Microsoft® Excel®, you may choose to hide zero values. In this tip, we explain how to hide zero values for selected cells by using the custom number format. The hidden zero values appear in the formula bar when a cell is selected. Values that change to non-zero […] Read more →

Charts are used for displaying data graphically, and they can be enhanced by using a pictograph. Pictographs use any picture you choose to represent as your data series in the charts. Icons can also be used as pictograph to represent data values in order to decrease the size of the graph. You will find the […] Read more →

Easily move a row or column in Excel

When wanting to move a row or column in Excel from one section of a worksheet to another (e.g. from row 13 to row 10), it's normal practice to use the Cut and Insert Cut Cells command. However, an easier and quicker way to do this is the following: Select the values in the row/rows […] Read more →

Charts are used for creating a graphical presentation of the data.  A common practice when creating charts is to create them off of a filtered Pivot Table, usually a Top 5 or a Top 10 Pivot Table.  Slicers can then be added to interactively filter the data in the chart. When filtering data with the […] Read more →

Are you looking for a shortcut to quickly rearrange your worksheets in alphabetical order?  Instead of dragging and manually arranging your worksheets, you can use VB for Microsoft® Excel® to quickly rearrange them into alphabetical order. Excel currently has no built-in function to rearrange your worksheets. Therefore, if you have a workbook with many worksheets, […] Read more →

Dashboards in Microsoft® Excel® are used for visually presenting important business information. Dashboards can display current status of metrics and key performance indicators. In this tip, we look at how to enhance dashboards with a Power View report by analyzing sales data. Power View reports in Microsoft® Excel® pull your data together in tables, matrices, […] Read more →

Let’s say you want to count cells that contain the number of employees in a data range, and would like to ignore any blank cells. The way to go about doing this is to use the COUNTA function. The COUNTA function is a way to count cells containing any type of information, including error values […] Read more →

How to easily double-check your Excel formula

When creating an Excel formula, sometimes the result you get is not quite the one you expected, and if a complex formula is being used, it can be time consuming to find where the error is occurring. If you’re ever writing a long formula and it doesn’t give you the result that you are after, […] Read more →

Selecting data from a drop-down list is a convenient and accurate way of entering data into a range. It helps in ensuring that the correct data is entered quickly in Microsoft® Excel®. However, a slicer provides a quicker, better and easier way of selecting data from a list. In this tip, we explain how to […] Read more →

How to create a Tree Map chart in Excel 2016

The Tree Map chart is a new chart type available in Microsoft® Excel® 2016. It’s used to proportionally display hierarchical levels of data in the form of different sized rectangle blocks. A sales manager can use the Tree Map chart to monitor the performance of the sales consultants. This chart would be best suited to […] Read more →