Practical data management, cleaning, and analysis

Data management is a daunting task for many nonprofits. With data existing in multiple systems being updated by multiple staff members and volunteers, it’s easy for things to get out of control and trust to fly out the window. The good news is that it’s completely possible to get things back on track and find peace and serenity when dealing with data.

This course will help you face data anxiety head-on with practical approaches that can be used by anyone with access to a spreadsheet. You will learn and practice how to:

  • Lead conversations about data management with your teams and your organization.
  • Create and maintain a visual aid for your data, systems, and processes.
  • Identify and address common data issues.
  • Clean your data using spreadsheets, with both manual and automated techniques.
  • Choose data quality metrics and display them in dashboard views.
  • Analyze data without statistical methods.

People of all skill levels with data and spreadsheets are welcome. You’ll work with real-life examples of nonprofit data in Google Sheets. That means you’ll learn and apply lots of spreadsheet skills for managing and working with the data. You’ll practice many data management functionalities, though the course will not dive too deep into any single spreadsheet function or formula.

Next course

Check back soon for course schedule updates.

Cost per course

Members $125/Non-members $250

Qualifying credits

NTEN professional certificate

Certified Fund Raising Executive

Certified Association Executive

Course overview

Data management

Lead conversations about data management and good data practices at your nonprofit.

Data quality

Use spreadsheet techniques and functions to clean your data.

Data analysis

Build spreadsheet tools to facilitate non-statistical data analysis.

Open quote marks
Close quote marks

Who doesn't hate dirty, confusing data? Get clean, actionable data by embracing our good friend, the spreadsheet. Spreadsheet skills are still some of the most valuable ways to manage nonprofit data. Come to this course to learn, use, and love your data!

- Instructor Emily Hicks-Rotella

Meet the presenter

Emily Hicks-Rotella

Emily Hicks-Rotella

Pronouns: They/Them

Nonprofit Data & Technology Strategist

Make Tech Work For You

Emily's vision statement: All mission-driven, social justice-oriented people and organizations will have the confidence and skills to learn, use and love data & technology as part of achieving their missions.Emily has over a decade of experience working with organizations of all shapes and sizes to support their data and technology culture and strategy. As part of this work, Emily supports staff members to learn, use, and love their data and technology, adds capacity to teams and organizations that need additional technical knowledge and skill, and uses a uniquely human and non-technical approach to develop and support a culture that sets up staff and organizations for success using data and technology for their missions and impact. Emily lives in the Bronx, New York with their wife and two young children, and when they aren't being a total data and tech nerd, they are either singing outside, snowboarding, skateboarding, reading, or getting more tattoos.

Looking for more ways to learn?

Take charge of your professional development with these other learning opportunities.

Nonprofit Tech Readiness

These six-month cohorts give you an opportunity to ramp up your technology leadership and planning skills.Learn about Nonprofit Tech Readiness

Professional certifications

Boost your career by earning a professional certificate that builds your skills and demonstrates your nonprofit tech know-how.Learn about certifications


If finances are tight, apply for a scholarship for an NTEN course or professional certification. Availability limited.Learn about scholarships

nten logo
P.O. Box 86308
Portland, OR 97286-0308
+1 503-272-8800

© 2024 NTEN