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.



 

You’ll discover how to use familiar Microsoft® Excel® 2013 features and functions to extract actionable insights from your financial data. This six-lesson course takes you from best practices for dashboard design, through setting up a workbook, useful functions for referencing, looking up, and analyzing data, to tips for creating custom visualizations, and culminates in finishing touches for your dashboard, such as interactive controls. Throughout the course, you’ll get guided hands-on experience by creating a sample dashboard.

 

Course Prerequisites:

  • Basic understanding of financial statements including income and expense analysis
  • Intermediate Microsoft Excel skills including Named Ranges, Absolute Referencing, Basic Functions, Nesting, and Chart Formatting.

 

Check out what’s covered in this course:

  • Build your own interactive dashboard from the ground up
  • Dashboard design best practice
  • Data analysis using advanced Excel functions and nesting
  • Create custom charts
  • Add interactive controls

 

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 a whole year 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, and will be available for the next 12 months.

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!

$

Course also included in: