Data
From access: Import data from a Microsoft access database.
From web: Import data from a web page.
From text: Import data from a text file.
From other
sources: Import data from other data
sources.
Existing
commotions: Connect to an external
data source by selecting from a list of commonly used sources.
Refresh all: Update all the information in the work book that is
coming from a data source.
Connections: Display all data commotions from the workbook.
Sort A to Z: Sort the selection so that the lowest values are sort
by top to bottom alphabetically A to Z.
Sort Z to A: Sort the selection so that the lowest values are sort
by top to bottom alphabetically Z to A.
Filter: Enable filtering of the selected cells.
Clear: Clear the filter and sort stat for the current range
of data.
Reapply: Reapply the filter and sort in the current range.
Advanced: Specify complex criteria to limit which records are included
in the result set of a query.
Text to
columns: For example you can separate
a column of full name into separate first and last name columns.
Remove
Duplicates: Delete Duplicate Rous
from a sheet.
Data
validation: Prevent invalid data from
being entered in to a cell.
Consolidate: Combine Values from multiple range into one new
range.
What-if
Analysis: Try out various values for
the formulas in the sheet.
Group: Tic a rage of cells together so that they can be
collapsed or expanded.
Ungroup: Ungroup a range of cells that were previously grouped.
Subtotal: Total several rows of related data to gather by
automatically inserting subtotal and totals for the selected cells.
