Course info

The following reference materials were provided as context. Use them as guidance only -- always prefer the latest, most current information over any potentially outdated content in these files. --- Reference: Microsoft Excel 365 - Charts.txt --- Microsoft Excel 365 - Charts, Formatting, and Reporting 1. Creating Charts Creating a Chart Changing the Chart Location and Size Changing the Chart Type Using Recommended Charts 2. Modifying Charts Working with Chart Elements Using Chart Styles and Colors Applying a Chart Filter 3. Working with Charts Formatting Chart Elements Adding and Removing a Data Series Printing Charts 4. Working with More Chart Features Creating a Sparkline Modifying Sparkline Types and Styles Creating and Using a Chart Template Managing Chart Templates 5. Creating Dashboards Understanding Dashboard Design Principles Creating a Dashboard Layout Using Charts, Sparklines, and Conditional Formatting Using Slicers for Interactive Dashboards 6. Using Styles and Themes Understanding Styles and Themes Working with Cell Styles Merging Styles Using Themes Creating Custom Themes 7. Using Templates Using Templates Creating a Template Using a Personal Template 8. Working with Formatting Creating and Using Custom Number Formats Applying Conditional Formatting Creating a Custom Conditional Formatting Rule Working with Conditional Formatting Rules Using the Quick Analysis Tool 9. Working with Print Options Working with Print Areas Creating and Using a Range Name for Printing Viewing a Sheet with Page Break Preview Working with Page Layout Tab Options Using Page Layout View 10. Managing Worksheet Views and Output Hiding and Unhiding Columns and Rows Creating Custom Worksheet Views Working with Custom Worksheets Views Exporting a Worksheet as a PDF File 11. Using Excel Data in Other Office Applications Understanding Pasting, Linking, and Embedding Pasting an Excel Range into a Word Document Pasting an Excel Chart into a Word Document Pasting an Excel Range into PowerPoint Pasting an Excel Chart into PowerPoint 12. Creating Charts in Other Office Applications Creating a Chart in Word or PowerPoint Modifying a Chart in Word or PowerPoint Maintaining Links with OneDrive/SharePoint Files 13. Visualizing Data with Map and Hierarchy Charts Inserting a Map Chart Creating a Treemap Chart Inserting a Sunburst Chart Creating a Funnel Chart 14. Analyzing Data with Statistical and Advanced Charts Creating a Histogram Inserting a Pareto Chart Creating a Box and Whisker Chart Inserting a Waterfall Chart Creating a Combo Chart