Your Cart Is Empty
Desktop Applications >
Excel Database Features and PivotTables
Learn the essentials regarding managing data and creating PivotTables in Excel.
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.
Upon successful completion of the Excel Database Features and PivotTables Training course, you will be able to:· Using Lists· Using Table Features· Working with Data· Creating and Working with PivotTables· Enhancing PivotTables
Using ListsUsing Auto Fill to Enter DataUsing AutoCompleteCreating and Using Absolute Named RangesWorking with Data ValidationInserting and Deleting Columns or RowsFreezing and Unfreezing PanesSplitting a Worksheet WindowUsing Functions with ListsUsing Table FeaturesCreating a TableFormatting a TableSorting a TableFiltering a TableCreating a SlicerWorking with the Total RowCreating a Calculated ColumnWorking with DataImporting Data from a Text FileExporting DataConverting Text to ColumnsUsing Flash FillUsing Text FunctionsConnecting to Data in an Access DatabaseCreating a Web QueryImporting Web Data using a Saved QueryWorking with Hyperlinks
Creating and Working with PivotTablesUnderstanding PivotTablesCreating a PivotTable using Worksheet DataCreating a PivotTable using an External Data ConnectionLaying out a PivotTable on a WorksheetModifying PivotTable FieldsUsing a Report FilterRefreshing a PivotTableFormatting a PivotTableUsing VLOOKUP to Add a Column to a ListEnhancing PivotTablesWorking with Summary FunctionsCreating a SlicerApplying FiltersGrouping DataUsing a TimelineCreating a Calculated FieldCreating a Calculated ItemCreating a PivotChart
Microsoft Office Specialist (MOS) Certification - Excel AssociateMicrosoft Office Specialist (MOS) Certification - Excel Expert
Excel Introduction or equivalent skills.
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
Productivity Point Headquarters
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323