5 simple, useful Google Sheets formulas everyone should know

One easy way to manage your money better is by laying everything out in a spreadsheet. You may think only businesses need them, but everyone needs to keep track of their finances. A spreadsheet is helpful because it provides a bird’s eye view of your financial situation.

You don’t necessarily have to buy financial software, either. You can use Google Sheets, a free online spreadsheet editor that works just like Microsoft Excel. You get 15GB of free storage, so you have room for a lot of financial spreadsheets.

You may be able to use it for years before updating to a paid financial software like our sponsor, Oracle Netsuite. More on that option later. Here are a few easy formulas to make the most out of Google Sheets.

First things first

You probably know that the little boxes in a Google Sheets spreadsheet are called cells. You may not know that each cell is a mini calculator. For example, you can type in an equation within a cell like this:

To find the solution, type = ahead of the equation, like so:

As you can see, the answer pops up. Pretty nifty, huh? This formula feature will be handy once you start inputting numbers into a spreadsheet.

Don’t think that Google Sheets is a simple calculator, though. It has a ton of impressive features. You can create your own equations with numbers in different cells. You can add two numbers in different columns or subtract two numbers in different rows.

For example, you can type A4+B4+C4 to add the numbers in those specific cells together. The cool thing about cell referencing is that you can change the values of the cells in the formula and the formula will update itself.

You can also merge cells, create thick black borders between cells, wrap text and much more. We found a comprehensive beginner’s guide if you want more general knowledge about what Google Sheets can do. Tap or click here to set yourself up for success with Google Sheets.

Continue reading

Package theft up 47% in December - Protect your gifts!

If you’ve ever ordered a package from an online store, there’s a chance someone snatched your goodies. Last month, porch pirates stole 47% more packages than they did in November 2021, RetailDive reports. You’re especially at risk if you order clothes, books, toys, games, groceries or health products.

Continue reading

3 QR hacks you must try today!

Upgrade your life with these three clever QR code hacks! Create a business card with a QR code, share your Wi-Fi password with ease, and surprise your friends with a scannable music present. Quick, easy, and practical. All you need is a smartphone or computer and these helpful tips.

Get the iPhone 14 for free

Open/download audio

Want to get the best iPhone 14 features — without buying the new model? Listen to this one-minute podcast for an insider tech tip you can use to upgrade and save cash.

5 small biz freebies to save you some cash, from shipping materials to logos

Owning or working for a small business is full of joys: Seeing your business take off, working closely with a small team and watching your ideas flourish.

It’s not all a walk in the park, though. Small teams, limited budgets and not enough time in the day can make things challenging.

Continue reading

Smart home tech is on sale! 15 gadgets for you or anyone on your list

Take advantage of this year’s holiday sales and upgrade your home. Smart gadget prices are dropping, so why not invest in your house?

Start with something simple and easy to handle, like smart bulbs. Or upgrade your older tech by purchasing a smart thermostat.

Continue reading

These anti-snoop screen protectors keep what you're doing private

Your Samsung phone can do many amazing things, but it can’t protect your privacy from prying eyes. Until now. These privacy screen filters don’t interrupt how you look at your phone but keep unwanted eyes from reading over your shoulder and finding out personally identifying information. Here are the best options available.

Continue reading

Best wrist rests to help with carpal tunnel and hand cramping at your PC

Many of us collapse our wrists between different blocks of typing and lean them against the corner of our desks. That’s not good for your tendons. Wrist rests help prevent additional damage and reduce fatigue during long work days.

Continue reading

Secret best browser for your phone

Open/download audio

Do you use the browser that came baked into your phone? Here’s why you should upgrade, in 60 seconds.

Best surge protectors and outlet extenders to give you more places to plug in

Most of us have thousands of dollars in expensive computers, phones, tablets, and other personal electronics. All it takes is one surge to ruin all of that. Tap or click to keep your electronics clean and organized.

You could be at work when a storm begins, lightning strikes a transformer, and a surge hits your corner of the power grid. A surge protector is the only way to know that your electronics are safe.

Continue reading

Best timekeeping, accounting and money-management software

Time is money, and every minute counts. Detailed time tracking and bookkeeping can seem like a hassle if you’re running things independently.

If a skeleton crew operates your business or you’re managing everything on your own, that means relying on the right tech to get the job done. Don’t waste your time and money on software that doesn’t work for your needs.

Continue reading

Turn your smart speakers into an intercom system

Open/download audio

Remember when only expensive homes had an intercom in every room? In 60 seconds, I’ll break down how you can upgrade your home with just $20.

Kitchen appliances won't be this cheap again until next Prime Day

Your kitchen is missing a few things, but the usual prices drive you up a wall. It’s Prime Day to the rescue! These kitchen appliances will improve how you eat, preserve food and improve your nutrition. It’s time to upgrade an essential room in your house where you spend family time and make it a more enjoyable place to be with these deals.

Continue reading

15 best-selling products you can get on Amazon right now

Amazon is famous for having what you want at an affordable price. That means you can replace old devices, invest in new tech or upgrade your home without breaking the bank.

You can get some great deals with your Amazon account, and if you are a Prime Member, you can benefit from faster shipping. Tap or click for 15 great products to help tackle your home improvement projects.

Continue reading

How to save $ on iPhone or Galaxy

Open/download audio

Want to upgrade your phone but can’t afford to spend over $1,000? Listen to this one-minute podcast for a few ways to get a great phone for less.

5 of the best new TVs you can get for under $500

Did you know you can replace your old TV with a brand new television for less than $500? It’s true. And these more contemporary models don’t just give you basic satellite channels. They connect you with the wonderful world of streaming.

Continue reading

Best ways to use smart plugs

Open/download audio

Want to upgrade your smart home? Listen to this one-minute podcast for a few reasons why I can’t recommend smart plugs enough.

Upgrade your home office with one of these 5 great monitors

Between work, school, hobbies and other responsibilities, you probably use your computer several hours each day. When you spend so much time with one piece of technology, it makes sense to upgrade now and then.

One of the best home office upgrades you can invest in is a new computer monitor. Tap or click for specs that matter when buying a new computer.

Continue reading

Need a new TV? 3 big options to watch the big game

Are you hosting a big game party this year? You’d better make sure you’ve got all the necessities.

Your friends and family will be looking for good food and good seats in front of a big screen. Don’t have one? Now is the time to buy your next TV.

Continue reading

Need a new keyboard and mouse? Best options available

It’s time to buy a new keyboard and mouse, but with so many on the market, which ones are right for you?

Do you need a mousse that’s compatible with an Apple device? Are you interested in the classic sound of a mechanical keyboard? What about colorful backlights and ergonomic designs?

Continue reading