Excel Database Features and PivotTables

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 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 Using Lists Using Auto Fill to Enter Data Using AutoComplete Creating and Using Absolute Named Ranges Working with Data Validation 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/CSV File Exporting Data Removing Duplicates Converting Text to Columns Using Flash Fill Using Text Functions Connecting to Data in an Access Database Using the Power Query Editor Creating a Web 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 Applying Filters Creating a Slicer Using a Timeline Grouping Data Creating a Calculated Field Creating a Calculated Item Creating a PivotChart Analyzing Data Using Automatic Outlining Inserting Subtotals Creating an Advanced Filter Using Database Functions Using the Quick Analysis Tool