II Partial Computer

Converting text to columns

Converting text to columns

is very useful in Excel. For example, if you have a list with first and last names in a single cell, separating the names into separate cells will make the data easier to work with when searching, filtering or editing.

Conditional Formatting

is great for formatting a cell(s)—like, changing font or fill color—based on criteria or rules you set.

COUNTIF function

is great for counting an entry if it meets certain criteria

Removing Duplicates

Sometimes a large spreadsheet may have duplicate rows. This usually occurs when more than one person enters data into a shared worksheet

Sheet Protection

Password protect your worksheets so your work is

not modified by unauthorized persons.

Password protect

your worksheets so your work is not modified by unauthorized persons.

Excel table feature

converts a list of data into a formatted table

pivot table

is an interactive table that allows you to group and summarize large amounts of data in a concise table.

Data field

A field from the source worksheet that contains values to be summarized.

Report filter

Data fields in this area act as filters for the pivot table report.

Column labels

Data fields in this area determine the arrangement of data shown in the columns of the pivot table.

Row labels

Data fields in this area determine the arrangement of data shown in the rows of the pivot table.

Values

Data fields in this area determine which data are presented in the cells of the pivot table

Page field

A field from the source data that you assign to a page (or filter) orientation in a pivot table report.

Column field

A field from the source data that you assign to a column orientation in a pivot table report.

Item

A subcategory of a row, column, or page field.

Row field

A field from the source data that you assign to a row orientation in a pivot table report. For example, Region and Salesperson are row fields.

Data area

The cells in a pivot table report that contain summarized data.

Filters

can be used to narrow down the data in your worksheet, allowing you to view only the information you need

header row

In order for filtering to work correctly, your worksheet should include a

cumulative

Filters are , which means you can apply multiple filters to help narrow down your results.

Filter command on the Data tab.

To remove all filters from your worksheet, click the

Advanced date filters

can be used to view information from a certain time period, such as last year, next quarter, or between two dates

Advanced number filters

allow you to manipulate numbered data in different ways.

alphabetical and numerical

You can sort data in …. …. order

Filter your data

When you add a filter, anyone with access to your spreadsheet will see the filter too. Anyone with permission to edit your spreadsheet will be able to change the filter.

Filter by condition

Choose conditions or write your own.

Filter by values

To hide data points, uncheck the box next to the data point and click OK.

Search

Search for data points by typing in the search box.

Filter by color

Choose which text or fill color to filter by. You can filter by conditional formatting   colors, but not alternating colors.