In our last tip, you were introduced to the new financial ratio reports provided through the Report Utility, which you can use to perform a health check of your business.  If you didn’t catch it, or would like to brush up on it, you can find it here. Although the reports are comprehensive, they don’t […] Read more →

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 →

At Sage Intelligence, we believe in providing you with the right information to help you improve the running of your business, and give you back your time.  One of the ways we do this is through the free Financial Ratio reports that you can access through our Report Utility. Over the past few weeks, we’ve […] Read more →

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 →

In our last tip, you discovered that with an existing report, you’re able to make and save changes to a layout as a result of the Excel template that is associated with it.  This means that any modifications you make persist each time the report is run, with the latest data being populated.  If you’d […] 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 →

Sage Intelligence Reporting allows you to create reports of your own, as well as customize your existing ones, all in the familiar environment of Microsoft® Excel®.  This is based on the Excel template that gets attached to each report.  Once it's linked back, after any changes have been made, the formulas will update seamlessly with […] Read more →