Guides for Sheety work
Tips & tricks? Who needs tips and tricks? You just want your sheet to do something it isn't doing now. These aren't just hot tips. They're the long guides I write when a problem is too annoying to just say "here's a quick fix."
Free tutorials on YouTube
Step-by-step videos on Google Sheets. All free at youtube.com/bettersheets.
Watch on YouTube
Latest posts
5 More Fixes For Your Spreadsheets
Hi, Andrew Kamphey here with Better Sheets, dedicated to helping you improve your Google Sheets every single day. Last time, I shared five ways to fix your sheets. So now, I've got five more tips to make your sheets even better. Let's dive right in! Change the Background Color Let's start by talking about color. While changing the font color is important, altering the background color can make a significant difference too, just follow these steps: 1. Select the entire background. 2. Hit...
Discover Misspelled Duplicates
The built-in feature can sometimes miss duplicates that have subtle differences, such as variations in spacing or formatting. Our formula-based approach, on the other hand, provides a more granular level of control
Easiest Mistakes to Make In Spreadsheets
When you start mixing unrelated data in the same rows or columns, it becomes harder to follow what’s going on.
Name Match: Who's In and Who's Out
Let's say you have a master list with over 700 names and a new list from a recent meeting containing 175 names. How will you identify which names from the new list aren't on the master list so they can be added.
Sensational Spreadsheet Styling
Not only do they need to be accurate and efficient, but they should also look beautiful and eye-catching.
9 Google Sheet Tips for Affiliate Marketers
Learn how to apply formulas and calculations within Google Sheets in order to develop a tracking system for the effectiveness of your campaigns.
5 Google Sheet Tips for Admin Assistants
As an admin assistant, you could use this Google Sheets tutorial to get better at managing the frequent data manipulation tasks your job requires.
Privacy Policy
Effective Date: January 1, 2024 Commitment Welcome to Better Sheets. We are committed to protecting your personal information and your right to privacy. If you have any questions or concerns about this privacy notice, or our practices with regards to your personal information, please contact us at [email protected]. Information We Collect We collect personal information that you voluntarily provide to us when you register on the website, express an interest in obtaining informati...
Formulas Frustrating? It's Not The formula's fault.
When I first started using Google Sheets, I was full of excitement. I believed that every formula would work perfectly, that each one would fit my needs effortlessly, and that Google Sheets would be the ultimate solution to all my problems. But after years of using formulas that sometimes broke, returned errors, or just didn’t quite fit the task at hand, I began to wonder if I was doing something wrong. Was it the formulas’ fault? Or was it, perhaps, me? Why do we often find ourselves frus...
19 Google Sheet Tips for Administrative Assistants
Get better at google sheets to make your job easier.
Why Should I Code in Google Sheets?
Automate repetitive tasks, such as data entry, calculations, and formatting in Google Sheets.
4 Ways to Resize Columns, Change the Column Width in a Google Sheet
Adjusting column width is crucial for enhancing the readability and functionality of spreadsheets. Properly sized columns ensure that all data is visible without unnecessary scrolling or cutting off information, which can lead to errors or misinterpretations.