Skip to main content
by learnformula
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
  1. Courses
  2. /Communication
  3. /Presentation Skills

Excel Dataviz: Charts that communicate trends in data

Learn how to create charts in Excel to communicate important trends in data to executives and stakeholders

Created byDavid Paradi
IntermediateUpdated Jan 22, 2025

What You'll Learn

  • check_circleLearn what chart type best communicates a trend in data
  • check_circleLearn how to write a chart title that summarizes the message
  • check_circleLearn how to create line charts in Excel that clearly communicate the message
  • check_circleLearn how to create and use advanced line charts in Excel

About This Course

Professionals who have to communicate important trends in data to executives and other stakeholders can improve their presentations and reports by using visuals instead of a table of numbers. This course teaches you practical techniques to choose the correct chart and create basic and advanced charts in Excel to communicate trends.

Field of Study: Computer Software & Applications

Course Content

14 activities • 13 videos • duration: 1h 6m

remove
Introduction1 videos • 1 min
  • videocamModule 1 Introduction
    Duration 1:59
add
Why line charts work best to communicate trends1 videos • 5 min
add
The importance of chart titles in summarizing the message1 videos • 2 min
add
How to add a chart title from a worksheet cell1 videos • 2 min
add
Making sure your line chart shows the trend accurately1 videos • 6 min
add
Automatically show the minimum and maximum values1 videos • 3 min
add
Create a line chart that shows actual and projected values1 videos • 2 min
add
Show the difference between two trends1 videos • 7 min
add
Directly label multiple lines instead of using a legend1 videos • 5 min
add
Create a panel line chart to compare trends1 videos • 9 min
add
Make one line stand out in a spaghetti line chart1 videos • 9 min
add
Create an index line chart for trends in different measurement units1 videos • 9 min
add
Conclusion1 videos • 1 quiz • 0 min
add
Final Assessment1 quiz

Your Instructor

David Paradi

menu_book3 courses
star119 reviews

Dave Paradi has been recognized by the media and his clients as a presentation expert. He has authored ten books on effective PowerPoint presentations and his ideas have appeared in publications around the world. Dave is one of fewer than ten people in North America recognized by Microsoft with the Most Valuable Professional (MVP) Award for his contributions to the PowerPoint, Excel, and Teams communities. His articles and videos on virtual presenting have been viewed over 3.5 million times and liked over 14,000 times on YouTube. He is a highly rated conference speaker and has delivered more than 500 customized training sessions around the world in the last 23 years.

Credit Information

What Students Are Saying

4.4 out of 5
Student's Choice
11 reviews

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Communication: Presentation Skills

    Mastering Mentimeter for Virtual Classrooms

    1 CPD hr
  • Communication: Presentation Skills

    How to Create Engaging Online Training: Miro Masterclass

    1 CPD hr
  • Leadership: Management Training

    Brilliant Change Management: Developing Your Credibility - creating a positive approach to Change

    2 CPD hrs