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 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:

  • Sorting Data
  • Subtotalling Data
  • Filtering Data
  • Data Validation
  • What-If Data Analysis
  • Power View (New in Excel 2013!)
  • Macros
  • 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?

  • Data Consolidation
  • Conditional Formatting
  • Worksheet Protection
  • Managing Data
  • Preparing Data
  • Using Cell References
  • Lookup Functions
  • Text Functions
  • Logical Functions
  • 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)
  • PivotTable Options
  • Formatting a PivotTable
  • Calculated Items & Fields
  • Sort & Filter a PivotTable (New in Excel 2013! - Creating a PivotTable Timeline to Filter Dates)
  • Consolidated PivotTable
  • PivotCharts & Sparklines
  • Creating a PivotTable to Analyse External Data
  • Quick Explore and Hyperlinks
  • Handy Features (New in Excel 2013! - Viewing Two or More Worksheets) 

$