Excel Spreadsheets: Navigation, shortcut keys, data sort and filter, formulas and functions
from PC world 03 October indexed on 03 October 2017 16:01Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We're creating this guide to make sure you master all the essentials and more. We'll add to this guide over time, so bookmark it and come back to keep learning. We start with the basics: How Excel spreadsheets workUsing Excel's Help menusExcel's navigation and shortcut keysUnderstanding data filters and data sortsExcel formulas and functions: Our best tips How Excel spreadsheets work: The basics Think of an Excel spreadsheet as an electronic flat-file database modeled after a bookkeeper's ledger. Excel's “spreadsheet” is like the ledger's page, and Excel's “workbook” grouping of spreadsheets is akin to an entire ledger. The best use of a spreadsheet is to provide users with groups of records that are available on one screen for easier management. To read this article in full or to leave a comment, please click here
Read more.
