Using Google Sheets function SYD( ) To setup a Sum of the Years Depreciation Schedule for your fixed assets, you need to list your assets (column A). Then, include the item’s cost (column B), include each asset’s useful life in years (column C). Last, determine any residual value (optional), if not include $0 (column D)….
Category: Business
Using SUM function with Google Sheets
Using various SUM formats Using SUM( ) The sum function adds values based on a selected range. Example A, shows the total from cells E6 to E9. The syntax is shown as =SUM(E6:E9). You can achieve the same by adding each value individually, like =E6+E7+E8+E9. However, when the list consists of various hundred or thousand…
How to use simple math calculations with Google Sheets
Basic Math Operators Although Google Sheets has several functions, all start by using the basic math operators to understand the power of this spreadsheet. This post only covers the basic math operators for your understanding, I will post more on more advance features of Sheets. Before any operator or function Both Google Sheets and Microsoft…
How to use Google Sheets
Five steps to start enjoying this spreadsheet software We have two major spreadsheet software programs in the market: Microsoft Excel and Google Sheets. Both have similar functionalities, and their functionalities improve as time passes. Once you open a Google account, you get the whole family, which includes Sheets, Google’s online spreadsheet software. To find the…
How to Improve your Credit Score
This site contains affiliate links to products and services. We may receive a commission for purchases made through these links. What is a credit score? A composition of values being reported by lenders that gets weighted based on five categories, and a three-digit number is calculated. This calculated number becomes your credit score. Easy, right?…
How to prepare a Personal Budget
This site contains affiliate links to products and services. We may receive a commission for purchases made through these links. Why a Personal Budget? A personal budget serves as a plan to properly allocate the amounts of money that you have or receive into the savings, costs, and expenses of your life. Please note that…
How to Manage a Business’ Accounts Receivable?
This site contains affiliate links to products and services. We may receive a commission for purchases made through these links. Definition: Amounts owed to the business by individuals or businesses. Receivables arise from credit sales of goods or services. To the company, these represent current assets; several companies have large amounts of accounts receivable. Financial…
Reconciling your Personal or Business Bank Account
This site contains affiliate links to products and services. We may receive a commission for purchases made through these links. For many of us, opening a bank account is our first formal financial transaction. Before that, we all paid with cash, and most of the time it was for miscellaneous things and not too expensive….
How to Create a Blog for Personal or Business
This site contains affiliate links to products and services. We may receive a commission for purchases made through these links. Do you want to create a blog to write about your hobby, your cooking recipes, your specialized business career, helping others or just about anything? With Bluehost you can do it. Bluehost is a web…
How to Use the Accounting Equation
This site contains affiliate links to products and services. We may receive a commission for purchases made through these links. The accounting equation denotes the basic elements of what the business owns and what it owes. The resources that will yield probable future benefits are the assets, and those rights or claims are the liabilities…