Custom Number Formatting in Google Sheets

Sometimes when you have a lot of data it is easier to see trends when you apply colour and graphics. You can do this using a chart or a complex formula. It is far easier to use custom number formatting in Google Sheets to customise the formatting and see trends.

Analyse data easily using custom number formatting in #Google #Sheets. Click To Tweet

To learn more about how to utilise the power of Google Sheets, check out our online courses.


Customising Google Sheets cells to display text and numbers

The custom number format allows you to have text and numbers in the same cell in a Google Sheet. This adds visual clarity to your spreadsheet and helps the user enter data. Calculations are still possible as Google Sheets ignores the text you have entered and uses the numerical data in the cell.

VIEW POST

The line of best fit and scatterplots in Google Sheets

Collecting data and finding the strength of the relationship between the variables, a method used in statistics. Making a scatterplot and finding the line of best fit or trendline in Excel was a piece of cake. I could never do it in Google Sheets until I found a solution! It is easy to build a meaningful scatterplot, put in a trendline and find the correlation coefficient within a couple of clicks.

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...

 

Sign Up Now
To Get The Latest Updates

 

Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: