Get creative with data visualization and infographics using Microsoft Excel functions with this free online course. Do you know that over 60% of people use Excel for data exploration and chart creation because of its flexibility and ease of use? Communicating data-driven results, motivation, and detection of defects are the important components of data analysis. Learn the skills needed to produce graphs and diagrams that are effective and professional and discover how to process data to be more visually appealing with this free online Microsoft Excel tutorial.
| College | Alison |
| Course ID | 201619 |
| Course Type | Online Learning |
| Course Qualification | CPD Certificate |
| Course Duration | 1.5-3 hours |
| Course Fee | Free |
| Entry Requirements | Like all courses on the Alison Free Learning platform this is a free, CPD-accredited course. A Graduate can choose to buy a certificate or diploma upon successful completion of a course, but this is not required or necessary. At Alison we believe that free education, more than anything, has the power to break through boundaries and transform lives. Alison is the world’s largest free online empowerment platform for education and skills training, offering over 5000 CPD accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone, to study anything, anywhere, at any time, for free online, at any subject level. Through our mission, we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone. |
| Career Path | What You Will Learn In This Free Course • Explain the concept of dashboards • Identify the functions of interactive dashboards in MS Excel • Discuss the dynamics of information–transformation–presentation in the context of interactivity • Explain how to set up, format and maintain an interactive legend dashboard • Describe how to set up, format and maintain an interactive chart dashboard • Outline the procedure for setting up, formatting and maintaining an interactive dashboard • Describe the importance of visual perception in the process of presenting information • Outline the concept of the Gestalt laws of grouping • Identify the various tips for using special and bullet charts • Recognise the need for using data visualisation • Explain the advantages of infographics in MS Excel |
| Course Code | 3861 |

Enrol with Alison today! This free online certificate course teaches you how to use CPR, AED, and first aid to save lives.
Enrol with Alison today! Learn how to give good care to the elderly with the nursing procedures and practices in this free online nursing course.
Enrol with Alison today! Learn the important functions and practices of human resource professionals in this free online diploma course.
Enrol with Alison today! In this free online course, learn how to implement the HACCP Food Safety System in your catering establishment.