Excel Charts, Formatting and Reporting

Overview Learn the essentials regarding visualizations in Excel. Create charts, use styles and templates, manage advanced worksheet formatting. Target Student This course is for individuals whose job responsibilities include publishing spreadsheet results and need to create visualizations and manage formatting and advanced reports. Prerequisites ` Excel Introduction or equivalent skills. *** Excel Power User Class *** Are you looking for a comprehensive intermediate or advanced Excel class that covers a wide range of topics? Our ` Excel Power User course provides the "best of" topics from 5 of our Excel classes. If you have a good foundation in Excel and want to be a Power User, this class is for you! This class will bring you up to speed on the latest features of Excel across all topics such as charting, database features, pivot tables, multiple worksheets, advanced functions and even an introduction to Macros. COURSE OUTLINE 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