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.
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.
You can pay with either your credit card (Visa or MasterCard), or using your PayU Wallet.
Pay with your credit card via PayPal.
Manual Payment (EFT / Bank Deposit):
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 firstname.lastname@example.org
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 email@example.com
Go on, give it a try! Good luck!
Course also included in:
Request for access to
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.