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 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.
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.