Additional Reports

Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.

Webcasts

Want to become a Sage Intelligence whiz? We present regular webcasts of forty-five minutes to one hour on various topics to get you up to speed. Choose your product below to see what we have in store for the next few months. If you want to know more about what a webcast is, click here.

Templates and Quick Guides

Check out our informative guides for advice about your business, and make use of our templates to help make your business more efficient.

eBooks

Check out our informative e-books to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.

Tips & Tricks

Customer Stories

Don’t take our word for it, hear from our customers who can’t stop raving about how Sage Intelligence Reporting has changed their lives. You might even find a solution in their story to a similar issue you’re facing.

Additional Reports

Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.

Webcasts

Want to become a Sage Intelligence whiz? We present regular webcasts of forty-five minutes to one hour on various topics to get you up to speed. Choose your product below to see what we have in store for the next few months. If you want to know more about what a webcast is, click here.

Templates and Quick Guides

Check out our informative guides for advice about your business, and make use of our templates to help make your business more efficient.

eBooks

Check out our informative e-books to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.

Tips & Tricks

Customer Stories

Don’t take our word for it, hear from our customers who can’t stop raving about how Sage Intelligence Reporting has changed their lives. You might even find a solution in their story to a similar issue you’re facing.

Sage Intelligence Academy

Microsoft Excel Training

Improve your Microsoft® Excel® skills and learn how to produce insightful business reports.

Discovering Excel: If you have basic Excel knowledge you would beneﬁt from attending this intermediate Excel course.

Excel on Steroids: If you use Excel extensively for business reporting, then this course is for you. The course is divided into three workshops covering specific topics in Excel.

Excel on Steroids Plus: Data analysis, visualisation and dashboards will teach you how to model your data, create interactive dashboard reports, and make analysing your data much easier, giving you clearer insights into your company.

Sage Intelligence Training

From helping you get started with Sage Intelligence Reporting through to connecting to various databases to create consolidated reports, we have a range of Sage Intelligence Reporting courses designed to upskill you so that you get the most out of your reporting solution.

Additional Reports

Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.

Webcasts

Want to become a Sage Intelligence whiz? We present regular webcasts of forty-five minutes to one hour on various topics to get you up to speed. Choose your product below to see what we have in store for the next few months. If you want to know more about what a webcast is, click here.

Templates and Quick Guides

Check out our informative guides for advice about your business, and make use of our templates to help make your business more efficient.

eBooks

Check out our informative e-books to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.

Tips & Tricks

Customer Stories

Don’t take our word for it, hear from our customers who can’t stop raving about how Sage Intelligence Reporting has changed their lives. You might even find a solution in their story to a similar issue you’re facing.

Sage Intelligence Academy

Microsoft Excel Training

Improve your Microsoft® Excel® skills and learn how to produce insightful business reports.

Discovering Excel: If you have basic Excel knowledge you would beneﬁt from attending this intermediate Excel course.

Excel on Steroids: If you use Excel extensively for business reporting, then this course is for you. The course is divided into three workshops covering specific topics in Excel.

Excel on Steroids Plus: Data analysis, visualisation and dashboards will teach you how to model your data, create interactive dashboard reports, and make analysing your data much easier, giving you clearer insights into your company.

Sage Intelligence Training

From helping you get started with Sage Intelligence Reporting through to connecting to various databases to create consolidated reports, we have a range of Sage Intelligence Reporting courses designed to upskill you so that you get the most out of your reporting solution.

Quick Support Pre-checks

Performing these three quick pre-checks helps most of our customers wanting support.

Get Support Assistance

Can’t find the solution to the challenge you’re facing in the resource library? No problem! Our highly-trained support team are here to help you out.

Knowledgebase

Did you know that you also have access to the same knowledgebase articles our colleagues use here at Sage Intelligence? Available 24/7, the Sage Intelligence Knowledgebase gives you access to articles written and updated by Sage support analysts.

Sage Community

Engage with business partners and other like-minded customers right now on the Sage Intelligence Reporting Community.

Sage City

Similar to the Sage Intelligence Reporting Community but targeted at the North American market, Sage City is your very own forum to chat to business partners and like-minded customers across the globe.

Report Writers

Having some trouble creating or customizing the exact report you need to suit your business’s requirements? Contact one of the expert report writers recommended by Sage Intelligence.

Give Feedback

We love hearing from our customers. Do you have feedback on Sage Intelligence Reporting? Let us know, we’re all ears!

How to create a linked dashboard (or landing page) for your Excel workbook

Have you ever had the pleasure (or displeasure) of working with an extra large Excel workbook with many, many different sheets? This happens frequently, especially if you are working with a large amount of data that needs to be analyzed periodically. This may be due to multiple tables, lookups, references, charts, graphs etc.

This has the tendency to have you create many different sheets—each one having its own specific function and purpose.

You may notice however, that as the data grows, the number of sheets increases—forcing you to have to scroll through the list of tabs to get to the specific sheet desired.

But what if business is so good that you now have around 10, 20 or more sheets? Having to scroll back and forth through the tabs to get to each sheet to verify and hence analyze information would be a nightmare.

This is where a linked dashboard (or a landing page) comes in handy, and is a very quick fix for this quandary.

This has the effect of taking you to the desired sheet by just one click of a button and back to the dashboard with another.

Let’s get started:

What I have here is a workbook with multiple sheets consisting of tables, charts, graphs, raw data etc. Each sheet in the workbook serves its purpose. I would like to access the information in each workbook without having to scroll through the tabs at the bottom of the workbook all the time.

Notice the tabs at the bottom of the page denoting each sheet (this can get quite bothersome as they increase in number):

So how do we accomplish this?

Step one: create a Landing page (or Dashboard or home page)

I have created a very simple, but effective, landing page called “Dashboard” and added the names of sheets I would like to link to. For best practices, it is often handy to name them after the tabs they are going to point to. Hence, I have named them after the tabs in the workbook respectively.

Step two: Create and insert links

We are going to start by inserting a link for the “Home” worksheet (not to be confused with the landing page). This is how we do this:

Click in the cell containing the text you want to become the link (in this case cell D4 as it contains the word “Home”).

From the main menu in excel, click on insert, then Link (hint: you can also hit ctrl+K) on your keyboard.

A list may or may not appear (this contains previously opened workbooks on your machine or online).

Scroll all the way down and choose “insert link”.

A dialogue box appears. Leave the “text to display” as “Home” (unless you want it to read something else).

On the left (under the “Link to” options), choose “Place in this document”.

Now instead of typing in a cell reference, choose the option “Or select a place in this document” and choose the “Home” worksheet.

After clicking OK there is a now a hyperlink inserted on the Landing page. The result will look like this:

When clicking on the “Home” link, it takes me to the sheet labeled “Home”, which you can customise as you see fit.

Do this for the rest of the sheets you would like your dashboard to link to.

Points to ponder:

Now would be a good time to include a link pointing back to the landing page. This will enable you to go back to the landing page (dashboard) without having to scroll all the way from whence you came.

Once this is done, to get this same link on the rest of your sheets, simply copy that link (ctrl+c) and paste on the other pages. No need to perform the same steps of inserting a link.

Links can be formatted to your specifications (color, size etc.)

Hopefully this should help save you time and limit the needless scrolling when working with multiple sheets in one workbook.

David Ako-Bryant

David is a Sage Intelligence Product Specialist and business intelligence extraordinaire! Based in the United States of America, David revels in ensuring our customers are getting the most out of their favorite reporting solution.