Scientifically backed study method
Review terms and definitions
Study with MC, T/F, and other questions
Take a test on your terms and definitions
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.
is great for formatting a cell(s)—like, changing font or fill color—based on criteria or rules you set.
is great for counting an entry if it meets certain criteria
Sometimes a large spreadsheet may have duplicate rows. This usually occurs when more than one person enters data into a shared worksheet
Password protect your worksheets so your work is
not modified by unauthorized persons.
your worksheets so your work is not modified by unauthorized persons.
Excel table feature
converts a list of data into a formatted table
is an interactive table that allows you to group and summarize large amounts of data in a concise table.
A field from the source worksheet that contains values to be summarized.
Data fields in this area act as filters for the pivot table report.
Data fields in this area determine the arrangement of data shown in the columns of the pivot table.
Data fields in this area determine the arrangement of data shown in the rows of the pivot table.
Data fields in this area determine which data are presented in the cells of the pivot table
A field from the source data that you assign to a page (or filter) orientation in a pivot table report.
A field from the source data that you assign to a column orientation in a pivot table report.
A subcategory of a row, column, or page 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.
The cells in a pivot table report that contain summarized data.
can be used to narrow down the data in your worksheet, allowing you to view only the information you need
In order for filtering to work correctly, your worksheet should include a
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 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.