No items found.

Create an Excel Chart with REPT, TEXT and SUM

training industry - top 20 companytraining industry - top 20 companyWatch list company 2023
course library users
Create an Excel Chart with REPT, TEXT and SUM
This course is in the base subscription pack
Category
Personal Development
Course Duration
0:05
Subject Matter Expert
Deb Ashby
Provider
Assemble You
Countries
Australia, Ireland, New Zealand, United Kingdom, United States
ESG Course
Blog
No items found.
Suite
Endorser

Discover how to create a unique and visually exciting chart in Excel using the combo of REPT, TEXT and SUM functions. We'll show you through building a formula-driven chart without using traditional chart tools. Perfect for adding some flair to your spreadsheets while reinforcing core Excel skills.

Target Audience

Ideal for those looking to streamline workflows and make more effective use of Microsoft 365 applications.

Learning Outcomes

Learn to use the REPT function to repeat characters dynamically.

Combine REPT, TEXT and SUM to build custom formula-based charts.

Understand how to visualise data proportions using basic Excel functions.

Contextualised Content