eLearnAfrica
Design and Create Custom Dashboards in Excel
The Excel Club
  • Start Date: 29 Jul, 2024
  • 6 weeks
  • Study Content: Videos


Enhance your Excel charting skills and discover the tools and skills to create advanced and automated dashboards.

Course Fee: Free
Certificate Cost: See Fees and Eligibility
Enrol Now

Course Description

This course is made available through the eLearnAfrica and FutureLearn partnership.

Develop Excel dashboards to present data effectively


Dashboards can be used at every level of an organization to provide value, track progress and KPIs, and reveal insights. Organisations are working with more data every day and the skills to create dashboards in Excel are in high demand.


On this six-week course from The Excel Club, you will learn how to build dashboards from scratch before putting this knowledge into practice by creating three informative and visually stunning interactive Excel Dashboards.


Get started with designing your custom dashboard


This practical course will guide you through Excel dashboard design and creation from start to finish.


You’ll begin by discussing the three types of dashboard before covering the basics of creating them. You’ll also learn the top tips for creating a dashboard as well as the most common mistakes to avoid to ensure your dashboards work effectively.


Learn how to automate your interactive dashboard


As you progress through this course, you’ll move through each step of the dashboard creation process, helping you to make your dashboards dynamic.


Once you’ve learnt the step-by-step process, you’ll learn how to automate charts with named ranges, linking the data, using the offset function, and then linking charts to names. You’ll also focus on the INDEX function to use on subsets of data.


Use VLookup and form controls to easily change your charts


Before working on your own dashboards, this course will take you through how to change charts using different tools. You’ll explore setting up data validation and changing the charts with VLookup, as well as how to add form controls and implement them to change charts.


In the final week of this course, you’ll create three different dashboards, each with their own data and objectives to help you put your new skills into practice.


This course has been designed for anyone looking to enhance their Excel charting skills and learn advanced techniques to visualise data.


With advanced Excel skills being in high demand, this course will help in any role or industry that handles and presents data.


To take part in this course you will need a version of Excel. You can sign up for a 30 day trial directly with Microsoft get Excel 365


Certificate cost may vary. You will be redirected to the host page for cost and payment options.

The Excel Club

This university is part of the partnership between eLearnAfrica and FutureLearn.

This institution is available on eLearnAfrica through partnership with FutureLearn.

You may be able to download course materials after enrolling in this course. If not, all of the necessary course materials provided by the course instructor will be available on the provider's course page.
COLLABORATION POLICY

By enrolling in a course on or through eLearnAfrica, you are joining a special worldwide community of learners. The aspiration of eLearnAfrica is to provide anyone with an internet connection access to courses from the best universities and institutions in the world and to provide our learners the best educational experience internet technology enables. You are a part of the community that will help eLearnAfrica achieve this goal. eLearnAfrica depends upon your motivation to learn the material and to do so with honesty and academic integrity. In order to participate in eLearnAfrica, you must agree to the Honor Code below and any additional terms specific to a class.

ELEARNAFRICA HONOR CODE PLEDGE

By enrolling in a course, program, or degree hosted on the eLearnAfrica App or Site, I agree that I will:

  • Complete all tests and assignments on my own, unless collaboration on an assignment is explicitly permitted.

  • Maintain only one user account and not let anyone else use my username and/or password.

  • Not engage in any activity that would dishonestly improve my results, or improve or hurt the results of others.

  • Not post answers to problems that are being used to assess student performance.

  • Abide by any and all requirements of the eLearnAfrica Participants as may regard the expectations of civil or academic behavior or of community standards.

VIOLATIONS

If you are found in violation of the Terms and Conditions or Honor Code, you may be subject to one or more of the following actions:

  • Receiving a zero or no credit for an assignment;

  • Having any certificate earned in the course withheld or revoked;

  • Being unenrolled from a course, learning program or degree program; or

  • Termination of your use of the App and/or Site.

  • Additional actions may be taken at the sole discretion of eLearnAfrica and eLearnAfrica course providers. 

No refunds will be issued in the case of any corrective action for such violations.

Honor code violations will be determined at the sole discretion of eLearnAfrica, the Partners, or Members. You will be notified if a determination has been made that you have violated this honor code and you will be informed of the corresponding action to be taken as a result of the violation.

CHANGING THE HONOR CODE

Please note that we review and may make changes to this Honor Code from time to time. Any changes to this Honor Code will be effective immediately upon posting on this page, with an updated effective date. By accessing the App and/or Site after any changes have been made, you signify your agreement on a prospective basis to the modified Honor Code and any changes contained therein. Be sure to return to this page periodically to ensure familiarity with the most current version of this Honor Code.

Effective Date: September 22, 2016