GET ACCESS TO OUR ENTIRE COURSE LIBRARY FOR ONLY £99.00 PER YEAR. LEARN MORE
Data Visualisation in Microsoft Excel Course Description
Learn the Latest Skills | Accredited by CPD UK and IPHM | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training | Lifetime Access
This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.
This data visualisation in masterclass course is ideal for those who want to understand the most important charts such as bar and column charts, formatting charts, line charts, and more and its best practices. You will have a broad knowledge of Pivot charts, less used charts, and sparklines such as mini charts. This online course will teach you how to create infographics using excel charts and solve transportation problems using Excel goal seek. You will have a stronghold on fundamental visualisation principles, the 10-second rule, the good, the bad and the ugly data visualisation.
By the end of the course, you will have a deep understanding of data visualisation best practices, Excel chart formatting and customisation, and basic knowledge of Excel charts and graphs. This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Learning Outcomes:
By the end of the course, you will:
- Learn the elements of charts
- Understand why charts are used
- Know the categories of messages that can be conveyed
- Learn the most important charts such as area charts, pie and doughnut charts
- Learn why you should avoid Pie charts
- Understand the basics of Pivot tables and charts
- Know the less used charts such as stock charts, radar charts, and heatmaps
- Understand the mini charts
- Know scatter plot or XY chart
- Understand waterfall chart and hierarchy chart such as sunburst and treemap
- Learn combination charts
Accredited by CPD UK and IPHM
                                 Â
Accredited by The CPD Certification Service              International Practitioners of Holistic Medicine (IPHM)
How Will I Benefit?
- Boost your career in data visualization
- Deepen your knowledge and skills in your chosen field just in hours not years!
- Study a course that is easy to follow.
- Save money and time by studying at your convenient time
- Have access to a tutor whenever you are in need
So, what are you thinking about! Start getting the benefits by enrolling today!
Why Choose this Data Visualisation in Microsoft Excel Course:
- Accredited by The CPD UK
- Accredited by International Practitioners of Holistic Medicine (IPHM)
- Lifetime Access
- High-quality e-learning study materialsÂ
- Learn the most in-demand skills
- Self-paced, no fixed schedules
- MCQ Exam and 24/7 Support Included
- Available to students anywhere in the world
- No hidden fee
- Study in a user-friendly, advanced online learning platform
Who is this data visualisation in microsoft excel course for?
This interactive course is suitable for those who want to master data visualisation in Microsoft Excel and understand functions such as sparklines, pivot tables and charts, less used charts and more. It is apt for those who want to enhance their data visualisation skills and apply for various job opportunities.
Entry Requirement
- There are no academic entry requirements for this Data Visualisation in Microsoft Excel course, and it is open to students of all academic backgrounds.Â
- As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol.
Method of Assessment
On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately.
Certificate of Achievement
Endorsed Certificate from Quality Licence Scheme
After successfully passing the MCQ exam you will be eligible to obtain the Data Visualisation in Microsoft Excel Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organization for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65.
Certificate of Achievement from Lead Academy
After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.
Career path
This Data Visualisation in Microsoft Excel course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry.
Course Curriculum
Introduction and Basics | |||
Welcome to the Course! | 00:03:00 | ||
Why are charts used? | 00:02:00 | ||
Categories of messages that can be conveyed | 00:04:00 | ||
Elements of charts | 00:05:00 | ||
The Easy way of creating charts | 00:03:00 | ||
Most important charts & best Practices | |||
Bar and column charts | 00:12:00 | ||
Formating charts | 00:15:00 | ||
Best Practices: Bar Chart | 00:10:00 | ||
Line Charts | 00:09:00 | ||
Avoiding the Spaghetti plot | 00:05:00 | ||
Area Charts | 00:06:00 | ||
Pie and Doughnut Charts | 00:13:00 | ||
Why we should avoid Pie charts! | 00:04:00 | ||
Scatter plot or XY chart | 00:16:00 | ||
Frequency Distribution and Histograms | 00:13:00 | ||
Waterfall chart | 00:12:00 | ||
Hierarchy Charts: Sunburst and Treemap | 00:08:00 | ||
Combination charts | 00:07:00 | ||
Highlighting chart message | 00:03:00 | ||
Eliminating Distractions from the Graph | 00:07:00 | ||
Avoiding clutter | 00:05:00 | ||
Pivot charts | |||
Pivot Charts | 00:07:00 | ||
Pivot Table Basics | 00:08:00 | ||
Less used charts | |||
Stock charts | 00:11:00 | ||
Radar charts | 00:04:00 | ||
Surface charts | 00:05:00 | ||
Heatmaps | 00:05:00 | ||
Sparklines | |||
Mini charts: Sparklines | 00:05:00 | ||
Infographics using Excel charts | |||
Creative Infographic 1 | 00:14:00 | ||
Creative Infographic 2 | 00:06:00 | ||
Appendix: Bonus Excel functionalities | |||
How to solve transportation problem using Excel Goal-Seek | 00:12:00 | ||
Assessment | |||
Assessment – Data Visualisation in Microsoft Excel | 00:10:00 | ||
Order Your Certificate Now | |||
Order Your Certificate of Achievement | 00:00:00 | ||
Get Your Insurance Now | |||
Get Your Insurance Now | 00:00:00 | ||
Feedback | |||
Feedback | 00:00:00 |
REVIEWS
- £25.00 (Ex. VAT) Gift this course