Building My Dream Business For the Future.
Using Google Sheets / Microsoft Excel This post is about creating a Payroll worksheet. You can create a functional payroll worksheet using Google Sheets or Microsoft Excel. You can keep track of one or more employees, with different rates and deductions. In the image, I show you an example with some data for purposes of…
The Different Counts Functions If you are familiar to Google Sheets and Microsoft Excel, you might have worked with functions. Most of us, have used several functions and typically we keep the ones that work for us. In this blog, I will show you six types of counts functions that you can use to automate…
Using Google Sheets Last in, First out methodology The LIFO methodology assumes that items bought last will be sold first. LIFO holds true when inventory are kept in stacks; thus, the first one sold should be the last one acquired. Using this method, causes that last prices become your cost of goods sold, and older…
Using Google Sheets Average Cost Calculation The average-cost method allocates the cost of goods available for sale on thebasis of the weighted-average unit cost incurred for a given period. Several businesses use this methodology when inventory units are similar in nature. Note, the calculated average does not refer to a per unit cost only; instead,…
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…
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…