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

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 2023 Collaborative for Educational Services · All Rights Reserved