Formulas:
Function
library:
Insert
function: edit the formula in the current cell by choosing functions and
editing the argument.
Auto sum:
click her to display the result of a simple calculation such as average or
maximum value, after the selected cells.
Recently
used: browse and select from a list of recently used functions.
Financial:
browse and select from a list of financial functions.
Logical:
browse and select from a list of logical functions.
Text: browse and select from a list of text
functions.
Date and
time: browse and select from a list of date and time functions.
Lookup and
reference: browse and select from a list of lookup and reference function.
Maths and
trig: browse and select from a list of maths and trigonometry functions.
More
functions: browse and select from a list of statistical, engineering , cube and
information functions.
Data:
Get external
data:
From access:
import data from a Microsoft access database.
From web:
import data from a web.
From text:
import data from a text file.
From other
sources: import data from other data sources.
Existing
connections: connect to an external data sources by selecting from a list of
commonly used sources.
Connections:
Refresh all:
update all the information in the workbook that is coming from a data sources.
Connections:
display all data connections for the workbook.
Properties:
specify how cells connected to a source will update, what contents from the
source will be displayed and how changes in the number of rows and columns in
the data sources will be handled in the workbook.
Edit links:
view all of the other files this spreadsheet is linked to so that you can
update or remove the links.
Sort and
filters:
Sort: launch
the sort dialog box to sort data based on several criteria at once.
Sort A to Z:
sort the selection so that the lowest values are at the top of the column.
Sort Z to A:
sort the selection so that the highest values are at the top of the column.
Filter:
enable filtering of the selected cells.
Clear: clear
the filter and sort state for the current range of data.
Reapply:
reapply the filter and sort in the current page.
Advanced:
specify complex criteria to limit which record are included in the result set
of a query.
Data and
tools:
Text to
columns: separate the content of one excel cell into separate columns.
Remove
duplicate: delete duplicate rows from a sheet.
Data
validation: prevent invalid data from being entered into a cell.
Consolidate:
combine version from multiple range into one new range.
What if
analysis: try out various values for the formulas in the sheet.
Outline:
Group: tie a
range 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 together by automatically inserting subtotal
and total for the selected cells.
No comments:
Post a Comment