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.
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.
Run a small business? Follow this end-of-the-year checklist before 2022 ends
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.
Free versions of Excel if you don’t want to pay for Microsoft 365
Smart penny pinchers know there are a ton of freebies around the web. You have to be savvy about where you search since there are a ton of dangerous downloads lurking. We’re always here to share safe tools, like the top free Excel alternatives.
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.
Budgeting tip: An easy way to slash your monthly charges
Your dollars don’t go as far these days. Sure, things are more expensive, but “buy now” buttons and shiny new services add up much faster than we’d like to believe. It’s no surprise that subscription-based business models are so popular.
8 tax deductions that may save you some cash in 2022
Spring is just around the horizon. Soon, the snow will melt from the landscape and flowers will pop up left and right. Tax season is also popping up, so it’s time to take out your paperwork and prepare for drudgery.
Here’s some good news, though. You don’t have to brace yourself for Uncle Sam snatching away your hard-earned money. Tax deductions can do you a world of good if you qualify for them, that is.
Don't make the same mistake that cost me $90K
I’ve been a small business owner for 25 years. Along the way, I’ve had some great successes, along with my fair share of mistakes.
Sometimes those mistakes are easy to recover from. You recognize what went wrong, regroup and try something new. And sometimes you realize, “Uh oh. This is something I can never let happen again.”
5 budgeting worksheets to keep you on track in the new year
Managing your money can be challenging if you do it alone. First off, you’ll need solid mathematical skills to crunch the numbers yourself. A single miscalculation could throw a wrench in your financial plans if you go down that route.
3 simple things that will save your business money to start the fiscal year
Many people think that owning your own business means you have hundred-dollar bills hanging out of your wallet. Small business owners know differently.
Business owners face a myriad of financial hurdles, more so since the pandemic. So when it comes to budgeting, finding ways to cut costs is a priority for every business owner.
4 programs that work like QuickBooks but aren't as frustrating
Keeping track of your finances is important no matter what you do for a living. From independent contractors to salaried employees to business owners, it all comes down to the books. When tax season comes, you don’t want to get caught unprepared.
Don't make this big mistake e-commerce companies often make
It’s a great time to sell online. Last year, many people didn’t want to venture out of their homes to shop at physical stores. That’s why they used online stores to get their essentials.
Statista studies found over 2 billion people bought goods or services online in 2020. Not only that, but sellers made 4.2 trillion U.S. dollars in e-retail sales worldwide. Good news: The online shopping gold rush is nowhere near stopping.
These versions of QuickBooks are no longer supported - Time to upgrade
Each year, Intuit discontinues older versions of its QuickBooks line. As of May 31, these versions are no longer supported:
If you were using one of those editions, it’s seriously time to upgrade. We say it’s time to ditch the spreadsheets altogether. Don’t let QuickBooks and spreadsheets slow you down, making things harder than necessary. It’s time to upgrade to NetSuite.