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 Database Features and PivotTables (2016, 2019, 365)
Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. Harness the power of PivotTable features and create PivotCharts to help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables.
· Use Lists · Use Table Features · Manipulate Data · Create and Work with PivotTables · Enhance PivotTables
To ensure successful completion of this course we recommend taking Microsoft Office Excel 2013/2016 Introduction or have the equivalent knowledge.
Using Lists Using Auto Fill to Enter Data Using AutoComplete Creating and Using Absolute Named Ranges Working with Data Validation Inserting and Deleting Columns or Rows Freezing and Unfreezing Panes Splitting a Worksheet Window Using Functions with Lists Using Table Features Creating a Table Formatting a Table Sorting a Table Filtering a Table Creating a Slicer Working with the Total Row Creating a Calculated Column Working with Data Importing Data from a Text File Exporting Data Converting Text to Columns Using Flash Fill Using Text Functions Connecting to Data in an Access Database Creating a Web Query Importing Web Data using a Saved Query Working with Hyperlinks Creating and Working with PivotTables Understanding PivotTables Creating a PivotTable using Worksheet Data Creating a PivotTable using an External Data Connection Laying out a PivotTable on a Worksheet Modifying PivotTable Fields Using a Report Filter Refreshing a PivotTable Formatting a PivotTable Using VLOOKUP to Add a Column to a List Enhancing PivotTables Working with Summary Functions Creating a Slicer Applying Filters Grouping Data Using a Timeline Creating a Calculated Field Creating a Calculated Item Creating a PivotChart
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323