Excel Charts and Visualization

This course helps you understand how to use Excel to build a myriad of interesting charts, starting with the basics and moving up to some of the most complex charts imaginable.

Business | core | 2 hours |   Published: Jan 2021

Overview

1.5KSTUDENTS*
93.2%RECOMMEND*

This course includes:

  • 2+ hours of on-demand video
  • 6 modules
  • Core level
  • Direct access/chat with the instructor
  • 100% self-paced online
  • Many downloadable resources
  • Shareable certificate of completion
This course helps you understand how to use Excel to build a myriad of interesting charts, starting with the basics and moving up to some of the most complex charts imaginable.

Skills You Will Gain

Excel
Excel charts
Excel Visualizations

Learning Outcomes (At the end of this program you will be able to)

Prerequisites

None other than a basic understanding of computers

Who Should Attend

Anyone interested in learning the core features and functions of Excel, and applying these skills in practical settings.

Curriculum

1Welcome to the course!

Instructor bio - John Bura

2Module 01: Introduction to the Course

Segment - 01 - Introduction to the Course

Segment - 02 - Why should you learn about Charts and Data Visualization

Segment - 03 - Introduction of the Instructor

Segment - 04 - Course Requirements (what software, experience)

3Module 02: Charts and Basics

Segment - 05 - What will we learn in this section

Segment - 06 - Main Principles and Chart Visualization Impact

Segment - 07 - Choosing the Correct Chart

Segment - 08 - Communicate with the End User

Segment - 09 - Section Summary

Segment - 10 - Challenge

4Module 03: Excel Chart Tools

Segment - 12 - Chart Design

Segment - 13 - Working with Chart Formats

Segment - 14 - Chart Types

Segment - 15 - Primary and Secondary Axis

Segment - 15A

Segment - 16 - Chart Templates

Segment - 17 - Section Summary

Segment - 18 - Challenge

5Module 04: Working with Basic Excel Charts & Graphs

Segment - 19 - What will we learn in this section

Segment - 20 - Excel Column Charts

Segment - 21 - Column Charts Challenge

Segment - 22 - Excel Bar Charts

Segment - 23 - Excel Bar Charts 1

Segment - 24 - Bar Charts Challenge

Segment - 25 - Excel Line Charts

Segment - 26 - Line Charts Challenge

Segment - 27 - Excel Pie Charts

Segment - 28 - Pie Charts Challenge

Segment - 29 - Excel Area Charts

Segment - 30 - Area Charts Challenge

Segment - 31 - Excel Scatter Charts

Segment - 32 - Scatter Charts Challenge

Segment - 33 - Excel Bubble Charts

Segment - 34 - Bubble Charts Challenge

Segment - 35 - Excel Stock Charts

Segment - 36 - Stock Charts Challenge

Segment - 37 - Excel Surface Charts

Segment - 38 - Surface Charts Challenge

Segment - 39 - Excel Radar Charts

Segment - 40 - Radar Charts Challenge

Segment - 41 - Excel Treemap Charts

Segment - 42 - Treemap Charts Challenge

Segment - 43 - Excel Sunburst Charts

Segment - 44 - Sunburn Charts Challenge

Segment - 45 - Excel Histogram and Pareto Charts

Segment - 46 - Histogram and Pareto Charts Challenge

Segment - 47 - Excel Waterfall Charts

Segment - 48 - Waterfall Charts Challenge

Segment - 49 - Excel Box & Whisker Charts

Segment - 51 - Excel Sparklines

Segment - 52 - Sparklines Challenge

Segment - 53 - Excel Color Scales

Segment - 54 - Color Scales Challenge

Segment - 55 - Excel 3D Map

Segment - 56 - 3D Map Challenge

Segment - 57 - Section Summary

6Module 05: Excel Advanced Data Visualization

Segment - 58 - What will we learn in this section

Segment - 59 - Data Visualization with Pivot Chart and Slicers

Segment - 60 - Data Visualization with Pivot Chart and Slicers Challenge

Segment - 61 - Create Break Even Chart

Segment - 62 - Challenge Create Break Even Chart

Segment - 63 - Rating Star Chart

Segment - 64 - Challenge Rating Star Chart

Segment - 65 - Drop Down Menu for Chart

Segment - 66 - Challenge Drop Down Menu for Chart

Segment - 67 - Risk Score Chart

Segment - 68 - Risk Score Chart Challenge

Segment - 69 - Dynamic Chart Update

Segment - 70 - Challenge Dynamic Chart Update

Segment - 71 - Section Summary

7Module 06: Conclusion

Segment - 72 - Course Summary and Next Steps

Instructors

John Bura

John Bura

With over 15 years of experience in game development and elearning, based in Vancouver, Canada. As the CEO of Mammoth Interactive, I lead a team known for creating top-ranking games and applications across multiple platforms. My leadership also extends to Devonian Apps, where I drive innovation in SaaS products, emphasizing quality and rapid delivery. At the core of my career is my passion for education through technology. As an instructor on Udemy, I've empowered over 300,000 students worldwide with courses covering HTML5, Xcode, and game design. My teaching style, celebrated for its clarity and practicality, has garnered recognition across various platforms. At Centennial College, I advise on game design curriculum, ensuring students receive cutting-edge training essential for success in the industry. My influence reaches beyond traditional roles, with projects featured by major industry players like Nickelodeon. My blend of creative vision and technical expertise makes me a catalyst for productivity. Beyond gaming and software, I'm committed to fostering innovation and educational empowerment through accessible online courses that equip learners with essential, industry-relevant skills.

Frequently Asked Questions

How much do the courses at Starweaver cost?

We offer flexible payment options to make learning accessible for everyone. With our Pay-As-You-Go plan, you can pay for each course individually. Alternatively, our Subscription-Based plan provides you with unlimited access to all courses for a monthly or yearly fee.

Do you offer any certifications upon completion of a course at Starweaver?

Yes, we do offer a certification upon completion of our course to showcase your newly acquired skills and expertise.

Does Starweaver offer any free courses or trials?

No, we don't offer any free courses, but we do offer 5-day trial only on our subscriptions-based plans.

Are Starweaver's courses designed for beginners or advanced students?

Our course is designed with three levels to cater to your learning needs - Core, Intermediate, and Advanced. You can choose the level that best suits your knowledge and skillset to enhance your learning experience.

What payment options are available for Starweaver courses?

We accept various payment methods such as major credit cards, PayPal, wire transfer, and company purchase orders. For more information related to payments contact customer support.

Do you offer refunds?

Yes, we do offer a 100% refund guarantee for our courses within a specified time frame. If you are not satisfied with the course, contact our customer support team to request a refund with your order details. Some restrictions may apply.

*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.