You are here

Excel 2016 Database Features and PivotTables Course

Excel 2016 Database Features and PivotTables Course


ONLC Training Centers
22 Cortlandt St
16th Fl
New York, NY 10007
Register for Course
Wednesday, August 15, 2018 -
10:00am to 4:45pm


Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment, it is best to register for this class at least three weeks in advance. Overview Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables. Target Student The course is for individuals who are responsible managing data and creating PivotTables in Excel. Prerequisites Excel 2013 or 2016 Introduction or equivalent skills. Course Outline Using Lists Using AutoFill Using AutoComplete Using Data Validation Inserting and Deleting Rows & Columns Freezing Panes Using Statistical Functions Using Table Features Creating a Table Formatting the Table Sorting a Table Filtering a Table Creating a Slicer Working with the Table Row Creating a Calculated Column Working with Data Importing Data from a Text File Exporting Data Converting Text to Columns Using Text Functions Using Flash Fill Connecting to Data in an Access Database Creating a Web Query Importing Web Data using a Saved Query Working with Hypertext Links Analyzing Data Using Automatic Outlining Grouping Data Inserting Subtotals Creating an Advanced Filter Using Database Functions Using the Quick Analysis Tool Creating and Working with PivotTables Understanding PivotTables Working with Recommended PivotTables Creating a PivotTable using Worksheet Data Creating a PivotTable using an External Data Connections Laying out a PivotTable on a Worksheet Modifying PivotTable Fields Using a Report Filter Refreshing a PivotTable Formatting a PivotTable Enhancing PivotTables Working with Summary Functions Sorting Items in a PivotTable Creating a Slicer Grouping Data Using a Timeline Applying Label and Value Filters Creating a Calculated Field Creating a Calculated Item Creating Charts from PivotTables

Register for Course

Additional Sessions