Advertising
Advertising

10 Google Spreadsheet Tricks & Tips You Probably Didn’t Know

10 Google Spreadsheet Tricks & Tips You Probably Didn’t Know

Google Docs has been the free alternative to Microsoft Office for the longest time now. This is due in part to how the Google document suite allows individuals to create Google word documents, presentations, and spreadsheets for free and all on the web. However, there are still individuals looking for more ways to extend the power of Google Docs, and more notably Google Sheets, in their every day business and personal tasks. Today, we will take a look at ten Google Spreadsheet tricks and tips that will get you creating spreadsheet docs that will blow everyone by surprise.

1. The Power of the =IMAGE Function

docs_01

    It is of course a known fact that you are able to add images through a file upload in Google Sheets. However, a faster way to add images to your Google Sheets is through a formula of =image(“url”). In the parenthesis, put the link of the image from online in quotation marks. It’s a fairly easy formula to make use of and it can possibly save you a ton of upload time in the process.

    2. Make Use of Templates

    docs_02

      You can make use of a ton of templates in Microsoft Office, and the same is true for Google Sheets. There are a ton for you to make use of and they are a great way for you to get a jump start in what ever form of word processing you are doing in Google Docs and specifically in Google Sheets. All you have to do in Google Docs is click “Create New”, from there select “From Template” and browse away.

      Advertising

      3. From the Cloud, to Hard Drive

      docs_03

        Keeping documents in the cloud can be great for accessing your documents on the go. However, it isn’t always best when you are trying to access them while offline. Maybe you want to have a file form of your Google Docs work, if so, this is the tip for you. In Google Docs, select by checking off the documents you are looking to backup. Under “Actions”, select “Download” and in a .zip file, your files are ready to go. It is important to note that you have a 2GB limit.

        4. List All Keyboard Shortcuts

        docs_04

          Keyboard shortcuts are the ultimate way to stay productive. However, what better way to find out all of the keyboard shortcuts at your disposal than by making use of a keyboard shortcut. Command + “forward slash” (Mac) or “Control” + “Forward Slash” (Windows) brings up the ultimate list of shortcuts that will allow you to get things done in a snap.

          5. Stay Focused in Full Screen

          Advertising

          docs_05

            It can be easy to find yourself distracted by the other things that are going on around you. When you find yourself in a focused environment however, you aren’t exactly out of distraction danger. You then encounter the distractions of your computer screen. Google Docs has a solution for that. Under the “View” tab, select “Full Screen” and you are off to an environment that will allow you to crank out an amazing spreadsheet in Google Sheets.

            6. Conditional Formatting

            docs_06

              Conditional formatting is a key feature in any spreadsheet program. This is no different in Google Sheets. Today, we will focus on making use of conditional formatting to colour the cells in your document. Just as conditional formatting is used to make large tasks approachable, making use of the colouring tools in conditional formatting allows you to see a large amount of data as more approachable for you to tackle.

              If you are doing inventory and want to visually see what items are below a set quantity, you can highlight the entire cell(s) you are looking to work with, click the arrow to the right of your column header and click “conditional formatting”. When open, you can set your parameters, choose the colours for each parameter, and then click “save rules”.

              7. Get Related Terms – Magically

              Advertising

              docs_07

                If you are like me, you may find yourself making use of mind maps a lot to stay creative and to even cure those tip-of-the-tongue moments. Google Sheets is also there to help you out in such situations as well. Using a Google Labs add-on known as Google Sets, simply type two related terms in your cell. From there, highlight the entire cell while clicking “option” on a Mac or “Ctrl” on Windows. Terms begin to “magically” appear.

                8. Accessing More Currencies

                docs_08

                  If you are working in finance or simply need to make a spreadsheet involving some money, this is the tip for you. If you need to access currency other than the US Dollar, simply highlight the cells, click the “123” button in the toolbar, and scroll to “More Currencies”. Click the currency you want and you’re done. Google Docs just became a bit more travelled!

                  9. Insert Google Sheets into Docs

                  docs_09

                    If you are an avid Google Docs user, you will find that your word documents will need to be placed in Google Sheets and vice versa. Doing this, however, is much easier and seamless than you think. With Charts, in the Google Chrome store, you are able to insert Google Sheets charts in Google Docs by opening the add-on “Charts” in your add-on menu, click “Load Data”, select, drag what data you’ll be using, and select “Insert”.

                    Advertising

                    10. Gathering Data Easier

                    docs_10

                      If you are performing a project or need to make use of a survey to then gather information from for you spreadsheet, Google Forms its what you need. Easily sharable and even with the ability to be embedded on your website by going to “Forms” then “Create a Form”. From there, you can have individuals fill out their respective responses. Once your trials have ended, your data is added to the top of the spreadsheet for you to make use of.

                      I hope that you are able to take the tips and tricks learned today and make some fantastic Google spreadsheets. Let us know in the comments below which trick you’ll make use of the most.

                      Featured photo credit: Xcluesiv via xcluesiv.com

                      More by this author

                      10 Meal Planning Apps You Need To Have To Get Healthier Easily The 50 Best Desktop Wallpapers for 2013 23 Awesome Travel Hacks That Add Fun To Your Trip How to Stay in Good Shape During Black Friday 9 Apps Unrelated to Black Friday That Are Helpful

                      Trending in Technology

                      1 10 Best Power Banks to Top up Your Phone at Will on the Go 2 35 Top Productivity Apps for iPhone (2020 Updated) 3 18 Best Time Management Apps and Tools (2020 Updated) 4 19 Best Mac Apps for Productivity You Need in 2020 5 19 Best To-Do List Apps to Keep You on Track in 2020

                      Read Next

                      Advertising
                      Advertising
                      Advertising

                      Published on August 6, 2020

                      10 Best Power Banks to Top up Your Phone at Will on the Go

                      10 Best Power Banks to Top up Your Phone at Will on the Go

                      The alert beep for low battery serves as a death call when you’re running late for work or are out on the town and need to make a call. Luckily, a super convenient alternative to your regular charger and charging wires is available in the form of power banks[1]. Easy to carry, lightweight, and affordable power banks have become the perfect companion for every mobile phone. In order to assist you in making the right choice for the purchase of power banks, we have compiled a list of the best power banks to guide you.

                      Why Trust Us

                      The importance of a well-charged phone cannot be underestimated. Keeping this in mind, our team has gone through many reviews and product descriptions present on the most reliable tech websites. From the smallest and lightest portable chargers to those that come with several years of warranty, our featured power banks will not let you down and will be worthy of your investment.

                      1. Anker PowerCore 10000mAh Portable Charger

                        As the best power bank the market offers, Anker PowerCore has a battery of 10000 mAh, which can charge three and a half iPhone 8 or two and a half galaxy s8 charges. The power bank has PowerIQ and voltage boost technologies, which can charge your phone in no time. Large size-to-capacity makes it a convenient item to carry in your pocket.

                        To ensure the protection of your device, this power bank from Anker comes with a multi-protect safety system. The box also includes a portables charger and micro USB cable. You can carry it around safely with the included travel pouch. An 18-month warranty and friendly customer service are also included to give you a perfect power bank experience.

                        Pros

                        • Large size-to-capacity ratio
                        • High-speed, universal charging
                        • Red, blue, black color options
                        • One of the smallest and lightest portable chargers on the market

                        Cons

                        • Qualcomm quick charge is not supported
                        • The battery may not work well after some time

                        Get this power bank here!

                        2. INIU 20000mAh Power Bank

                          Made of top-quality materials, the INIU Power Bank charges your phone 1.4 times faster with UPower+ technology. It works smartly by identifying your device and simultaneously increasing the current output. What’s great is that you can charge two devices at the same time. INUI recognizes its place as the thinnest lightweight power bank on the market.

                          The paw indicator on the power bank illuminates its remarkable design, and it includes a flashlight inside, which can be used in emergency conditions. You can charge the power bank quickly with a micro USB or a type-C cable. Consequently, it’ll save you the hassle of finding the specific cable for a charge. INUE comes with a three-year warranty to give you peace of mind.

                          Pros

                          • Thin and lush design
                          • Dual 3A output
                          • Flashlight included
                          • U Power+ technology

                          Cons

                          Advertising

                          • It doesn’t come with a pouch
                          • Standby time is less than six months

                          Get this power bank here!

                          3. Miady 2-Pack 10000mAh Dual USB Portable Charger

                            An all-in-one power bank solution for your needs, Miady includes two 10000 mAh battery packs. The power bank contains two USB output ports with an equal amount of current distribution. While one can charge 2.4 times for iPhone X, 3.6 for iPhone 8, and 2.2 for galaxy S9, you won’t be needing a socket anytime soon.

                            You will be able to charge the power bank in 5 hours at 5V and 2A. Miady contains a reliable Lithium-polymer cell, and you can also carry the power bank on a plane. It can power off and on automatically if the device is disconnected for 30 seconds. This portable charger is compatible with 99 percent of smartphones and is one of the cheapest power banks available on the market.

                            Pros

                            • One of the best-value options compared to its rivals
                            • Efficiently distributes current output
                            • Vibrant color options like yellow and purple

                            Cons

                            • Not suitable for big devices like the iPad

                            Get this power bank here!

                            4. Anker PowerCore 20100mAh Portable Charger

                              Anker 20100 mAh Power Core offers a huge amount of battery capacity. As one of the best power banks on the market, the 20000 mAh battery capacity can charge an iPhone 8 almost eight times or an S8 five times. In addition, the power bank can hold a charge for up to seven days, so you don’t have to plug it into the wall again and again.

                              You can use the voltage boost and power IQ recharge to charge a phone efficiently and quickly. The power bank is also pocket-friendly and certified safe as it ensures protection for your smartphone or tablet and you. Its dual-device output enables you to charge up to two devices at the same time. Anker is made out of premium material to give you the best durable power bank on the market.

                              Pros

                              • High-speed charging
                              • Huge 20000 mAh capacity
                              • Enormous 4.8-ampere output
                              • Certified safe

                              Cons

                              • It may start charging slowly after a few months of use
                              • Qualcomm quick charge is not supported

                              Get this power bank here!

                              Advertising

                              5. Anker PowerCore 13000mAhPortable Charger

                                Another Anker, the Anker PowerCore 13000 Portable Charger offers a huge battery capacity in a sleek design and has the ability to charge an iPhone 8 up to 5 times and an iPhone X or an S9 three times. You can also charge your phone or tablet with the two high-speed ports that are included. Anker comes is a smaller size than that of a wallet and is one of the best lightweight power banks compared to its battery size.

                                Anker is 30 percent lighter than most other power banks. Power IQ and voltage boost technologies are included for fast-charge devices. Power IQ also identifies devices to calibrate the charge to your phone.  Anker has surge protection technology and short circuit prevention. You can rest assured that it will take care of you and your devices. Plus, you are covered with an eighteen-month warranty.

                                Pros

                                • Power IQ technology
                                • Super high capacity
                                • Red, black, blue, white color options

                                Cons

                                • No Qualcomm quick charge
                                • Wall charger is not included

                                Get this power bank here!

                                6. GETIHU 10000mAh Portable Charger

                                  GETIHU offers high-quality power banks with their 11 years of experience in the market. The GEITHU portable charger has a certified Lithium-ion battery, which gets it the approval for airline travel. With the help of an LED display, one can know how much battery is left. You can quickly charge up to two devices with 4.8 Amperes at the same time.

                                  High-speed charging is accompanied by a smart IC to auto fit your smartphones. It can work with both big and small Android devices. GEITHU can easily fit inside your bag as it is slim and portable. Choose to take it with you with the travel pouch and feel comfortable taking it everywhere as it has a three-year warranty.

                                  Pros

                                  • LED display with the battery percentage
                                  • The 4.8-ampere charges two devices simultaneously

                                  Cons

                                  • The LED display may not show the correct amount of charge left

                                  Get this power bank here!

                                  7. Anker PowerCore 26800mAh Portable Charger

                                  Advertising

                                    Anker PowerCore offers a massive battery, which makes it one of the best power banks on the market. The 26800mAh worth of charge can charge phones more than six times. It has three USB outputs so that you can charge three devices at the same time. Power IQ and voltage boost make the high-speed charging available for all three devices.

                                    You can charge the whole power bank in 6 hours. The two micro-USB inputs double the recharging speeds. It is light and durable, which makes it the best companion for your travel needs. The multi-protect safety system protects you and your devices. Friendly customer services and an 18-month warranty are there to provide you with the peace of mind you need when you get the Anker PowerCore.

                                    Pros

                                    • Triple device charging
                                    • Dual-input power bank charging
                                    • Superior safety
                                    • A week’s worth of power

                                    Cons

                                    • Performance may decrease over time
                                    • A bit heavy due to the big battery

                                    Get this power bank here!

                                    8. RAVPower 16750mAh Power Bank

                                      RAVPower offers a vast battery of up to 16750mAh in size. It can charge your iPhone 11 two and a half times, S10 for 3.3 times, or an iPad for a full charge. With a current output of 4.5 amperes, it can charge up to two smartphones at the same time. You can quickly charge the power bank with a two-ampere charger in about 9 to 10 hours.

                                      The flashlight is included in the power bank for emergency use. RAV is also tested against high temperature. Its iSmart technology tests your device for the optimal current value needed. Premium batteries comprised of lithium-ion can charge a device more than 500 times.

                                      Pros

                                      • Impressive 16750mAh battery
                                      • iSmart technology

                                         Cons

                                      • It does not hold a charge well over time

                                      Get this power bank here!

                                      9. RAVPower 15000mAh Power Bank

                                         

                                        Advertising

                                        RAV power bank features a controlling IC and iSmart technology. These come together to offer a fast charge for your smartphone or tablet. You can take your iPhone 11 from 0 to 50 percent in just 30 minutes. iSmart 2.0 can adjust according to your charging device and offers the necessary current. It’s possible to charge up to three devices at the same time with three outputs.

                                        The portable charger can be charged within 4.7 hours with the ultra-fast charging, thus saving you 40 percent recharging time. RAV can fit comfortably in your pocket or your hand. An LED digital display shows you exactly how much charge is left inside. High-end lithium-ion batteries, along with protection technology, give you peace of mind wherever you take this power bank.

                                        Pros

                                        • 30W total tri-output and fast recharge
                                        • Led digital display

                                        Cons

                                        • Weighs a bit more than most power banks

                                        Get this power bank here!

                                        10. LANLUK 25800mAh Power Bank

                                          The LANLUK 25800 mAh portable power bank can charge your phone 5 to 7 times, and it is perfect for any type of work that you are heading out for. You can charge up to two devices simultaneously with the help of two outputs.

                                          The high-quality lithium A+ polymer battery is used to give you peace of mind as the power bank protects itself from overheating and overcharging. The portable charger is compatible with nearly all the phones and tablets. 18-month customer service is available to give you even more peace of mind. It is an all-in-one power bank solution for your needs.

                                          Pros

                                          • High capacity battery
                                          • Highly compatible

                                          Cons

                                          • Not permissible on planes

                                          Get this power bank here!

                                          Bottom Line

                                          Choosing the best power bank is a bit hard task as there are many types of power banks available in the market. The one that you’d like to choose must depend on your needs. If you will go out for a long hike or a long trip with no power socket input, then the one with a bigger battery will be useful. However, if you need a solution to charge your phone while in the office, then something with a lightweight and durable design will be a better choice for you.

                                          Choose one of the best power banks from above and never worry about your device dying again.

                                          Featured photo credit: Steve Johnson via unsplash.com

                                          Reference

                                          Read Next