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. /Office Productivity
  3. /MS Excel

Excel Charts Masterclass for Small Businesses

Master Excel Charts to Communicate Your Message Clearly.

Created byDavid Fortin
BeginnerUpdated Nov 19, 2024

What You'll Learn

  • check_circleLearn to communicate a clear message using Excel charts by curating information, removing unnecessary elements, and ensuring comprehension within 5 seconds
  • check_circleRecognize when to use Pie Charts, Bar Charts, or Line Charts in real-life professional contexts.
  • check_circleApply best practices for creating charts to enhance business understanding and facilitate effective business discussions.
  • check_circleCreate basic charts, including clustered bar charts, stacked bar charts, and bar charts with totals in Microsoft Excel.
  • check_circleCreate basic pie charts, doughnut charts, and pie-of-pie charts in Microsoft Excel.
  • check_circleCreate pivot charts by pivoting data to group and display specific data in chart format. Learn to easily update the data set.

About This Course

Struggling to create Excel charts that actually communicate the right message? You're not alone. Most professionals find Excel charting frustrating, often unsure where to click or how to make their data truly stand out. This masterclass will change that.

  • Design Professional Charts: Master techniques like color gradients, data labels, and adjusting data series to create visually compelling charts.
  • Communicate Clearly: Learn to convey the right message by curating data, removing clutter, and ensuring your charts are understood within 5 seconds.
  • Choose the Right Chart: Know when to use Pie, Bar, or Line Charts in real-world scenarios to best represent your data.
  • Apply Best Practices: Create charts that enhance business understanding, making your presentations and discussions more effective.
  • Create Basic Charts: From clustered bar charts to pie-of-pie charts, you'll build foundational chart types with ease.

Course Content

6 activities • 25 videos • duration: 1h 22m

remove
Introduction4 videos • 5 min
  • videocamMy professional career as a CPA (Who's your instructor)
    Duration 1:43
  • videocamHow to use this course (The Course Format)
    Duration 1:06
  • videocamThe Kingdom Candy (This course use case and dataset)
    Duration 0:57
  • videocamCharts Basics
    Duration 1:53
add
Bar Charts6 videos • 13 min
add
Pie Charts6 videos • 10 min
add
Line Charts4 videos • 15 min
add
Combo Charts & Pivot Charts (Assignment free, yay!)3 videos • 8 min
add
Additional Material2 videos • 27 min

Your Instructor

David Fortin

Chartered Professional Accountant & Microsoft MVP

menu_book3 courses
star562 reviews

David Fortin is a Chartered Professional Accountant (CPA) and a 2024 Microsoft MVP. He runs Piggy Bank Accountant, a YouTube channel where he shares practical insights on Excel and Microsoft Copilot. With a background in Financial Planning & Analysis (FP&A) for a SaaS startup, David was instrumental in raising $30 million in venture capital funding and played a key role in the company’s successful exit, valued at hundreds of millions. Known for his dynamic and energetic personality, David is all about helping people, which he does through his online courses on Excel and Copilot. What sets David apart is his ability to make learning fun and engaging, bringing a unique energy to his videos that resonates with his audience.

Credit Information

Professional development requirements vary by profession, country, and regulatory body. Before enrolling, review the course details and confirm that the content, learning format, and any listed credits meet your specific requirements. You are responsible for confirming eligibility with your regulator or professional association and keeping the records required for reporting.

What Students Are Saying

4.6 out of 5
Student's Choice
97 reviews
  • MP
    Mark P.
    starstarstarstarstar

    Great refresher on charts.

  • JT
    Jill T.
    starstarstarstarstar

    Yes it was really good.

  • BM
    Barbara M.
    starstarstarstarstar

    Well done.

  • JA
    John A.
    starstarstarstarstar

    yes. I am often needing to know the finer points of excel charting for my work.

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

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(523 reviews)
    2 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(610 reviews)
    2.5 CPD hrs
  • Ethics: Ethics for Accountants

    4-Hour Ethics for Accountants 2026

    starRated5.0out of 5,(109 reviews)
    4 CPD hrs