An easy way to generate PivotTables on separate worksheets in Excel

May 5, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks

You have taken time to create a product sales PivotTable and now you would like to analyze the data. You want to analyze the sales per branch by quickly generating PivotTables for each branch to be placed on separate worksheets. In this week’s tip, we take you through a few easy steps as we show you […]

Easily organize data in Excel using multiple data consolidations for PivotTables

Apr 26, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks

The PivotTable is an effective tool for working with large volumes of data, it allows you to summarize, organize and view the same data in many different ways quickly and easily. By using the PivotTable multiple consolidation ranges option you can create a PivotTable that consolidates data from more than one worksheet. This can greatly […]

Get creative in Excel using sparklines to show data trends

Apr 20, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks, Tips & Tricks

New in Microsoft® Excel® 2010, and later versions, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. For more impact, a sparkline […]

An easy way to create a dual chart in Excel, trending with a secondary axis

Apr 13, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks

Charts by default display a primary vertical axis when created. This works if there is only one unit of measure in the data. However, should there be different units of measure in your data, a secondary axis will be required, thus allowing you to create a dual chart in your Microsoft® Excel® workbook. In our […]

Learn how to create a thermometer chart in Excel to show your performance against a set goal

Apr 6, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks, Tips & Tricks

Did you know that you can create a thermometer chart in Microsoft® Excel®? You can use the thermometer chart to compare your performance against a set goal. For example, revenue vs target or budget vs actual, can be plotted using a thermometer chart. The performance value and its corresponding target are stacked on top of […]

How to create an Excel combination chart from scratch

Mar 30, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks

After you have created your Microsoft® Excel® spreadsheet, you can visually represent the worksheet data by creating a chart. Charts often make your data clearer and easier to understand. If you find that the data is not in sequence or in a group of cells, you may need to create your own series, specifying the […]

Use the DSUM function to add data according to set criteria in Excel

Mar 22, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks, Tips & Tricks

When analyzing your data, you may want to add certain parts of it up based on set criteria. You are able to do this using the DSUM Function in Microsoft® Excel®. This function enables you to drill down into your data and get specific results, leading to better decision making and ultimately, increased productivity. By […]

Use the TRIM function in Excel to easily remove spaces between data

Mar 16, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks

Are you constantly battling with the task of having to manually remove leading spaces between data? Now you can easily remove spaces from your data, except for single spaces between words, using the TRIM function from Microsoft® Excel®. Assuming you have imported data with irregular spacing into Excel an worksheet, in this tip we’ll show you how your […]

Use the MID and FIND functions in Excel to easily link a worksheet to a cell

Mar 9, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks

Some businesses use Microsoft® Excel® to prepare and present their business reports. Report headings often contain worksheet names, and to make your reports more efficient, you can link these worksheet names to a specific cell. So, instead of retyping the worksheet names in your report headings, you can easily apply the MID and FIND functions in […]

5 easy steps to stop PivotTables from returning deleted data in Excel

Mar 2, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks, Tips & Tricks

In some cases you might find yourself deleting data, and when applying a PivotTable that deleted data may resurface and cause a number of inaccuracies in your PivotTable. In this week’s tip we use 5 easy steps to ensure that when you apply PivotTables to your data, it will automatically refresh using only the applicable […]

All Solutions

All Solutions

Additional Reports

Sage Intelligence Tips & Tricks

Excel Tips & Tricks

All Solutions

Additional Reports

Sage Intelligence Tips & Tricks

Excel Tips & Tricks

Get Support Assistance

Knowledgebase

Report Writers

An easy way to generate PivotTables on separate worksheets in Excel

Easily organize data in Excel using multiple data consolidations for PivotTables

Get creative in Excel using sparklines to show data trends

An easy way to create a dual chart in Excel, trending with a secondary axis

Learn how to create a thermometer chart in Excel to show your performance against a set goal

How to create an Excel combination chart from scratch

Use the DSUM function to add data according to set criteria in Excel

Use the TRIM function in Excel to easily remove spaces between data

Use the MID and FIND functions in Excel to easily link a worksheet to a cell

5 easy steps to stop PivotTables from returning deleted data in Excel

Solutions

Resources

Learning

Support