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 […]

Enjoy customized, flexible reporting with the Report Manager module: Part 2 of 3

Feb 18, 2016 Nic Hanafey Leave a comment Blog, Business Intelligence

In part one of this three part series you learnt that Sage Intelligence allows you to manipulate data before placing it into Microsoft® Excel®. It’s a great way of removing unnecessary data. Now you are ready to create your own customized reports. By applying your Excel skills to further manage your data using PivotTables and […]

Microsoft Excel: The brilliance of spreadsheet applications

Feb 11, 2016 Ruth Gray Leave a comment Blog, Business Intelligence

I’ll start by saying I love Microsoft® Excel®, but then who doesn’t? Whether you drawing up your personal budget, planning your next holiday, creating surveys, running projects, calculating your loans or running your business, we all use this powerful spreadsheet application. And if you are not using Excel, you will continuously find yourself looking for […]

Easy steps on how to calculate multiple results in Excel using a data table

Feb 3, 2016 Edwin Chuza Leave a comment Excel Tips & Tricks

When you examine business data in Microsoft® Excel®, you may want to discover the result of formulas if you provide different inputs. You can calculate the results of those changes by using a data table. Using data tables makes it easy to examine a range of possibilities at a glance. You can create one or two […]

Our top 5 Microsoft Excel tips of 2015

Jan 22, 2016 Excel Tips Leave a comment Excel Tips & Tricks

In 2015 we shared a total of 40 Microsoft® Excel® tips with you. We’ve collated the best performing tips, and put together your top 5 tips. These top 5 Excel tips were viewed and revisited the most by our subscribers throughout the year. 1. How to create a waterfall chart in Excel A waterfall chart […]

Learn how to use the Goal Seek feature in Microsoft Excel to get a preferred result.

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

If you know the result you want from a formula, but you are unsure of what input value the formula requires to get that result, you can use the Goal Seek feature in Microsoft® Excel®. Goal Seek takes a result and determines possible input values that produce the result you are looking for. Data analysis […]

Learn how to easily access your consolidated financials in Excel

Jan 12, 2016 Sage Intelligence Tips Leave a comment Sage Intelligence Tips & Tricks

Consolidating your financials in a multi company business is a common requirement. The Sage Intelligence Consolidation Financial Report Designer makes this easy providing the data and functionality you need to assess how your entire company is doing, all in the familiar environment of Microsoft® Excel®. Through the combination of data contained in the Designer and Excel […]

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

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

Enjoy customized, flexible reporting with the Report Manager module: Part 2 of 3

Microsoft Excel: The brilliance of spreadsheet applications

Easy steps on how to calculate multiple results in Excel using a data table

Our top 5 Microsoft Excel tips of 2015

Learn how to use the Goal Seek feature in Microsoft Excel to get a preferred result.

Learn how to easily access your consolidated financials in Excel

Solutions

Resources

Learning

Support