Technology in Education

  • Home
  • CES Blog
  • Technology at CES

Power Tools for Google Sheets

February 13, 2015 by Casey Daigle

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.

Hermoine Expecto Patronum

Casey Daigle

Avatar

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.

Filed Under: EdTech Review, GAFE, Google Apps, News, TiE Tagged With: AbleBits, Addons, Excel, Google, Google Sheets, Magic, PowerTools, tech tools, Timesaver

Like what you're reading? Share it.

Share this:

  • Facebook
  • Twitter
  • Email
  • Print
  • More
  • Tumblr
  • LinkedIn
  • Reddit
  • Pocket

Welcome to the Technology in Education Blog

Join the conversation about technology, teaching and learning.

Subscribe by Email


Follow us on Twitter

My Tweets

Categories

  • Assistive Tech (2)
  • Digital Citizenship (2)
    • Digital Literacy (1)
  • EdTech Review (6)
  • Events (2)
  • GAFE (5)
  • Google Apps (7)
  • In the Classroom (1)
  • Monthly Challenge (1)
  • Monthly Theme (1)
  • News (21)
  • Policy and Standards (1)
  • Product (2)
  • Social Media (1)
  • TiE (6)
  • Web (8)
    • Drupal (2)
    • Salesforce (2)

Archives

Quick Links

Technology Services at CES

Search Technology Professional Development Workshops

Follow me on Twitter

My Tweets

Copyright 2022 Collaborative for Educational Services · All Rights Reserved

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.