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 Course
This online course is all about finding, sorting and sharing your data.
New in Excel 2013 is the Power View tool. Power View is an interactive data exploration, visualisation, 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.
Check out what’s covered in this course:
What-If Data Analysis
Power View (New in Excel 2013!)
Creating Custom Views & Comparing Workbooks
Collaborating on a Shared Workbook
Saving Your Document Online (New in Excel 2013!)
Formulas & Functions Course
Whether you’re new to Excel or a regular user, you'll soon realise 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.
In this online course you’ll get to know all about formulas and features like Paste Special, Lookup and Text functions, Data Consolidation and so much more.
What’s covered in this course?
Using Cell References
Statistical & Mathematical Functions
Date & Financial Functions
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. 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.
In this course, we’ll cover the following topics:
PivotTable Basics (New in Excel 2013! - Recommended PivotTables)
Formatting a PivotTable
Calculated Items & Fields
Sort & Filter a PivotTable (New in Excel 2013! - Creating a PivotTable Timeline to Filter Dates)
PivotCharts & Sparklines
Creating a PivotTable to Analyse External Data
Quick Explore and Hyperlinks
Handy Features (New in Excel 2013! - Viewing Two or More Worksheets)
If you already have access to this course, please login to the LMS to start the course. If you don‘t have access to this course and would like to gain access, please follow these steps:
- Send an e-mail to your line manager requesting access to the course
- Please include the following information in the e-mail to your manager:
1. Employee number
4. Name of the course
- Your manager will forward your request to the Learning department, who will notify you if and when access to this course is granted
- After access is granted, please sign in to the LMS to start the course.