Sage X3 Intelligence Reporting – Financial Report Design

Sage Intelligence is a Microsoft Excel based reporting tool that pulls data from Sage X3 and delivers it in an Excel format that is easy to understand and manipulate, putting you in control of the design of your reports. Learn about your Sage X3 Intelligence Reporting tool. We recommend that you also attend the Sage Intelligence Beginner and Intermediate courses, preferably before you do this course. It is important to note that the Advanced course is only suitable if you are going to be working with the Connector module.

Discovering Excel 2010 Course

Discovering Excel 2010 online course will equip you with the Excel knowledge you need to progress to Excel on Steroids, which will help you become proficient in report writing.

Excel on Steroids 2013 – Formulas and Functions Course

Whether you're new to Microsoft® Excel® or a regular user, you'll soon realize that it's more than just a grid in which you enter numbers in columns or rows. You can use Excel to find totals for a column or row of numbers, but you can also calculate a mortgage payment, solve math problems, or create a best and worst case scenario based on variable numbers that you plug in. Excel quickly and easily does this by using formulas in cells. A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

Excel on Steroids 2013 – Data Analysis Course

This online course is all about finding, sorting and sharing your data. New in Microsoft® Excel® 2013 is the Power View tool. Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting. It lets you create interactive charts, graphs, maps, and other visuals that bring your data to life. It’s a game changer and we’re going to show you how it works. Once you have the data you need, in the format you need it in, it’s time to share your workbook with your colleagues. Collaborating on a shared workbook, or saving your document online so that others can access it are the quickest and simplest methods of sharing your document. Not sure how to go about this? Don’t worry, we’ll take you through the step-by-step process on how to share your document.

Excel on Steroids 2013 – PivotTables and PivotCharts Course

Being able to analyse all the data in your worksheet can help you make better business decisions, but sometimes it’s hard to know where to start, especially when you have a lot of data. Microsoft® Excel® can help you by recommending and then automatically creating PivotTables, which are a great way to summarise, analyse, explore, and present your data. This course will get you up and running with PivotTables, then show you how to create a PivotChart from your PivotTable. We’ll also show you how to draw attention to important items and trends in your data using Sparklines. These are tiny charts inside the background of single worksheet cells that can be used to visually represent and show a trend in your data. Showing trends in your worksheet data can be useful, especially when you’re sharing your data with other people.