Course Description Do you spend a lot of time searching for data in large spreadsheets? Would you like to perform database functions such as filtering, subtotaling, and sorting directly in your Excel spreadsheet?
Attend this course if you want to:
Learn the differences between a list and a table. Learn the "rules" of designing an Excel list or table. Define a range of cells into a table. Freeze row or column titles so they don't disappear as you scroll. Use table styles to change the look of your table quickly and easily. Select data in tables. Use formulas in tables. Sort data alphabetically or numerically. Filter data to display a subset of the data. Remove duplicate records from a table. Set up data validation criteria to prevent data entry errors. Convert a table back to a normal cell range. Add one or more subtotals to a list.
