Clearing Filtering, Showing/Hiding AutoFilter, Grouping and Subtotaling List Data. Advanced Filtering: Criteria for Advanced Filters, Using Advanced Filters, Selecting/Ordering Advanced Filter Columns. Sorting & Filtering a Table or List Range: Using a List Range, Basic Sorting, Complex Sorting, Filtering and Advanced Filtering, Filtering with AutoFilter. Laminated quick reference card on Microsoft Office Excel 2016 for Windows showing step-by-step instructions and shortcuts for how to use tables, PivotTables, sorting, filtering features as well as the Inquire Add-in. The following topics are covered:Įxcel Tables: Creating an Excel Table, Adding or Deleting a Table Row or Column, Turning On/Off the Total Row, Removing Duplicates, Converting a Table to a List Range, Using Table Specifiers in Formulas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |