What is a Spreadsheet?
Important skills
Example: Sorting and filtering data in ExcelOnce you have selected the data that you want to sort or filter, you may click on the Sort & Filter button in Excel's Home ribbon. Image Source: Sort Data. Authored by: Shelli Carter. Provided by: Lumen Learning. License: CC BY: Attribution Sort orders
Example: Choosing what to filterAfter you turn on filtering for your data, you can click on the triangle button ( to choose what data to show and hide. When you're done, simply click "OK", and Excel will activate your filter. Image Source: Filter Data. Authored by: Shelli Carter. Provided by: Lumen Learning. License: CC BY: Attribution |
Cheatography
https://cheatography.com
Intermediate Spreadsheet Skills Cheat Sheet (DRAFT) by mdsis2049
Intermediate skills relating to spreadsheets, including sorting, filtering, formulas, and charts.
This is a draft cheat sheet. It is a work in progress and is not finished yet.