Log In
Or create an account -> 
Imperial Library
  • Home
  • About
  • News
  • Upload
  • Forum
  • Help
  • Login/SignUp

Index
Title Page Table of Contents Introduction Stories about change, stories in context: basic calculations Saving time to hit a deadline: repeating and fixing a calculation across cells How much did it cost? How many people were affected? The first function: adding a series of cells with SUM Who’s top, who’s bottom? MAX, MIN, and sorting Detour: getting to know the spreadsheet - useful shortcuts and tips to avoid mistakes Hitting the deadline: understanding and formatting the data - number or text Best sellers and averages: MEDIAN, AVERAGE and MODE How many payments? How many people? Counting, not adding up: COUNT Only count if… setting criteria for a formula: COUNTIF If… continued: setting criteria for a sum: SUMIF Putting the story into context, or looking from a fresh angle: merging data from different tables using VLOOKUP My data is dirty! Basic cleaning using TRIM, CLEAN and SUBSTITUTE Detour: generating consecutive numbers or dates Using more than one function at a time: nested functions Generating categories and other extra data: IF Detour: testing whether something is TRUE or FALSE Finding errors or missing data - and testing data types: ISERR, ISBLANK, ISTEXT and others Testing two things at once: AND, OR and NOT What day did that date fall on? Which year was the worst? Extracting days, months and years from full dates How old is someone? Ages and using TODAY’s date Grabbing or checking the first, middle or last part of a piece of information: RIGHT, LEFT and MID Case study: When you get data in sentences: using SEARCH and error handling to extract numbers from phrases Putting names, addresses and other data back together: CONCATENATE, & and adding special characters with CHAR More data cleaning: formatting text or numbers consistently with UPPER, LOWER, PROPER and FIXED Changing rows into columns, and vice versa: TRANSPOSE Repeating calculations across multiple cells or to create the ingredients of a single function: array formulae Grabbing data from elsewhere - IMPORT and GOOGLE functions in Google Sheets Dealing with data in another language: GOOGLETRANSLATE and DETECTLANGUAGE Converting currency or using stock prices: GOOGLEFINANCE Publishing live data in a live chart Comparing change visually by generating sparkline charts for every row: SPARKLINE Asking questions (or allowing users to), SQL-style: QUERY Adding some randomness: spreading out locations randomly using RAND Is this value ranked high or low? What value is 3rd? RANK, LARGE and SMALL What percentile is this at or above? PERCENTRANK and PERCENTILE Classifying data into top, middle and bottom quarters: QUARTILE Cross referencing and advanced cell references: naming cells and using INDIRECT, INDEX and MATCH Getting statistical: correlation with CORREL and other ways of testing data The final chapter: next steps
  • ← Prev
  • Back
  • Next →
  • ← Prev
  • Back
  • Next →

Chief Librarian: Las Zenow <zenow@riseup.net>
Fork the source code from gitlab.

This is a mirror of the Tor onion service:
http://kx5thpx2olielkihfyo4jgjqfb7zx7wxr3sd4xzt26ochei4m6f7tayd.onion