Nine things everyone should know how to do with a spreadsheet | Macworld

As I am starting to use spreadsheets to analyze demographic and related data, my basic knowledge of spreadsheets is being challenged. Another primer from Macworld (but applies to Excel and Google’s Sheets as well).

As I have been only using sum and average functions, these examples of other functions caught my eye:

=MAXRANGE and =MINRANGE: Return the largest and smallest values in a range. Related to these two, I also often use =RANKCELL,RANGE, which returns the rank of a given cell within the specified range.

=NOW: Inserts the current date and time, which is then updated each time the spreadsheet recalculates. In both Excel and Sheets, you need to add a set of parentheses: =NOW.

=TRIMCELL: If you work with text that you copy and paste from other sources, there’s a good chance you’ll find extra spaces at the beginning or end of some lines of text. The TRIM function removes all those leading and trailing spaces but leaves the spaces between words.

Nine things everyone should know how to do with a spreadsheet | Macworld.

About Andrew
Andrew blogs and tweets public policy issues, particularly the relationship between the political and bureaucratic levels, citizenship and multiculturalism. His latest book, Policy Arrogance or Innocent Bias, recounts his experience as a senior public servant in this area.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: