1 option
Charts and graphs : learn Excel 365.
- Format:
- Video
- Language:
- English
- Subjects (All):
- Microsoft Excel (Computer file).
- Electronic spreadsheets.
- Business--Computer programs.
- Business.
- Physical Description:
- 1 online resource (1 video file (57 min.)) : sound, color.
- Edition:
- [First edition].
- Place of Publication:
- [Christmas, Florida] : Simon Sez IT, 2025.
- Summary:
- Charts and Graphs: Learn Excel 365 shows you how to transform raw data into clear, engaging visuals that tell a story. Whether you work with large datasets or prepare simple reports, this learning experience will help you create charts that make your information easy to understand and visually appealing. You will start by exploring Excel 365's interface, focusing on the 'Insert' tab, where all chart types are found. You'll learn to select relevant data, exclude unnecessary totals, and choose from Excel's recommended charts for the best starting point. You'll use the Chart Design and Format tabs from there to customize layouts, adjust colors and labels, and switch chart types for the clearest presentation. As you progress, you'll discover advanced techniques to enhance your data storytelling. This includes adding graphics, text boxes, and icons to emphasize key insights and linking chart titles to worksheet data so they update automatically when your data changes. You'll also work with specialized chart types such as area, radar, bubble, surface, and candlestick stock charts. Step-by-step exercises will guide you in adjusting axes, refining aesthetics, and improving readability to create professional-quality visuals. By the end, you will have the skills to present data accurately, visually engagingly, and easily for any audience to understand, allowing you to make stronger, data-driven presentations and reports. In this course, you'll learn how to: ⁰́Ø Select data and insert different chart types in Excel. ⁰́Ø Modify chart elements (titles, labels, colors, legends). ⁰́Ø Utilize formulas to link chart titles to cell data. ⁰́Ø Distinguish between area charts and other chart types. ⁰́Ø Create and rotate surface charts for data visualization. ⁰́Ø Use radar charts to compare multiple data points. ⁰́Ø Plot three variables on a bubble chart in Excel. ⁰́Ø Import stock data and create candlestick charts. ⁰́Ø Optimize chart aesthetics for compelling data storytelling. The following files are included in the Resources section below: Exercise Files - Used to practice and complete the course exercises. Course Files - Used to follow along with the instructor during lessons.
- Notes:
- OCLC-licensed vendor bibliographic record.
- OCLC:
- 1535648650
- Publisher Number:
- 10498SSIMONSEZIT
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.