
Count cells in a range OR count based on certain criteria. The VLOOKUP function allows you to cross-reference information across multiple sheets and answer questions like “Who in our outreach tracker registered for the event?,” or “If X person from our outreach list registered for the event, what did they submit as their job title?” Learn more here. If you could only master one function – this is the one to master. Cross-reference information across multiple sheets. You can also use formulas such as =SUM(A1:A10) for arithmetic in a given range. Use the correct order of operations when formatting your equations. Simply enter “=” in the cell and then input or click the cells to build your equation. You can use Sheets for lots of simple (or complicated) math. From there you can do things like (1) sort alphabetically (2) display select information (3) hide blank cells (4) display only cells that meet certain criteria. Select the row or cells where you would like to add a filter and click the Filter button in the menu bar. Filters make navigation, organizing and sorting a breeze. and District of Columbia), this will make sorting and filtering your data a challenge.Ģ. For example, if your data uses a combination of TRUE, YES and Y (or DC, Washington D.C. Being consistent with how you format text is crucial to being able to accurately use the skills below and more sophisticated formulas. Think you’re not a formula person? Hear us out.ġ. Here are the Top 10 Skills that you need to know to automate, formulate, and format your way to more effective spreadsheets. There are lots of ways to make a spreadsheet with hundreds (or thousands) of rows completely manageable so that you can easily and quickly draw insights.

We’ve also got our Top 10 Rapid-fire Formatting Tips you’ll use over and over again.Īnd if you’re using Excel, don’t worry, these tips still apply! Top 10 Google Sheets Skills This guide will arm you with our Top 10 Skills to make organizing, navigating, and using functions and formulas in Sheets easy.

Use Google Sheets for easy solutions to any of these tasks. Nearly all professions require some spreadsheet and data literacy to make tracking projects more efficient, managing datasets less overwhelming, drawing insights a breeze, and presenting information more intuitive.

You don’t need advanced data science skills to make the most out of Google Sheets.
