I Want Answers
By submitting this form, you are giving your express
written consent for PPG to contact you regarding our
services using email, telephone or text - including our
use of automated technology for calls and periodic texts
to any wireless number you provide.
Excel Charts, Formatting and Reporting (2016, 2019, 365)
Learn the essentials regarding visualizations in Excel. Create charts, use styles and templates, manage advanced worksheet formatting.
· Format a Worksheet · Apply Number Formats · Align Cell Contents · Apply Styles and Themes · Apply Basic Conditional Formatting · Create and Use Templates · Visualize data by using basic charts · Modify and Format Charts · Use Advanced Chart Features
To ensure successful completion of this course we recommend taking Microsoft Office Excel 2013/2016 Introduction or have the equivalent knowledge.
Creating Charts Understanding Chart Types Creating a Chart Changing the Chart Location and Size Changing the Chart Type Modifying Chart Elements Formatting Chart Elements Adding and Removing a Data Series Applying a Chart Filter Printing Charts Working with Charts Creating a Hierarchy Chart Creating a Histogram Creating a Pareto Chart Creating a Box and Whisker Chart Creating a Waterfall Chart Creating a Combo Chart 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
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323