{"id":7648,"date":"2021-09-15T11:16:00","date_gmt":"2021-09-15T09:16:00","guid":{"rendered":"https:\/\/beebole.com\/blog\/?p=7648"},"modified":"2025-07-07T17:08:11","modified_gmt":"2025-07-07T15:08:11","slug":"pivot-tables-google-sheets-reporting","status":"publish","type":"post","link":"https:\/\/beebole.com\/blog\/pivot-tables-google-sheets-reporting","title":{"rendered":"How to use Google Sheets’ pivot tables, column stats, explore, & QUERY function"},"content":{"rendered":"\n

As a manager, perhaps you\u2019ve wondered how to take your financial reporting to the next level or how to amp up your data analysis skills. Maybe you\u2019ve got an important meeting coming up, or you\u2019d simply like to wow the executives on your next run-through. Whatever the reason, this tutorial is sure to help. We\u2019re going to look at some of Google Sheets\u2019 most useful features to transform your reporting. That includes pivot tables, column stats, explore, and QUERY. Best of all? You’ll have the confidence to use them in your own work, starting today.<\/p>\n\n\n\n

You can follow along with us by downloading this spreadsheet and following our step-by-step instructions.<\/p>\n\n\n

\n\t
\n\t\t\t\t\t
<\/div>\n
<\/div>\n \t\t
\n\t\t\t
\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t
\n\t\t\t\t\t\t\t\t\t
FOLLOW ALONG WITH OUR FREE DOWNLOAD<\/div><\/div>\n\t\t\t\t
Get this sample spreadsheet to follow our step-by-step instructions below.<\/div>\n \t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tDownload now! <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n <\/div>\n<\/div>\n\n\n

Google Sheets’ pivot tables: The main feature for analyzing data <\/h2>\n\n\n\n

Often juggling multiple projects at any one time, managers certainly feel the pressure when it comes to financial reporting. You\u2019re probably used to writing and rewriting formulas, but what if there was a better and more convenient way to present your data? In this section, we\u2019ll show you how to create a pivot table in Google Sheets in three quick steps.<\/strong> We’ll also share some tricks to analyze your data with ease.<\/p>\n\n\n\n

Before we dive in, let\u2019s cover some essentials. <\/p>\n\n\n\n

\n
\n
\n

What are pivot tables in Google Sheets?<\/h2>\n <\/div>\n
\n

Pivot tables allow you to analyze your data and present it back in lots of different ways. They\u2019re used to summarize, group, sort, reorganize, or calculate data stored in your spreadsheet, all without the need for a formula.<\/strong><\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n

\n
\n
\n

Why are pivot tables useful?<\/h2>\n <\/div>\n
\n

Pivot tables are dynamic and interactive, helping you to quickly modify their outputs and easily digest the results.<\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n

\n
\n
\n

Who should use pivot tables?<\/h2>\n <\/div>\n
\n

If you\u2019re working with data, you should be taking advantage of this clever feature. As a manager, you\u2019ll be familiar with seemingly endless datasets. But having your figures presented in pivot tables will make analyzing data a breeze.<\/strong><\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n

Creating a pivot table in Google Sheets<\/h3>\n\n\n\n

Now that you know the benefits of pivot tables, let\u2019s go through the three steps to creating your own. Remember, you can follow along with the sample spreadsheet, noting each of the tabs as we go.\u00a0\u00a0<\/p>\n\n\n\n

Step 1. Create a blank pivot table <\/em><\/h3>\n\n\n\n

To select your source data, highlight the cells you want to include, or click anywhere inside your chosen tab to capture everything. You can find this under the \u2018Source Data\u2019 tab on the sample spreadsheet. For this example, select cells A1 to G131, then click Data > Pivot table, as shown in the screenshot below.<\/p>\n\n\n\n

\"Under
After selecting cells A1 to G131, click Data > Pivot table. <\/figcaption><\/figure>\n\n\n\n

A dialogue box will appear and ask if you want this pivot table to be input into a new or existing worksheet. For the latter, be sure to choose which cell you would like to start from (for example, cell A1). For these examples though, we will input the pivot tables next to the source data in new tabs (for example, cell I1 as below).<\/p>\n\n\n\n

\"A
The dialogue box will ask if you’d like the pivot table to be inserted into a new or existing worksheet.<\/figcaption><\/figure>\n\n\n\n

The \u2018pivot table editor pane\u2019 appears on the right-hand side, and the blank pivot table placeholder on the left. You can find this in the \u2018blank pivot table\u2019 tab. Google Sheets automatically offers a few suggested Pivots to try, but for this tutorial, we\u2019ll be creating examples from scratch.<\/strong><\/p>\n\n\n\n

\"Pivot
The \u2018Pivot table editor Pane\u2019 on the right-hand side automatically offers a few suggested pivots to try.<\/figcaption><\/figure>\n\n\n\n

Step 2. Add your data \u2013 part one <\/em><\/h3>\n\n\n\n

To include the data you want to analyze, simply click \u2018Add\u2019 and choose the fields you need. Let\u2019s assume you\u2019d like to calculate the total sales from each of the sales reps. <\/p>\n\n\n\n

For this, you would add \u2018Sales Rep\u2019 under \u2018Rows\u2019 as shown in the screenshot below. <\/p>\n\n\n\n

\"\"
Click ‘Add’ and choose the fields to include the data you’d like to analyze. For our example, choose ‘Sales Rep’ under ‘Rows.’<\/figcaption><\/figure>\n\n\n\n

Step 3. Add your data \u2013 part two<\/em><\/h3>\n\n\n\n

Now add \u2018Total Sales\u2019 under \u2018Values\u2019 as shown in the screenshot below.<\/p>\n\n\n\n

\"Under
Click ‘Add’ and then ‘Total Sales’ under ‘Values.’<\/figcaption><\/figure>\n\n\n\n

The screenshot below shows you what your pivot table should look like (on the right), next to the relevant source data (on the left). You can also find this example in the \u2018Pivot 1 – Sales by Rep\u2019 tab.<\/p>\n\n\n\n

\"Here
Here you can see the source data on the left and the pivot table on the right.<\/figcaption><\/figure>\n\n\n\n

And there you have it. Three straightforward steps to creating your own pivot table in Google Sheets with no formula in sight!<\/strong><\/p>\n\n\n\n

More ways to use pivot tables<\/h2>\n\n\n\n

Of course, there are many more features to explore, and pivot tables can vary in complexity. Did you know that with our add-on for Google sheets<\/svg><\/span><\/a>, you can combine your timesheet data with the power of Google Sheets and these very reporting features we’re diving into? Let\u2019s explore some other ways to present our data through pivot table examples, using the sample spreadsheet as we go.<\/p>\n\n\n\n

Multiple fields <\/em><\/h3>\n\n\n\n

For a multi-layered report, you may want to add more fields and display more data in the one table.<\/strong> Let\u2019s say you would like to compare the country against your original calculation. <\/p>\n\n\n\n

For this, you would use the same fields as \u2018Pivot 1 – Sales by Rep\u2019 and add \u2018Country\u2019 under \u2018Columns,\u2019 as shown in the screenshot below.<\/p>\n\n\n\n

\"\"
To display more data in one table, simply add more fields. Here, add ‘Country’ under ‘Columns.’<\/figcaption><\/figure>\n\n\n\n

The screenshot below shows you what your pivot table should look like (on the right), next to the relevant source data (on the left). You can also find this example in the \u2018Pivot 2 – Sales by Rep by Country\u2019 tab.<\/p>\n\n\n\n

\"Here
Source data is on the left, and the pivot table is on the right.<\/figcaption><\/figure>\n\n\n\n

Aggregation methods<\/em><\/h3>\n\n\n\n

Totaling numbers is most common, but sometimes it\u2019s more interesting to review averages, counts, or percentages of our data.<\/strong> Perhaps you need to know the average sales in each location or the count of items by product for an inventory report, where the value is less important than a physical count. Sum, average, and count are different types of \u2018aggregations.\u2019<\/p>\n\n\n\n

Using our example from \u2018Pivot 2 – Sales by Rep by Country,\u2019 let\u2019s see the difference between summarizing by \u2018SUM\u2019 and summarizing by \u2018AVERAGE.\u2019 <\/p>\n\n\n\n

Under \u2018Values\u2019, click \u2018SUM\u2019 and choose \u2018AVERAGE\u2019 from the list, as shown in the screenshot below.<\/p>\n\n\n\n

\"One
Under ‘Values,’ click ‘SUM’ and choose ‘AVERAGE.’<\/figcaption><\/figure>\n\n\n\n

The screenshot below shows you what your pivot table should now look like (on the right), next to the relevant source data (on the left). See this example in the \u2018Pivot 3 – Average Sales\u2019 tab and compare it to \u2018Pivot 2 – Sales by Rep by Country\u2019. <\/p>\n\n\n\n

\"Source
Source data is on the left, and the pivot table is shown on the right.<\/figcaption><\/figure>\n\n\n\n

Another handy aggregation is \u2018COUNTUNIQUE,\u2019 which you might use for counting the unique values in a list of data. This is different from \u2018COUNTA,\u2019 which just counts the rows, including any duplicates). <\/p>\n\n\n\n

Note: Excel doesn\u2019t have this feature, so you\u2019ll only find it in Google Sheets. <\/em><\/p>\n\n\n\n

Using a new example, let\u2019s say you\u2019d like to know how many sales reps you have for each country. \u2018COUNTA\u2019 will display the number of times that sales rep is mentioned in the data. \u2018COUNTUNIQUE\u2019 will ignore the duplicates and give you the accurate number. <\/p>\n\n\n\n

To do this, under \u2018Rows\u2019 click \u2018Country\u2019, then under \u2018Values\u2019 click \u2018Sales Rep\u2019 and choose \u2018COUNTUNIQUE\u2019 from the list.<\/p>\n\n\n\n

\"The
Under \u2018Rows\u2019 click \u2018Country\u2019, then under \u2018Values\u2019 click \u2018Sales Rep\u2019 and choose \u2018COUNTUNIQUE\u2019 from the list.<\/figcaption><\/figure>\n\n\n\n

The screenshot below shows you what your pivot table will look like (on the right) alongside how this compares to \u2018COUNTA\u2019, with the relevant source data (on the left). You can also find this example in the \u2018Pivot 4 – COUNTUNIQUE vs COUNTA\u2019 tab.<\/p>\n\n\n\n

\"A
A look at source data on the left and the pivot table on the right.<\/figcaption><\/figure>\n\n\n\n

Column stats \u2013 Google Sheets’ latest feature and how it can help you<\/h2>\n\n\n\n

Managers don\u2019t always have time to create pivot tables to identify key trends, statistics, and anything that may stand out as a financial risk. They\u2019re also responsible for ensuring the data their team is collecting is accurate. As you\u2019ll know all too well, one small but undetected mistake can have disastrous results.<\/strong> In this section, we\u2019ll show you how to utilize this brand new feature to check your data in a matter of seconds.<\/p>\n\n\n\n

\n
\n
\n

So what\u2019s the column stats feature all about?<\/h2>\n <\/div>\n
\n

Released in October 2020, column stats gives a quick overview of an entire column in just two clicks. It provides insights so you can see a column\u2019s values in an accessible format, and helps you analyze your data quickly and prepare your input data before creating reports.<\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n

Note: Excel doesn\u2019t have this feature, so you\u2019ll only find it in Google Sheets. <\/em><\/p>\n\n\n\n

Using column stats to grab an overview of your data<\/h2>\n\n\n\n

Let\u2019s go through the two steps for using column stats to get a quick glance at your data without having to create a pivot table. For this feature, follow along with the sample spreadsheet using the \u2018Data for Column Stats\u2019 tab. Note that it includes some deliberate errors to better help you understand how it works. <\/p>\n\n\n\n

Step one. Choose your column<\/em><\/h3>\n\n\n\n

First, decide which column you wish to view. For this example, we will use the \u2018Product\u2019 column C. Click Data > Column stats, as shown in the screenshot below.<\/p>\n\n\n\n

\"Find
After choosing which column to use, click Data > Column stats.<\/figcaption><\/figure>\n\n\n\n

Step two. Consider the results <\/em><\/h3>\n\n\n\n

The values for this column will now be displayed on the right-hand side ready for analysis, as shown below.<\/p>\n\n\n\n

\"The
The column will now be displayed on the right-hand side.<\/figcaption><\/figure>\n\n\n\n

Let\u2019s say you\u2019d like to know what types of products are currently being sold. This column breakdown allows you to see the list of products and if any incorrect data has made its way into your spreadsheet.<\/strong> In the example below, you can see \u2018Mrror\u2019 is an item that should not be included in this column.<\/p>\n\n\n\n

\"It's
This column breakdown gives you a quick glance of all of the products and allows you to easily spot any incorrect data.<\/figcaption><\/figure>\n\n\n\n

You can now toggle between the other columns to see their stats on the right-hand side, as shown below.<\/p>\n\n\n\n

\"By
You can toggle between other columns to see their stats on the right-hand side, too.<\/figcaption><\/figure>\n\n\n\n

This breakdown of values for column E allows you to see the average and sum total of sales at a glance. All of this data and without any need for formulas or pivot tables!<\/p>\n\n\n\n

Explore \u2013 Google Sheets’ hidden feature and how it can work for you<\/h2>\n\n\n\n

With a consistently busy work schedule, every manager is keen to know the latest ways to save time and improve their efficiency.<\/strong> While column stats and pivot tables help you create and upgrade your reporting, what happens when you need answers immediately and you\u2019re not sure how to present them? <\/p>\n\n\n\n

That\u2019s where Google Sheets\u2019 explore feature comes in. Whether you\u2019re struggling with preparing financials in an attractive audience-friendly format, or you need to identify the trends in the last quarter\u2019s sales, this one-click wonder will be your new best friend. In this section, we\u2019ll show you how to use the explore feature to instantly gain insight from your data with the impressive power of AI.<\/strong><\/p>\n\n\n\n

So what\u2019s so great about explore? <\/em>The explore feature allows you to ask questions about your data as it automatically analyzes everything in your spreadsheet, making visualizing and presenting the information even more straightforward. It pre-suggests charts and pivot tables for your data so you can save time from manually creating them yourself.<\/p>\n\n\n\n

Using the explore feature to ask those big questions<\/h3>\n\n\n\n

As the quickest of the three features we\u2019ve discussed in this tutorial, explore offers an effortless way to examine large datasets in just one click.<\/p>\n\n\n\n

Let\u2019s walk through the various ways explore can help you find the answers you need to enhance your reporting further. For this feature, you can follow along with the sample spreadsheet using the \u2018Source Data\u2019 tab.<\/p>\n\n\n\n

To launch the explore feature, select the data you\u2019d like to focus on (for example, A1 to G131) and click on the \u2018Explore\u2019 icon at the bottom-right of your screen, as shown in the screenshot below.<\/p>\n\n\n\n

\"The
Select the data you’d like to analyze, and click on ‘Explore’ at the bottom-right of your screen.<\/figcaption><\/figure>\n\n\n\n

Explore will then display a list of suggestions on the right-hand side, including \u2018Answers,\u2019 \u2018Formatting,\u2019 \u2018Pivot tables\u2019, and \u2018Analysis,\u2019 as shown in the screenshots below.<\/p>\n\n\n\n

\"Explore
Explore offers a list of suggestions on he right-hand side, including \u2018Answers,\u2019 \u2018Formatting,\u2019 \u2018Pivot tables\u2019, and \u2018Analysis.’<\/figcaption><\/figure>\n\n\n\n

To see more suggestions, click \u2018MORE\u2019, as shown below.<\/p>\n\n\n\n

\"By
Click ‘MORE’ to see more suggestions.<\/figcaption><\/figure>\n\n\n\n

When you find something you want to use, click the \u2018Insert\u2019 icon, as shown below.<\/p>\n\n\n\n

\"Once
Click the ‘Insert’ icon once you’ve fond something you’d like to use.<\/figcaption><\/figure>\n\n\n\n

Using the search function under the \u2018Answers\u2019 section, type in the questions you have about the data. Let\u2019s imagine you\u2019d like to know the following;
1) \u201cWhat is the sum of total sales for Ireland?\u201d.
2) \u201cWho are the top 3 sales reps by total sales?\u201d
3) \u201cWhat are the numbers of units sold by country?\u201d<\/p>\n\n\n\n

The screenshots below show how these questions would be displayed as answers, complete with suggested ways to present and analyze the data.<\/p>\n\n\n\n

\"Three
Three examples of questions displayed as answers using the ‘explore’ feature.<\/figcaption><\/figure>\n\n\n\n

QUERY \u2013 Google Sheets\u2019 most advanced function and how you can master it<\/h2>\n\n\n\n

When you\u2019re working with financials, it\u2019s easy to get frustrated with the amount of data in one spreadsheet, especially when you only need to look at specific subsets. Imagine you have a worksheet with thousands of figures, but you would like to generate a report with just a couple of products to see their sales progress. Maybe you also need to include the sales person and the location but you need them in a different order from the source data. QUERY is the formula way to do this.<\/strong><\/p>\n\n\n\n

\n
\n
\n

So what does QUERY do?<\/h2>\n <\/div>\n
\n

This clever feature allows you to use SQL-like code (\u2018Structured Query Language\u2019 is a programming language which operates using statements) inside a formula to manipulate your data.<\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n

\n
\n
\n

Will using QUERY really save me time?<\/h2>\n <\/div>\n
\n

Rather than having to copy and paste your data, and write formulas to pick out the relevant information, QUERY offers you a flexibility and robustness<\/strong>\u00a0that is more sophisticated than anything else that Google Sheets can produce.<\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n

Note: Excel doesn\u2019t have this feature, so you\u2019ll only find it in Google Sheets. <\/em><\/p>\n\n\n\n

Using QUERY to transform your reporting <\/h3>\n\n\n\n

Let\u2019s go through the step by step process for using QUERY as a beginner. For this function, you can follow along with the sample spreadsheet, noting each of the tabs as we go.  <\/p>\n\n\n\n

QUERY uses the following format; =QUERY(data, query, [headers]). Entering [headers] is optional as Google will usually guess which ones to use.<\/p>\n\n\n\n

Step one. Enter your source data range<\/em><\/h3>\n\n\n\n

First, click in an empty cell in your worksheet and type \u2018=QUERY\u2019, then \u2018(\u2018 and then highlight the data range you\u2019d like to use (for example, A1 to F131), as shown in the screenshot below.<\/p>\n\n\n\n

\"First,
Click in an empty cell and type \u2018=QUERY\u2019, followed by (, and then highlight the data range you\u2019d like to use. <\/figcaption><\/figure>\n\n\n\n

Step two. Enter your query in speech marks – SELECT<\/em><\/h3>\n\n\n\n

Let\u2019s assume you\u2019d only like to analyze the units of products sold by the sales reps. For this, you would enter the \u2018query\u2019 as \u201cselect B,D,E\u201d, (referencing the column letter) as shown in the screenshot below.<\/p>\n\n\n\n

\"Click
Type “select B,D,E” to analyze the units of products sold by sales reps.<\/figcaption><\/figure>\n\n\n\n

Now click \u2018enter\u2019 on your keyboard.<\/p>\n\n\n\n

The screenshot below shows you what your QUERY should look like (on the right), next to the relevant source data (on the left). You can also find this example in the \u2018QUERY 1 – SELECT\u2019 tab.<\/p>\n\n\n\n

\"An
The source data is on the left, and the QUERY is on the right.<\/figcaption><\/figure>\n\n\n\n

You can also retrieve any combination of columns in any order you like (even non-sequential) for example \u201cSELECT D, F, C, A\u201d would work just fine.<\/p>\n\n\n\n

Step three. Enter your query in speech marks \u2013 SELECT and WHERE<\/em><\/h3>\n\n\n\n

Let\u2019s say you\u2019re only interested in the units of wheels sold by the sales reps. For this, you would enter the \u2018query\u2019 as \u201cselect B,D,E where D = \u2018Wheel\u2019\u201d, as shown in the screenshot below.<\/p>\n\n\n\n

\"Retrieve
Enter the \u2018query\u2019 as \u201cselect B,D,E where D = \u2018Wheel\u2019\u201d<\/figcaption><\/figure>\n\n\n\n

Now click \u2018enter\u2019 on your keyboard.<\/p>\n\n\n\n

The screenshot below shows you what your QUERY should look like (on the right), next to the relevant source data (on the left). You can also find this example in the \u2018QUERY 2 – SELECT + WHERE\u2019 tab. <\/p>\n\n\n\n

\"What
Source data is on the left, and the QUERY is on the right.<\/figcaption><\/figure>\n\n\n\n

You can see that WHERE can refer to any column, not just the ones in your output table (e.g. WHERE C=\u201dUK\u201d would return just those rows).<\/p>\n\n\n\n

Step four. Enter your query in speech marks \u2013 SELECT and WHERE and AND<\/em><\/h3>\n\n\n\n

Let\u2019s say you\u2019re only interested in the units of wheels sold by the sales reps when the units sold is greater than 5. For this, you would enter the \u2018query\u2019 as \u201cselect B,D,E where D = \u2018Wheel\u2019 and E>5\u201d, as shown in the screenshot below.<\/p>\n\n\n\n

\"Using
Enter the \u2018query\u2019 as \u201cselect B,D,E where D = \u2018Wheel\u2019 and E>5\u201d to see the units of wheels sold by the sales reps when they sold more than 5.<\/figcaption><\/figure>\n\n\n\n

Now click \u2018enter\u2019 on your keyboard.<\/p>\n\n\n\n

The screenshot below shows you what your QUERY should look like (on the right), next to the relevant source data (on the left). You can also find this example in the \u2018QUERY 3 – SELECT + WHERE + AND\u2019 tab.<\/p>\n\n\n\n

\"A
Here’s a look at the source data on the left, and the QUERY on the right.<\/figcaption><\/figure>\n\n\n\n

Although QUERY goes a lot further with more functions like \u2018PIVOT\u2019 and \u2018ORDER BY\u2019, the majority of the time, SELECT and WHERE provides the required breakdowns for financial analysis.<\/strong> Say goodbye to feelings of frustration and copy and paste horror stories; With this nifty, robust feature, you\u2019ll be a master of data manipulation in no time.<\/p>\n\n\n\n

In this tutorial, we\u2019ve discussed four of Google Sheets\u2019 expert reporting and analysis features; pivot tables, column stats, explore, & QUERY function. Whether you\u2019re a novice still learning the ropes or a veteran of all things spreadsheets, we hope these quick wins help you upgrade your financial reporting and get you that all-important \u2018wow\u2019 from the team. <\/p>\n\n\n\n

Is there a feature we\u2019ve discussed in this tutorial that you\u2019d like to learn more about? Let us know in the comment section below.<\/p>\n\n\n\n

–<\/em>
This article is part of our tutorial series<\/a>, where we often invite spreadsheet experts to share their expertise in thoughtful, actionable ways that managers can start using today. If you’re more comfortable in Microsoft Excel, don’t miss 5 hacks with Excel Power Query<\/a>, or how to build an automated time tracking report with Power Query<\/a>.<\/em>
–<\/em><\/p>\n\n\n\n

\n\t\n\t\t\t\t\t
<\/div>\n\t\t\t\t
<\/div>\n\n\t\t
\n\t\t\t
\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t
\n\t\t\t\t\t\t\t\t\t
RELATED POST<\/div><\/div>\n\t\t\t\t\t\t\t\t
The complete guide to annual compensation reviews using Google Sheets<\/div>\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\tRead more\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t<\/a>\n<\/div>
The experts who have written or contributed to this article are independent from Beebole, and their contribution doesn't serve as endorsement for our company\/tool or their past\/present organizations, employers, or associates.<\/div>","protected":false},"excerpt":{"rendered":"

As a manager, perhaps you\u2019ve wondered how to take your financial reporting to the next level or how to amp up your data analysis skills. Maybe you\u2019ve got an important meeting coming up, or you\u2019d simply like to wow the executives on your next run-through. Whatever the reason, this tutorial is sure to help. We\u2019re […]<\/p>\n","protected":false},"author":29,"featured_media":10730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[123],"tags":[2892,3980,4013],"class_list":["post-7648","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-productivity-time-management","tag-google-sheets","tag-reporting","tag-templates"],"acf":[],"_links":{"self":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts\/7648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/comments?post=7648"}],"version-history":[{"count":18,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts\/7648\/revisions"}],"predecessor-version":[{"id":13999,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts\/7648\/revisions\/13999"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/media\/10730"}],"wp:attachment":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/media?parent=7648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/categories?post=7648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/tags?post=7648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}