Методические указания - Excel Advanced

37 p.
(Автор и выходные данные не указаны). Contents:
Formulas.
VLOOKUP.
Filters.
Ribbon Tour.
Quick Filtering.
Filtering by multiple criteria.
Saving Filtered Data.
Performing calculations on filtered data.
PivotTables.
Defined.
Basic PivotTable Data.
Inserting a PivotTable.
PivotTable Geography.
Building a PivotTable Report.
Adding row labels, adding column data, changing formulas in columns, changing headers & number formats.
Adding multiple row labels, collapsing and expanding, drill down to data, sorting, & refreshing.
Grouping by dates, grouping by ranges, show items with no detail, show values in empty cells, grouping across columns.
User defined groups, adding/removing subtotals.
Using formulas on pivoted data.
Displaying multiple row labels in tabular form.
Formatting as a table.