GoSkills Excel Challenge 45 - October 2024: Create an Interactive Sales Chart

Jump into this week's Excel challenge, where we’ll be building a dynamic sales report using only formulas! This exercise is perfect for sharpening your skills in data organization and visualization—without any PivotTables. 🚫📊

🔗 Ready to get started? Grab your worksheet here: https://www.goskills.com/Excel/Resources/Excel-challenge-45?utm_source=youtube&utm_medium=social&utm_campaign=f6AOxwUlvAI

Challenge overview:
✅ Task 1: Fill in the Category and Sales columns based on quantity and price per unit.
✅ Task 2: Set up a drop-down list to select date ranges to display total sales per item.
✅ Task 3: Create a dynamic chart that:
→ Displays sales in descending order
→ Updates the chart title based on selected categories and dates
→ Adjusts the chart size to fit the selected category
→ Includes an “All” option to view total sales for all categories

🚀 Want to showcase your solution or swap tips with fellow enthusiasts? We're eager to see how you tackled this challenge! Join our Slack channel to share insights, learn from others, and connect with our vibrant community: https://goskills.typeform.com/to/h0GBH4oe

🔔 Get a reminder of Maria's solution next week here: https://www.youtube.com/watch?v=RmLQw7jT4I8. Subscribe to @GoSkillsCourses to get a reminder.

👀 Looking for more challenges? Check out previous challenges to keep leveling up your Excel skills: https://www.youtube.com/playlist?list=PLTK1y0C1Dwegf0ycGCqJSwbcR_lF56gGf

📚 Continue learning! Enhance your Excel skills with our in-depth courses: https://www.goskills.com/Excel/Courses?utm_source=youtube&utm_medium=video&utm_campaign=f6AOxwUlvAI

#ExcelChallenge #DynamicReports #ExcelFormulas #DataVisualization #SalesReport #LearnExcel #ExcelTips

Stay connected for career-boosting updates:

☑️ Facebook: https://www.facebook.com/GoSkills
☑️ LinkedIn: https://www.linkedin.com/school/go-skills
☑️ Twitter: https://twitter.com/getgoskills
☑️ Instagram: https://www.instagram.com/goskills/

Or visit our website: https://www.goskills.com/?utm_source=youtube&utm_medium=video&utm_campaign=f6AOxwUlvAI

Видео GoSkills Excel Challenge 45 - October 2024: Create an Interactive Sales Chart канала GoSkills.com