PowerPivot & PowerView in Excel 2013

Put a new spin on your business reporting with PowerPivot and PowerView, business intelligence add-ins for Excel. In this interactive five-lesson course, you’ll get hands-on experience importing millions of rows of data into Microsoft® Excel® PowerPivot at the click of a button, modeling and analyzing your data, and then visualizing your model in an interactive PowerView dashboard.

What’s New in Excel 2016

Get a taste of the exciting new and improved business reporting features. This short interactive Microsoft® Excel® course gives you hands-on experience with impressive charts to help you enrich your reports, new functions, enhanced PivotTable functionality such as automatic time grouping, one-click forecasting capabilities, and your new secret weapon, the handy “Tell Me” text box. This one’s on us – just another way Sage Intelligence is helping you work smarter.

Excel on Steroids 2013 – Three Course BUNDLE

Microsoft® Excel® 2013 offers new, powerful functionality for intuitive and intelligent business reporting. It offers a cleaner look and feel and is also designed to help you get professional-looking results quickly. You’ll find many new features that let you get away from endless sheets of values and draw more persuasive pictures of your data; guiding you to better, more informed decisions. Take advantage of these ground-breaking features and functions in the three online courses within Excel on Steroids 2013. All of our courses have been designed, along with the use of images, videos, interactive exercises and quizzes, to create an enjoyable digital training experience. So why not save money and buy a bundle?

Data Analysis and Dashboards in Excel 2013

Data Analysis and Dashboards in Excel® 2013 gives you the tools to analyze complex financial information, and present it as simply and clearly as possible, to help you quickly and easily review key performance areas, compare data, and recognize trends.

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.