Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables.Target StudentThe course is for individuals who are responsible managing data and creating PivotTables in Excel.PrerequisitesExcel Introduction or equivalent skills.Course OutlineUsing 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 HyperlinksCreating 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
Overview
Taught by
ONLC Training Centers
