Excel Advanced Formatting & Charting

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.

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