You may have heard the old adage, “Video games will rot your brain.” While this may be true if you are continuously playing a mindless mobile game, it turns out scientists believe some aspects of video games can actually help us become more social and better problem solvers — and even help positively develop a child’s mind. But how?
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.
Now let’s move on to the helpful formulas
So you opened up a spreadsheet. Maybe you’re using a template to start on the right foot. Tap or click here for 10 free spreadsheet templates to help manage your finances.
Use this site to check your network for unauthorized devices
© Suwan Wanawattanawong | Dreamstime.com
You keep your device’s operating systems updated. You’re using internet security software. You’re pretty savvy about not falling for online scams.
Even so, malware and cybercriminals can still get through. Run this free check to see if your router has been hacked by criminals.
12 smart products to help you kick your bad habits in 2023
Amazon
A new year always brings a fresh start, and we can all use that after the last couple we’ve lived through. But things are looking up finally, and it’s time to start enjoying life again.
The stressful times we’ve gone through might have left you with a few new not-so-great habits you want to kick. Don’t worry. We can help.
Where to put your router for better speeds
If you sink a ton of money into a high-performing router, you probably expect it to function perfectly. Though, just buying a good router isn’t enough. You need to put it in the ideal spot to maximize efficiency.
Regarding routers, it’s all about location, location, location. By that, we mean you need to think about anything that could obstruct its signals.
Genius way to get back at package thieves
Every year, one YouTuber takes it upon himself to fight back against porch pirates. He creates an incredibly complex device disguised as an actual package that not only sprays the would-be criminal with super-fine glitter but also invades their space with a ton of foul-smelling spray. This year he took it one step further.
Bake your state's most popular Christmas cookies
Google Trends data revealed that sugar cookies and peanut butter thumbprint cookies were some of the most popular American cookies in 2022.
How long should you keep records for your business, freelance job or side hustles?
So you decided to be on top of your paperwork and organize your business records. That’s a great start for small business owners, freelance workers and anyone with a side hustle. Over time, though, all those records can pile up, cluttering your file cabinet or digital cloud.
Firewall vs. antivirus: What's the difference and do you need both?
Photo 158227081 © One Photo | Dreamstime.com
When it comes to protecting yourself online, there’s a lot of confusion. Between VPNs, two-factor authentication, antivirus software and firewalls, there are so many ways to protect yourself that it can be hard to track them all.
Does a VPN slow down your connection? Answers to 6 common VPN questions
© Mangpor2004 | Dreamstime.com
Let’s face it, the internet can be a scary and unpredictable place when it comes to maintaining your privacy and security. You never know who may be keeping virtual tabs on you.
Whether it’s a hacker or scammer out to get your personal info, a government agency or even your creepy neighbor, you need to secure your web browsing.
Tech Refresh: Spot deepfakes, repair warning, best family plans
Wait until January to buy TVs, workout gear, winter clothes and home goods. Here’s why. Plus, TikTok live streams are getting out of control, best Christmas gifts under $50, cheapest family plans, be careful getting your phone or computer repaired and a new way to recognize fake images and videos.
Cooking a chicken by slapping it
There are many cooking methods out there for chicken. You can roast it, fry it, sauté it and many more. What about slapping? Well, one man did just that by creating a contraption that can slap a chicken until it’s fully cooked. But, how does it taste?
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.
4 things to try if a website won't load
© Aaron Amat | Dreamstime.com
Nothing can throw off your surfing groove more than a website that won’t load. You stare at the blank, white wall of your screen, wondering, “Is that it?” Luckily, there are a few different ways you can try to make the website cooperate.
5 ways tech can make your Thanksgiving easier and more fun
Photo 102453720 © Konstantin Yuganov | Dreamstime.com
The holiday season is here and you’re sending out family photos that include your pet. So is everyone else. Want to command the best real estate on your recipients’ refrigerators? Tap or click here for creative ways to include your pet in this year’s holiday cards.
10 ways to make money for Christmas that anyone can do
© Igor Mojzes | Dreamstime.com
Is there anything better than the holidays? Food, family, and gifts. What more could you want? Tap or click here for creative ways to include your pet in this year’s holiday cards.
As with anything in life, these things all come at a cost. That’s why we’re here to share ways to make this holiday season one your family and friends will never forget.
Messy photo gallery? Tricks to clean it up once and for all
© Kaspars Grinvalds | Dreamstime.com
The temperature outside is dropping, and you know what that means — holiday photo cards! If you want your card to command some real estate on your loved ones’ refrigerators, the easiest trick is to bring in your pet! Tap or click here for creative ways to include your furry friend in this year’s holiday cards.
Tech security tip: How to remove malware from your phone or computer
Photo 145690302 © Solarseven | Dreamstime.com
Anyone who regularly browses the internet needs antivirus software. Think of it as a life jacket. It’s there to keep you safe in case of an emergency.
And when malware strikes at your defenses, it’s code red. You’re afraid that you’ll lose everything, your emotions are high and you might not be in the right state of mind to find a good solution. That’s why preventative measures make a world of difference.
Run a small business? Follow this end-of-the-year checklist before 2022 ends
Photo © Prostockstudio | Dreamstime.com
The new year is right around the corner, which means it’s time for New Year’s resolutions, paperwork filing and holiday vacations. For busy business owners, there’s a lot to keep track of. Make sure you don’t forget anything important with this small business checklist.
5 free alternatives to Microsoft Excel
When Excel first hit the market, businesses flocked to use it for their management needs. But it’s far from the only option. There are many free alternatives to Microsoft Excel you should know about.
Many people are so married to Excel they won’t consider other spreadsheets. At first glance, it seems like the perfect one-stop-shop for scheduling, accounting, compiling data, tracking sales and more. Tap or click here for three tips and tutorials that help you make the most out of Excel.