Technology doesn’t always make our lives easier, so when it saves you a full day of work, that is blog-worthy. The Power Tools Add-on for Google Sheets had me doing cartwheels around the office.
We used Power Tools to prepare some Sheets for our billing office. In years past, we have suffered through hours and sometimes days of tedious formatting in Sheets. Back then, I took the time to learn a few formulas that helped speed things up, but nothing made the process feel easy. Until Power Tools for Google Sheets.
We used Power Tools for Google Sheets to:
- Compile multiple rows into 1
- Merge data from multiple columns
- Remove duplicate rows
- Add spaces
- Insert characters by location
- Change text formatting
- Convert text to number formats
- Clean up data that was imported
While this was possible in Excel, the features weren’t as simple and accessible as they are in Power Tools. Plus, we never lost the real-time collaboration and consistent revision history that we rely on. What once took a day or more, we finished in an hour. Power Tools & Google Sheets for the win!
Technology is amazing and when it runs this smoothly, it feels like magic.
Casey Daigle
Casey is the Digital Learning Manager for the Collaborative for Educational Services (CES), where she works with preK-12 teachers, administrators, and edtech leaders across Massachusetts to explore how tech can transform teaching & learning, better connect us as humans, and create more equity and inclusion. She is a Google for Education Certified Trainer and spends a lot of time engaging educators about makerspaces, personalized learning, and what learning feels like when it happens online. Her personalized approach to professional development supports learners to explore possibilities and build confidence as they discover how G Suite tools and a little imagination can revolutionize their work. Additionally, she has worked extensively with design thinking, systems design, facilitation and she is certified by ISTE to be an authorized provider of the ISTE Certification for Educators.