Excel Advanced Formatting & Charting
Welcome to the Excel IV Advanced Formatting and Charting class!
In this course, we will explore the incredible power of charts in Microsoft Excel, equipping you with the skills to visually represent and analyze your data effectively. We will begin by learning how to create charts and explore a wide range of chart types available to us. You will discover how to enhance your charts by adding elements such as titles, labels, and legends, providing context and clarity to your visualizations. We will delve into scales and axes, enabling you to customize and control the display of data on your charts. Additionally, we will explore various formatting options to make your charts visually appealing and impactful. Furthermore, we will dive into advanced chart formatting techniques, allowing you to fine-tune and customize every aspect of your charts to meet your specific requirements. By the end of this class, you will be equipped with the knowledge and skills to create professional, dynamic, and insightful charts in Excel. Get ready to unlock the true potential of your data as we embark on this journey of advanced charting and formatting.
Scheduled Dates
Course Name | Date | Time | Open Seats In-Person | Open Seats Online | Price | |
---|---|---|---|---|---|---|
Excel Advanced Formatting & Charting | 10/26/2024 (Sat) | 1PM - 4PM | 5 | 4 | $125.00 | Register |
Need a Different Date?
Do the current classes not work for your schedule, or are no classes currently available? No problem! Visit our Schedule a Class page and choose an available day and time or call us at (909) 981-6331 for more information.
Topics Include:
Charting
- Chart Types
- Create a chart
- Verify or change the chart source data
- Add or modify chart elements:
- Titles
- Axes
- Legends
- Labels
- Scale
- Data Tables
- Chart Location
- Move and Resize
- Format the chart:
- Add Borders, colors, and fill effects
- Select font size, color, and orientation
Advanced Formatting
- Use the Format Painter
- Conditional Formatting
- Cell Styles
- Themes
- Number format codes
- Placeholders and the Cheat Sheet
- Using and formatting Comments
- Using the new SmartArt Feature