# Trending November 2023 # 8 Of The Most Useful Google Sheets Formulas # Suggested December 2023 # Top 18 Popular

You are reading the article 8 Of The Most Useful Google Sheets Formulas updated in November 2023 on the website Cancandonuts.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested December 2023 8 Of The Most Useful Google Sheets Formulas

Tip: If you’re working on a budget, you can apply these budgeting templates for Google Sheets.

Using Google Sheets Formulas

If you’re new to using formulas on Google Sheets, they work similarly to Excel. Simply select a cell or range and enter the formula. All formulas start the same, with an equals (=) sign.

As you start typing a formula, Google might provide suggestions. You can also go to the “Insert” menu and select “Function.” This gives you a list of possible formulas/functions to use. This is ideal if you need something, but can’t remember how it starts.

What’s also great is that Google gives you the formula format so that you know what parameters are necessary.

1. COUNTIF

COUNTIF builds upon the commonly used COUNT formula. While simply counting all the cells in a range is useful, you don’t always want to count everything. Instead, you choose the criteria, such as above or below a certain number or just a specific name.

The formula is formatted like:

=

COUNTIF

(

cellrange, criteria

)

Use this Google Sheets formula by doing the following:

Pick an empty cell and start your formula:

=

COUNTIF

Enter your desired cell range.

Enter your criteria in quotation marks.

Tip: Learn how to change the cell color in Google Sheets to making the form a little more interesting.

2. VLOOKUP

One of the most useful and underrated Google Sheets formulas is without a doubt VLOOKUP. Vertical lookup lets you pull information from a set of data based on a single piece of information.

For instance, you might have a list of employee ID numbers and names in one table, but have another set of data that only has the ID and pay rate. If you wanted to add the employee names to this second set of data, you could do it manually or use VLOOKUP to automatically match the names based on the employee ID number that the two data sets share.

You can use VLOOKUP within the same sheet or on a different sheet in the same file. For example, you might have multiple instances of VLOOKUP on other sheets that automatically look up data based on a master sheet. Change the data on the master sheet, and the formula results change on the other sheets.

At first, it does seem complicated, especially when you look at the formula parameters:

=

VLOOKUP

(

lookup

_

value, table

_

array, column, range

_

lookup

)

Simplified, you need the value you’re looking up, the cell range the data’s in, the column number of the data you need to display, and and to note whether you’re doing an exact or approximate match. Our VLOOKUP guide explains this in more detail.

For this example, I’m using a small dataset of employee ID data and pulling the names into another table that has ID and pay but not the name.

Select the cell you want the result in and start your formula:

=

VLOOKUP

(

Enter the cell the lookup will be based on. In my case, I’m using the employee ID:

Enter the range you want to search. The only downside to VLOOKUP is the column that includes the search ID must be the first column in your range, and the data you want to pull must be to the right of it.

Enter the column number (not letter) that you want to pull information from. Since I want the first name, I’m pulling from Column 3.

Enter True or False for your range_lookup. True is for approximate, while False is for exact. If no match is found, you’ll see “ERROR” instead.

My final formula ends up as:

=

VLOOKUP

(

E2,\$A2

:

\$C14,

3

,FALSE

)

.

If you’re using VLOOKUP between different sheets, add the name of the sheet before your table array, such as =VLOOKUP(E2,FirstSheet!\$A2:\$C14,3,FALSE).

3. IMPORTRANGE

The syntax is simple:

=

IMPORTRANGE

(

To pull just 2023’s forecast data from a financial’s sheet, I used the following formula:

Anytime the data is updated, your sheet will update as well.

4. IFERROR

For this formula, you’ll nest your original formula within IFERROR, such as:

=

IFERROR

(

original

_

formula, value

_

if

_

error

)

For this example, I’m calculating the average price per item based on a sale total. But, recurring payments have an item total of zero.

Select the first cell where you use your original formula.

In the formula/function box just above the sheet’s data, add IFERROR(directly after the = sign.

The first parameter is your existing formula. For more complex formulas, you may need to add extra parentheses to enclose it properly.

Add your desired value as the second parameter and close the formula with a parenthesis. In my case, I want the cell to be blank, so I’m adding ” ” as the second parameter.

My final formula is:

=

IFERROR

(

A2/B2,

" "

)

5. ARRAYFORMULA

As with many of the most useful Google Sheets formulas, ARRAYFORMULA works best with larger data sets. Google Sheets tends to slow down when it has to deal with numerous formulas. ARRAYFORMULA helps solve this issue by using a single formula for a range of cells.

This is faster, and if you ever need to change the formula, you do it once and don’t have to worry about copying it to other cells. Plus, if you add in another row, this formula automatically includes it.

For this example, I want to add an employee’s pay and bonus and place the total in a new column. I could just use =B2+C2 and drag the formula down the column, but if I’m dealing with hundreds or thousands of rows, this gets tedious quickly.

Select the first cell that you want to use a formula. For me, this is D2.

Start the formula with =ARRAYFORMULA.

Enter your usual formula but use cell ranges versus individual cells. For example, instead of B2, I’d use B2:B14 since that’s my current range.

Once you enclose your formula in parentheses, your entire column should fill in using the single formula.

My final formula was =ARRAYFORMULA(B2:B14+C2:C14). Naturally, these can get more complex, but that’s the basic syntax. You can easily change the operator, such as getting a percentage or subtracting the bonus from the pay. You’d only need to do it in the first cell to change all other cells in the range.

As long as you add a new row before the end of the range listed in your formula, it will automatically adjust ARRAYFORMULA with the new range.

Good to know: you can use Google Pay to track your spending and budget your money.

6. FILTER

=

FILTER

(

range, condition1, otherconditions

)

The “otherconditions” part is optional. These are essentially true/false comparisons of other cells to further filter your results.

In a blank cell, start your formula. Ideally, you’ll create the same column headers as the data you’re filtering, then start the formula in the first cell under your first column header. For example, I’m filtering Employee IDs with a Pay greater than \$120,000.

Enter your range and first condition. You can close the formula here or enter more conditions separated by commas. For me, my condition is only choosing values in the range of F2:F14 that are over \$120,000.

The great thing about this formula is that if you make any changes to your data, your results automatically update. Add a new row within the original range, and it’s automatically included. This is a far more dynamic option than the filters within the Google Sheets menu.

7. JOIN

The parameters include:

=

JOIN

(

delimiter, value or array

1

, value or array

2

, etc.

)

While you can have more than two values or arrays, you must have at least two. You’re free to join just single cells or full arrays or ranges into a single cell.

Select the empty cell to start your formula.

Type =JOIN( and enter your delimiter. This can be a comma, blank space, hyphen, or anything else you want. Just be sure you place the delimiter in quotes, such as “,” or “-“.

Enter your first and second values/arrays separated by commas. My final formula for joining first and last names is =JOIN(" ",B2,C2)

Alternately, you could use ARRAYFORMULA to do this for larger sheets. Using the same example above, I’d use:

=

ARRAYFORMULA

(

B2

:

B14

&

" "

&

C2

:

C14

)

In this case, you add the range for the first column and use the ampersand (&) symbol to join them. The middle section is for your delimiter.

Tip: Learn how to type ampersands and other special characters in Windows.

8. SPLIT

Do you have the opposite problem and need to split items apart in a cell? Just use the SPLIT formula. It’s the opposite of JOIN. For instance, maybe you want to separate first and last names to make it easier to sort data alphabetically by last name.

For SPLIT, the parameters are:

=

SPLIT

(

text, delimiter,

[

split

_

by

_

each

]

,

[

remove

_

empty

_

text

]

)

Made more simple, “text” is the cell you want to split, the delimiter is the character used to specify where to split the text, and the last two are optional. split_by_each refers to whether you want to split at every matching character, such as splitting apart the word “character” based on each “a” or just the first one. Remove_empty_text removes empty text from your results. It’s set to TRUE by default.

You’ll need two or more empty cells, one for each part of the text that will be split. In my example, I’m splitting the full name into first and last names, so I only need two empty cells.

In your first empty cell, start your formula with =SPLIT(

Enter the cell you want to split.

Enter your desired delimiter. For me, it’s a blank space, so I’m using ” “, but this can be anything, such as a letter or symbol.

Close your formula and multiple cells in the same row fill in.

Tip: learn about working with Apple Numbers files to make them Windows friendly.

Frequently Asked Questions Can I just highlight ranges versus entering them manually?

Absolutely! Once you start your formula and reach a parameter where a range is necessary, use your mouse or finger to highlight the range. Google will automatically fill in the column and row information, and you can move onto the next part of your formula.

Are all Google Sheets and Microsoft Excel formulas interchangeable?

No. For instance, ARRAYFORMULA is only for Google Sheets. If you want to use formulas that work with both, check the Google Sheets function list and Excel function list to ensure they share the same formulas.

Image credit: Unsplash

Crystal Crowder

Crystal Crowder has spent over 15 years working in the tech industry, first as an IT technician and then as a writer. She works to help teach others how to get the most from their devices, systems, and apps. She stays on top of the latest trends and is always finding solutions to common tech problems.

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.

You're reading 8 Of The Most Useful Google Sheets Formulas

## Build A Google Analytics Dashboard With Google Sheets

🚨 Note: All standard Universal Analytics properties will stop processing new hits on July 1, 2023. 360 Universal Analytics properties will stop processing new hits on October 1, 2023. That’s why it’s recommended to do the GA4 migration.

Google Analytics dashboards are not always comprehensive—which is why digital analysts prefer exporting their data into other tools, like Google Sheets.

Google Sheets is a great option to create a Google Analytics dashboard using the GA Reporting API. It is free, flexible, and can help you with quick analysis.

In this guide, we’ll learn how to import Google Analytics data into Google Sheets to create meaningful dashboards. We’ll also use a Google Sheets plugin called Supermetrics to import and visualize data.

An overview of what we’ll cover:

So let’s start!

An Overview of Reporting Tools

Google Analytics is one of the best tools to track your website traffic.

However, it is not flexible enough to create custom reports or data visualization dashboards that can be sent to clients.  Without data visualization, your clients may not be able to understand the data you’ve collected, no matter how thorough it is.

This is why many digital analysts prefer to export their data to different tools.

For example, you can use the tool Klipfolio to display your data in a more comprehensive manner.

Klipfolio has a few different products and different pricing tiers, including one that is free. It’s great if you are confident in your coding so that you can customize your reports, but it can be challenging if you don’t have that experience.

Similarly, if you require more data visualization and analysis, you can use Tableau.

Tableau is a well-developed software with huge data processing capabilities, although it’s a steep learning curve for most users. It also doesn’t have a free tier, although you can customize your paid plan and maximize cost-efficacy for your needs.

R projects are easy to connect to Google Analytics accounts and fetch data, but it’s quite the time investment to learn.

But sometimes, all you need is a basic analysis of your data—which you can accomplish with MS Excel or Google Sheets.

Google Analytics already has a functionality that allows you to export data directly using the Export option. With this function, you can transfer all of your data directly to Excel or Sheets.

A better way to import data from Google Analytics is using something called the Reporting API.

Let’s see how this works!

The Google Analytics Reporting API

The Google Analytics Reporting API is the interface that collects and manages your tracking data. By working directly with the reporting API, you can simplify several aspects of your data analysis workflow—including data exports.

First, you’ll need to go to the Core Reporting API and log in with the Google account that you use for Google Analytics.

This view will be the same as the one you’d see in the Home tab of your Google Analytics account.

Next, you can select the Query Parameters that you want to import. For example, let’s try to recreate the Source/Medium report of Google Analytics.

In the Query Explorer, select the start-date and end-date that you want for your report. You can also select the metrics from the drop-down menu.

To generate the Source/Medium report, we’ll select sessions as metrics and sourceMedium as dimensions.

You’ll see the Source/Medium report from the fetched data.

There are several other parameters such as segment and filters that you can select. You can also define your samplingLevel.

One great thing about this is that it’s available even in the free version of Google Analytics. It gives you a sample of free data from your Google Analytics account via the API.

If you want, you can also write a script in Python or PHP to connect to the API and fetch data. Or, you can use plugins in Excel like Analytics Canvas or Axon Analytics to import data and analyze it.

But in my opinion, Google Sheets is an easier option to create reports and dashboards.

Let me show you why.

Pros of Using Google Sheets for Reporting

To start with, Google Sheets is a free tool, and it’s easy to share your files with clients and collaborators. All they need to do is open a link—no need to download files or use special software.

As a reference for you, I have created a dashboard from scratch that contains data of an e-commerce website directly from Google Analytics.

You can download this dashboard template to create your own reports and customize it according to your requirements.

This tool allows you to connect your Google Sheets directly to the Google Analytics Reporting API and pull the data directly into the correct cells.

From there, you can format, analyze, and present the data for more insights. It’s my favorite tool for fast, easy data analysis and presentation. Let’s take a look at an example.

Pulling Data from Google Analytics Using Supermetrics

To launch Supermetrics in Google Sheets, go to the Add-ons → Supermetrics → Launch sidebar.

Make sure to connect your Google Analytics account to the add-on.

Next, we’ll go to Data source → Select views. Under the Select Dates option, we’ll select This month to date to fetch data from last month.

Going further, we can Select metrics. Let’s go with Sessions and Users.

The next option is Split by. You can split your data from rows as well as columns. In our example, the rows are already split into Sessions and Users. But we’ll split the columns by Month.

Then you can select any Segment that you’ve defined in your Google Analytics account, or you can use the Filter option to refine your data.

Lastly, you can explore the Options tab. This gives you an option to avoid data sampling (which is usually a problem with the free version of Google Analytics). If you use this feature, Supermetrics will fetch your complete, unsampled data bit by bit.

For this example, we’ll keep it unchecked to speed things up—but it’s a very useful tool if you have tons of data.

We’ll see the Sessions and Users data for the current month up to this date.

If you want, you can also add some basic Excel or Google Sheets calculations on this data. For example, we can enter a formula to find the number of sessions per user in this Sheet (done by dividing the number of sessions by the number of users).

Lastly, we can connect this data to our final dashboard by using this cell address (‘Raw Data’!C4).

But there’s much more you can do with the Supermetrics tool. It has both a free and a paid version, and which you can select based on your requirements.

Not sure what you need? Let’s break down some of the most important features.

Supermetrics Features

The paid version of Supermetrics has the ability to schedule updates to Google Sheets reports automatically and send those reports out using emails.

To access this feature, go to Add-ons → Supermetrics → Schedule refresh & emailing.

This automation saves a lot of time, especially while working with multiple Google Analytics accounts. You can also send regular reports to your clients.

The basic version is free for Google Analytics. It can also connect to a number of other tools including AdWords or YouTube to import data into Google Sheets.

However, you can only import data up to 100 rows. If you want to import more data, you’ll need to pay the price starting from €99 per month for these integrations.

Depending on your requirements, you can choose different plans. Additionally, if you want, you can also create a custom plan for your business that will be charged according to the data sources you choose.

FAQ How do I import data from Google Analytics into Google Sheets? Can I create custom reports and dashboards with Google Sheets and Google Analytics?

Yes, you can create custom reports and dashboards using Google Sheets and Google Analytics. After importing the data into Google Sheets using Supermetrics, you can format, analyze, and present the data according to your requirements. You can also customize the dashboard template provided in the blog post and tailor it to your specific needs.

Do I need to migrate to GA4 for using the Google Analytics Reporting API and Google Sheets integration?

No, the Google Analytics Reporting API and Google Sheets integration can be used with both Universal Analytics and GA4 properties. However, it’s recommended to migrate to GA4 as Universal Analytics properties will stop processing new hits on July 1, 2023, and 360 Universal Analytics properties will stop on October 1, 2023. Migrating to GA4 ensures compatibility and access to future enhancements in Google Analytics.

Summary

That’s it! This is how you can build a Google Analytics dashboard using Google Sheets and the Supermetrics add-on.

Google Sheets is a free tool that provides customizability and flexibility to analyze data. It also has various plugins to import data. Supermetrics is definitely my favorite way to pull data into Google Sheets, but you also can learn other ways to export data from Google Analytics to Google Sheets in this guide.

## How To Draw The Sierpiński Triangle In Google Sheets

The Sierpiński triangle is a fractal set in the shape of an equilateral triangle, divided into smaller triangles infinitely.

Graphically, we can draw an approximation of the Sierpiński triangle in Google Sheets:

🔗 Get this example and others in the template at the bottom of this article.

It is named after the Polish mathematician Wacław Sierpiński and is also known as the Sierpiński gasket or Sierpiński sieve.

It has the property of being self-similar, meaning it looks the same at any magnification.

See Wikipedia for more on the Sierpiński triangle.

The Sierpiński Triangle In Google Sheets

There are many different methods to construct the Sierpiński triangle.

Perhaps the easiest method to visualize is the removing-triangles method.

Start with an equilateral triangle, subdivide it into four smaller triangles and remove the central triangle. Repeat with each smaller triangle an infinite number of times.

However, we use a different method — Pascal’s triangle — to draw an approximation in Google Sheets.

Construction In Google Sheets

Pascal’s triangle is a triangle made up of numbers where each number is the sum of the two numbers above. The Sierpiński triangle is a modified version where a modulo 2 operation is performed after the addition.

Step 1:

Firstly, add additional columns up to AH so that our drawing can be 32 cells wide by 32 cells tall.

Step 2:

Next, highlight all your columns and reduce the width so they’re squares.

Step 3:

In cell B2, add the value 1. This is the value in the top left corner of the triangle.

Step 4:

In cell C2, add this formula:

=MOD((

C1

+

B1

),

2

)

and then drag it across the row to cell AG2.

The MOD function in Google Sheets returns the result of the modulo operator, the remainder after a division operation.

Step 5:

In cell B3, add this formula:

=MOD((

B2

+

A2

),

2

)

Drag down the column to cell B33.

Step 6:

Next, highlight the formulas in cells B3:B33 and drag across the rows to column AG.

Following these 6 steps, you should have a grid of 1’s and 0’s as follows:

Step 7:

Highlight the 32 by 32 grid — the range B2:AG33 — and add conditional formatting.

Set the format rule to “Is equal to” and a value of 1.

Change the background color to something bold, e.g. orange.

Step 8:

As a final step, let’s remove the numbers.

We’ll use a custom number format to do this.

Set the custom number format to:

;;;

This tells your Sheet to hide any values in the cells, so the 1’s and 0’s don’t show.

Sierpiński Triangle Variations

By changing the divisor number in the MOD formula, you can explore the fractal nature of the Sierpiński Triangle.

Follow the same steps as above, but modify the formulas so that the divisor in the MOD function is \$A\$1 rather than 2. For example, the formula in cell C2 is:

=MOD((

C1

+

B1

),

\$A\$1

)

Then in cell A1 put the value to be used as the divisor. Start with 2 as you set the Sheet up, but then feel free to experiment with different numbers.

To see the effects, you need to update the conditional formatting rules. Either: i) set up a new rule for each number, or ii) use the color scales (easier method).

Method 1: Conditional Formatting Rules

Here I set conditional formatting rules for each value up to 12, i.e. I created a rule for 2 as we did above, then replicate it for 3 but with a different color, then 4, then 5, etc.

Look closely and you can see me change the value in A1, which changes the values of the formulas and subsequently changes the formatting applied too.

Method 2: Color Scale

And here’s a variation using color scales within conditional formatting to achieve a similar effect:

Both of these examples are available in the template below.

How To Draw The MandelBrot Set In Google Sheets

How To Draw The Cantor Set In Google Sheets

Exploring Population Growth And Chaos Theory With The Logistic Map, In Google Sheets

## How To Get The Most Out Of Google Sheet’s “Explore” Feature

One of the lesser-known features of the Google line of online office suites is the Explore feature. Explore does something different in each app. For instance, in Google Docs it helps you research and cite papers as you go. In Sheets, however, the Explore feature truly comes to life. It can provide a lot of information based on your data and even updates itself depending on the data you have selected. This makes the Explore feature in Sheets something that every Sheets user should check out.

How To Access Explore

What You Can Do

So now that we have Explore open, how can we use it to “explore” our data?

Of course, you can’t just ask Sheets questions in human-styled English. For example, it won’t know what to do with “how much was spent on food?” You’ll need to type this query as something along the lines of “Total of Cost for Food,” and then Google Sheets will give you the answer.

However, it doesn’t stop there. If you like how the result turned out and want to represent it somewhere within the sheet itself, you can place a formula into Google Sheets that gets you the data you just asked about. This makes it very useful if you can’t wrap your head around coding formulas; simply ask Google what you want from your data and use the formula it provides!

Formatting

Graphs

If you scroll a little further down in the Explore pane, you’ll find that it has suggested various charts you can use. This includes a few typical pie and bar charts as well as a pivot table. You can mouse over each one for more information.

If you like the look of one in particular, you can drag it out of Explore and onto your sheet. A more detailed version of the graph will be placed onto your sheet.

Exploring the Explore Feature

While you can manually create graphs and charts for your data, Explore takes a lot of the hassle out of the process. Now you know how to use the Explore feature, where it shines, and how you can tailor it to your needs.

Does this make your Google Sheets usage easier? Let us know below!

Simon Batt

Simon Batt is a Computer Science graduate with a passion for cybersecurity.

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.

## How To Make A Bar Graph In Google Sheets

Bar graphs can be extremely helpful when it comes to visualizing data. They can display one set of data or compare multiple data sets.

In this article, we’ll go over how to make various types of bar graphs in Google Sheets.

How to Create a Bar Graph in Google Sheets

Add at least one column of data. Enter a label in the first cell of the second column, and add the data in the cells beneath it.

Next, follow these steps to insert a bar graph to represent your data.

Whichever method you choose, Google will insert a bar graph into your sheet. (Google calls it a column chart. This is the same thing.)

Making a Bar Graph with Multiple Data in Google Sheets

To make a bar graph that includes multiple sets of data, just add more columns of data.

Follow the same steps as above to insert a bar graph representation of your data.

In this case, Google uses the categories in the first row of data as the chart title.

Making a Stacked Bar Graph in Google Sheets

When you use multiple data sets, you can show the part-to-whole relationships in your data by opting for what’s called a stacked bar chart. In our example above, the chart showed how many books each person read in a particular month. If we switch the bar graph to a stacked bar chart, we’ll see how many books each person read that month compared to the total number of books everyone read that month.

There are a couple different flavors of stacked bar charts. First we’ll look at the Standard stacked bar chart.

Under Stacking, choose Standard.

Now you’ll see the values of each category stacked into single bars.

Alternatively, instead of Standard, you can choose 100% to make a stacked bar chart that depicts the ratio of individual data to the whole. Use this when the cumulative total isn’t important.

So for our example, we might not care how many books were read in total each month—only how many books each person read relative to other people.

Notice that in the 100% Stacked Bar Chart above, the labels along the x axis are now percentages.

How to Swap Columns & Rows in a Chart

Using our example, let’s say you want to make it easy to visualize how each person’s reading habits changed from month to month. Google Sheets makes it easy to turn your columns into rows and vice versa.

Our regular bar graph now looks like this:

If we switch rows and columns on our stacked bar chart, it will look like this:

You can see that each of these different options is ideal for telling a particular story about our data. Think about what story you want to tell, and determine which kind of bar graph most clearly makes your point.

Customizing Bar Graphs in Google Sheets

You may have noticed the Customize tab in the Chart Editor.

Select that tab to change the look and feel of your chart. Next we’ll go through each section of the Customize tab.

Chart style allows you to choose the background color, border color, and font for your chart. If you don’t like the changes you made, you can always select the Reset layout button to start over.

Checking the Maximize box will decrease the white space in your chart. Try it and see if you like what you see.

Selecting the 3D box will make your bars three-dimensional, like this:

Compare mode will highlight comparable data when you hover your mouse over different elements of your chart. In the chart below, notice how the November data (the top-most section of each stacked bar) is highlighted.

The Chart & axis titles section is another place you can change the chart title as well as its font, font size, format (italics, bold, etc.), and text color.

In the Series section, you can change the appearance of your series labels. In our case, that’s the months and their corresponding parts of the bar graph. For example, you could change the November data from yellow to gray.

In the Legend section, you can change the legend font, font size, format, and text color.

The Horizontal axis and Vertical axis sections offer similar options for formatting labels on each of your chart’s axes.

Finally, Gridlines and ticks is a relatively new feature (as of June 2023) allowing you to emphasize parts of your axes by inserting tick marks, formatting them, and setting the spacing between them.

Google Sheets Makes Bar Graphs Easy

Now you know almost all there is to know about making a bar graph in Google Sheets. If you’d like to learn more ways to use Google Sheets, read about the 5 Google Sheets Script Functions You Need to Know.

## Inside Source Spills The Beans On Tensor G3 Processor Of Google Pixel 8

Thanks to a source inside Google, you do not need to rely on rumors and speculations anymore. Now, concrete data regarding the processor of Google Pixel 8 is out. Codenamed Zuma, we now have all the things required to get an early glimpse of the Google Tensor G3. So, let’s dive in and see how it will actually compare with the predecessors.

Google Pixel 8 To Use ARMV9 Cores

Truth be told, the Google Tensor G2 found in Pixel 7 series was a rather uninspiring chipset. Its CPU performance was lackluster when compared with the Snapdragon 8 Gen 2. After all, when the Google Pixel 7 devices were released, the cores of SoC were already two generations behind the competition.

Tensor G2 vs Tensor G3 Config

To give you a better idea, the Tensor G2 chipset came with a 4+2+2 core layout. In comparison, most of the other chip vendors utilized the 4+3+1 layout with a single big core. So, the only SoC change that Google Pixel 7 saw from Pixel 6 series was a mid-cluster upgrade.

But with Tensor G3, Google will finally make the Pixel 8 series more up-to-date. Google has entirely rearchitected the CPU block. It will use 2023 ARMv9 cores. Google has also modified the core layout. Therefore, the new devices will not come with an unusual 4+2+2 setup.

New CPU Configuration of Tensor G3

The Tensor G3 of Google Pixel 8 will come with nine CPU cores. Among them, four are little Cortex A510s, four are Cortex A715s, and one is Cortex X3. All these cores saw a significant boost in terms of frequencies. This boost will lead to a bigger performance jump from the Tensor G2.

Moreover, the configuration with frequency boost will make the Tensor G3 compete with the performance of 2023 flagship SoCs. But, yes, the Google Pixel 8 series will fall slightly behind the chips that utilize the recently launched ARMv9.2 cores. Now, all that the Google Pixel 8 devices will require is a robust cooling system. Otherwise, the new configuration of the SoC will not be able to offer the best possible performance. But considering how good the leaked renders look, I believe Google will not disappoint in terms of thermals.

Cores G1 (Pixel 6)  G2 (Pixel 7) G3 (Pixel 8)

Big Cores 2x Cortex-X1 @ 2.8GHz 2x Cortex-X1 @ 2.85GHz

Mid Cores 2x Cortex-A76 @ 2.25GHz 2x Cortex-A78 @ 2.3GHz

4x Cortex-A715 @ 2.45GHz

Little Cores Cortex-A55 x4 @ 1.8GHz 4x Cortex-A55 @ 1.8GHz 4x Cortex-A510 @ 2.15GHz

As Google moves to ARMv9, the Google Pixel 8 series will enjoy new security technologies. To be exact, the Tensor G3 will bring ARM’s Memory Tagging Extensions (MTE). This technology is efficient at preventing some memory-based attacks, offering you a peace of mind against malicious attacks.

Other phones already come with this support. But it seems the support is only on the hardware end. That is, Android did enable this feature natively. So, the bootloader of Pixel 8 will be the first to introduce it in the Android space.

Gizchina News of the week 64-Bit Only Execution

Another big change is the 64-bit-only code execution. But that’s not really a new thing, as Pixel 7 series already dropped support for legacy 32-bit apps. However, Tensor G2 does have 32-bit libraries onboard along with 32-bit capable cores. But this will change with the Google Pixel 8 series.

The devices will ship exclusively with 64-bit binaries. But it’s still unclear whether Cortex A510 cores are configured with the support for AArch32.

The First Ever Chipset with AV1 Encode

In the Google Tensor G1, we say a hybrid architecture for the video accelerators. The chipset utilized a generic Samsung Multi-Function Codec IP block. It is the same one found in Exynos chipsets. But the support for AV1 was explicitly cut out. That’s basically where the custom BigOcean hardware video decoder block stepped in.

BigOcean has the support for up to 4K60 AV1 video decoding. Tensor G2 had the hardware block unchanged, which made Pixel 7 phones retain the same decoding capabilities. But the Tensor G3 in the Google Pixel 8 series will finally bring an upgrade to the video block. It will make the phone reduce the video’s bitrate without compromising the quality.

Ray-tracing Onboard Graphics on Pixel 8

Google has always focused the graphics unit on the Tensor lineup. The original Tensor had a robust 20-core Mali G78 configuration. It managed to outclass the Exynos 2100 and Snapdragon 888. And even though Google moved to a newer Mali G710 on Tensor G2, the benchmarks were rather unimpressive.

However, the Google Pixel 8 will be a game-changer in this regard. It will rectify Google’s past mistakes with ARM Mali G715. While the inside source did not provide an exact core count, it will likely feature a ten-core setup. This will eventually complete the Tensor G3’s GPU with fully-fledged ray-tracing capabilities. So, you can expect to get a better overall gaming experience with the Google Pixel 8.

Factors G3 (Pixel 8) G2 (Pixel 7) G1 (Pixel 6)

GPU Core Model Mali-G715 (Immortalis) Mali-G710

Mali-G78

Core count 10 7 20