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.



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) 

Frequently Asked Questions

How long will this course take to complete?
This course is designed to take you about 3 hours to complete.

My day is jam-packed and I don’t have a lot of time. How long do I have to complete the course?
We give you six months to complete your course, so even if you can’t get to it immediately, that’s okay. You’ll have plenty of time to get it done.

How can I pay for my course?
We offer two payment options on our Academy store.

  1. Online Payment:
    South Africa:

    You can pay with either your credit card (Visa or MasterCard), or using your PayU Wallet.

International:
Pay with your credit card via PayPal.

  1. Manual Payment (EFT / Bank Deposit):
    South Africa:

    You can choose the Manual Payment option when purchasing your course.
    Your course will only be activated once an EFT or Bank Deposit has been made and proof payment has been sent through to accounts.dbn@alchemex.com

International:
Not available.

Will I know when my course is available?
Yes.
If you pay via Credit Card or PayPal, and your payment was successful, your course will be available to you immediately.

If you pay via EFT and have sent through your proof of payment, our Academy administrator will activate your course and you will receive a “Purchase Successful” email from intelligence.enablement@sage.com

Go on, give it a try!
Good luck!