VOices Blog Members Home Events English | Français Shopping Cart
Skip to main content
VOices

Blog > Excel Functions to Simplify your Life

Excel Functions to Simplify your Life

posted on Apr 12, 2017
Excel%2bfunctions-350px.jpg

Excel is a very powerful tool which can help us do so many things with the data we’re inundated with, to make sense of it and use the data to make informed decisions. One of the ways Excel does all of this is through functions.

Excel has hundreds of functions. Probably no individual person on the planet uses all of them, but all of us will have use for some of them. Here are a few which are especially useful:

=COUNT()

Use this to find out how many numbers you have in a list or table. You could use this, for example, to find out how many people have paid for your event. This will only count numbers.

 2017_03_18_Excel_1.PNG

=COUNTA()

Use this to count how many cells have ANY value in them. This will count numbers and text. For example, you could count the number of names in your list, to find out how many people have registered for your event.

 2017_03_18_Excel_3.PNG

=

Sometimes you’ll want to have the same number appear in a few places in your spreadsheet. For example, you may want your registration and payment numbers together, to monitor progress towards your fundraising goal. Use the cell reference so that the number will update every time someone new registers or pays.

2017_03_18_Excel_4.PNG

Then you can calculate your progress towards your goal

2017_03_18_Excel_5.PNG

Agglutenating function: =<>&<>

This is useful for putting information together into one cell. For example, if you have people’s first names in one cell and last names in another, maybe you’d like to have their full names to create a participant sign-in for your event.

Note that in the example I inserted a space by including “ “. You can insert any character(s) you like but make sure you put quotation marks around them.

 2017_03_18_Excel_7.PNG

Volunteer Ottawa offers a comprehensive suite of courses related to organizational operations. Click here for more information, and to register. Subscribe to our Event RSS Feed to be among the first to know when a new workshop is added to the schedule.

Like what you've read? Subscribe to our RSS feed so you never miss a post! We have a general RSS Feed for all VOices blog posts, as well as an Operations RSS Feed which will focus on topics related to organizational operations.

Related Blog Posts

Filed under: Operations
new comment comment