Utilizing Spreadsheets to Power Your Work

Your mission is to build a better world. Ours is to help you succeed.501 Commons is a 501(c)(3) tax-deductible nonprofit charitable organization established in 1989.  We serve 2,000+ nonprofits each year as experts, innovators, and partners. Our passion is toamplify the strengths of nonprofits—so all people and communities flourish.

501 Commons

<A HREF="http://www.501commons.org" TARGET="_blank" TITLE="501 Commons" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer"><IMG ALT="501 Commons" SRC="https://cdn.evbuc.com/eventlogos/40654768/501commonswafirststopfornonprofitscrp.png"></IMG></A>
<A HREF="http://www.meetup.com/SeaTech4Good/" TARGET="_blank" TITLE="Seattle Tech4Good" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer"><IMG ALT="In partnership with Seattle Tech4Good" SRC="https://cdn.evbuc.com/eventlogos/40654768/st4gpartnership.jpeg"></IMG></A>
<H2 CLASS="MsoNormal">Having valuable information live in spreadsheets is common for many nonprofits. Do you ever look at this data and think "I know there is a better way to do this" or "Wouldn't it be helpful if I could calculate -insert brilliant idea-?"</H2>
This presentation will help you learn new spreadsheet skills to improve your data tracking, increase your productivity, and strengthen your ability to report valuable information to key stakeholders (funders, your board, committees, donors, policymakers, etc.). We'll highlight handy tips and tricks, discuss a holistic view to creating scalable workbooks (spreadsheets that are flexible toward incorporating more data), and review examples of using data to tell your organization's story.
By the end of this session, you will be able to:
<UL>
<LI CLASS="MsoNormal">
Use "advanced" formulas (e.g. SUMIF, INDEX-MATCH, X-LOOKUP, etc.) in Excel or Google Sheets
</LI>
<LI CLASS="MsoNormal">
Leverage Excel's features (e.g. pivot tables, named ranges, recording macros) to help you be more efficient
</LI>
<LI CLASS="MsoNormal">
Improve your data visualization skills to tell the story to stakeholders
</LI>
</UL>
This session is designed for individuals who have a basic understanding of spreadsheet tools (Excel, Google Sheets, etc.) and are looking to advance their abilities. If there are specific topics you'd like help with, please provide that information in your registration so we can ensure this training can be tailored to your needs.
<H2>Meet the Presenter</H2>
Olivia Brey is passionate about the power of data and the freedom that a range of spreadsheet skills affords – on an individual level to company-wide knowledge. She first learned Excel and VBA while getting her civil engineering degree from Colorado State University. She worked with the consultant firm Atkins for nearly five years advising state and local governments on emerging transportation technology, then moved to Seattle to work for Luum – a commute benefit management platform – as a data analytics lead. Olivia is now leveraging her analytical skills to support nonprofits.
<H2>Questions?</H2>
Do you have any questions about <A HREF="https://www.501commons.org/services/our-events-and-trainings/techtalk" TARGET="_blank" TITLE="501 Talks Tech" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">501 Talks Tech</A>? <A HREF="mailto:bryan@501commons.org?subject=501%20Talks%20Tech" TARGET="_blank" REL="nofollow noopener noreferrer">Contact 501 Commons</A>.
<H2>Additional Information</H2>
<A HREF="http://pactower.org/directions/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Driving Directions and Parking</A> information can be found on the <A HREF="http://pactower.org/about-pacific-tower/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Pacific Tower website</A>.
Want us to email you when we schedule future technology trainings, or keep up on other 501 Commons events, trainings, programs, discounts and grant opportunities? <A HREF="https://www.501commons.org/about-us/newsletter" TARGET="_blank" TITLE="501 Talks Tech Mailing List" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Join our mailing list</A> and bookmark <A HREF="http://www.501commons.org/resources/training-and-networking-events" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Featured Events</A> by 501 Commons and others.

Pacific Tower

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}