When it comes to data requiring spreadsheets, most people will consider excel as it is a popularly known app. Excel spreadsheets are used by many companies globally to make decisions on multibillion-dollar projects through analysis by the use of excel tools. However, Microsoft excel is a heavy app for many spreadsheet users. For that reason, […]
How to convert an excel file into google sheets Read More »
Google sheet enables you to handle a lot of information especially the information that requires tabulation. Sometimes we may accidentally delete important information and that we may want to see in the file. Therefore, checking edit history is one way that the developers ensured that users do not lose their hard sought data or information
How to Check Edit History on Google Sheets Read More »
Google Speed Sheets gives you the power to toiler data to fit in your business or organization needs. Numbers or dates may appear in a variety of formats in spreadsheets that you create or receive. For example, may appear in this format “July 6, 2020” in one cell or “09/02/08” when you need cells in
How to change date format in google sheets Read More »
What if your google sheet data is a list of names in a certain column or different columns and you are required to establish the number of times certain unique names are appearing. I will show in this tutorial a simplified way to solve this problem in google sheets using the COUNTIF function. The count
How to count how many times a word appears in google sheets Read More »
Google sheets are an alternative online Excel spreadsheet found in Googles’ web browser which allows users to key in data and does analysis just like in Microsoft excel. Its advantage is that unlike Microsoft Excel, your data is automatically saved in google drive thanks to the newly added macros hence no risk of losing data
How to create a graph in google sheets Read More »
Google sheets is an online web browser spreadsheet which allows users to key in data and do analysis. The chart feature in google sheets is a useful tool which can change a bulky data into a digestible format. In a simple and quick way, I will use screenshots to explain how to create a
How to create a bar graph in google sheets Read More »
XLS as a short form for eXceL Spreadsheet and is a file extension for file formats of the spreadsheet, created by Microsoft Company and is compatible with Microsoft Excel. Just like any other excel document, files in xls format can be converted to google sheets. Google sheets is a free alternative online lightweight spreadsheet which
How to convert xls to google sheets Read More »
A histogram is defined as a chart describing how certain data is distributed through partitioning the range of data and expressing the number of values in which each partition falls. Simply and quickly, I will use screenshots to explain how to create a histogram in google sheets. Steps for Creating a Histogram 1. Select
How to Create a Histogram in Google sheets Read More »
Pivot tables will let you analyze large amounts of data and narrow down large data sets to see the relationships between data points. Pivot table in Google Sheets are used to summarize data, making it easier to understand all the information contained in your spreadsheet Google sheets allow you to make changes to the file without having
How to create a pivot table in google sheet Read More »
