Excel Charts, Formatting and Reporting

Creating Charts Creating a Chart Changing the Chart Location and Size Changing the Chart Type Modifying Charts Working with Chart Elements Using Chart Styles Applying a Chart Filter Formatting Chart Elements Adding and Removing a Data Series Printing Charts Creating a Sparkline Creating and Using a Chart Template Creating a Dashboard Using Styles, Themes, and Templates Working with Cell Styles Merging Styles Using Themes Using Templates Creating a Template Using a Personal Template Working with Formatting Creating and Using Custom Formats Applying Conditional Formatting Creating a New Conditional Formatting Rule Working with Conditional Formatting Rules Using the Quick Analysis Tool Using Print Options Using Print Areas Creating and Using a Range Name for Printing Working with Print Settings Using Page Setup Tools Using Page Break Preview Using Print Titles Using Headers and Footers Printing Gridlines and Row and Column Headings Using Custom Worksheet Views Saving a Worksheet as a PDF File 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 Creating a Chart in Word or PowerPoint Modifying a Chart in Word or PowerPoint Working with Specialty Charts Understanding Specialty Charts Creating a Map Chart Creating a Treemap Chart Creating a Sunburst Chart Creating a Histogram Creating a Pareto Chart Creating a Box and Whisker Chart Creating a Waterfall Chart Creating a Funnel Chart Creating a Combo Chart