How to see and delete your Google Voice Search history

Google voice search

So, you have an Android based smartphone and you often use Google voice commands for your day to day activities. Okay, you kind of had a hunch that Google stores all your voice activities just like it keeps track of what you type in Google’s search bar or, or, how it scans your emails. Your Google Voice Search History. Scary, isn’t it?

Don’t worry, at least for the voice part. Here is a step by step guide to see and delete either specific or all of your Google voice search history.

Step by step guide to view and delete Google Voice Search History

Visit https://www.google.com/history in your web browser.
Once you visit this page, you will be asked for your google account login credentials. After logging in, this will be your landing page:

Google voice search

Click on the below highlighted icon to enter into a menu which will show you various options like – Web & App Activity, Voice & Audio Activity, Device Information etc.

Google voice search

Google voice search

Click on Voice & Audio Activity and Voila, you can see all your Google Voice Search History. Go ahead, check all of them. Click on PLAY button as highlighted below to actually hear what you’ve been saying to Google:

Google voice search

For Deletion, Click on the icon as shown below and a menu will open from where you can select Delete options:

Google voice search

You can delete your audio files which have been recorded either today, yesterday or delete all the information by selecting Advanced option as shown below:

Google voice search

As always, if you found this article useful, share it across all your social media platforms. Spread the word. Cheers!!

Excel Pivot Table – How to move rows and columns?

Excel Pivot Tables are extremely useful, especially when you are playing with large volumes of data and need to perform data analysis. Often times, we are unable to perform certain tasks in pivot tables due to lack of our understanding of the full functionality of excel pivot tables. One such task is moving rows and columns. Here is a step by step guide to do the same.

First of all, we need a data set as shown below. For a step by step guide to create excel pivot tables logically, read my earlier post on the same. Now that you have created a pivot table, it would show something like this:

Capture 21

Now the real deal.

Move your cursor to cell containing one of your column labels. In our case, the label is ‘FALSE’. Now, right click on the cell and a drop down menu appears. Bring your cursor down to Move option and then select either “Beginning”, “Left”, “Right” or “End” according to where you want your column label to be positioned. That’s it!

Capture 26

A similar exercise on the rows of the excel pivot tables will allow you to re-position rows. Once you have created a pivot table using your data, all you need to do is click on one of the row labels, A being the case in point, here. Then following the same procedure – Right click ->Move option -> “Beginning”, “Up”, “Down” or “End” as per your requirements.

Capture 24

If you find this post useful, do share it on social media.You can like this post using Facebook like button as it appears in left side of my posts. Better still, subscribe to my newsletter and never miss a post. Spread the word. Cheers!

Excel Pivot Table – Create multiple excel pivot tables on same worksheet

In my previous post on excel pivot table, I showed you how to create pivot tables from a data set on your existing worksheet. There are instances when we need to create multiple excel pivot tables using the same data set. Either we can create excel pivots on multiple worksheets using the New Worksheet option while creating excel pivot tables or we can create multiple excel pivot tables on same worksheet.

Referring to our data, we created pivot table like this:

excel pivot-snapshot-1excel pivot-snapshot 36Now, we create one more pivot table from the current data set by again selecting our data set and destination cell as shown below:

excel pivot-Capture 39

excel pivot-Capture 41

So, by doing this, we are able to have two pivot tables on same sheet. You can create more than two pivot tables also, following the same procedure. One caution to exercise, though. Always remember to put empty rows between two pivot tables to avoid overlap of pivot tables and error regarding the same.

excel pivot-Capture 42

So, now you know how to create multiple pivot tables on same sheet. If you liked this post, share it on social media and subscribe to my newsletter. Cheers!

Creating an Excel Pivot Table from your data

excel Pivot tableExcel Pivot Table is an extremely useful tool for arranging your data in rows and columns. It is of great help in data analysis. In this post I am going to show you how to create excel pivot table from your data set.

Creating an Excel Pivot Table from data

Let us consider a data set as shown below. Here, the data in column B with the heading G shows three categories – A, B and C. These can be names of employees, for example. D, E and F represent individual categories – say – question numbers across which A, B and C have given their responses in two choices – TRUE or FALSE.

excel Pivot table

Now, we’ll create an excel pivot table for this data.

For this, firstly select your data as shown below. Don’t miss out on any cell containing data.

excel Pivot tableNow, suppose that you need to create a pivot table for the data in column G across column D or E or F. You need to see how said TRUE and how many said FALSE. You can proceed as below.

Go to Insert -> PivotTable as highlighted in red below. Either directly click on PivotTable or click on the arrow below it and select PivotTable from the drop down menu.

excel Pivot table

excel Pivot table

After you have clicked on PivotTable, a pop up menu opens like this:

excel Pivot table

Table/Range shows your data selection. By default, the destination for pivot table is a new Worksheet. You can either click OK or select destination cell by clicking on Existing Worksheet and then against location as shown below:

excel Pivot table

Next, select a cell in the worksheet where you wish to put your pivot table. In this case, cell selected is G1 as highlighted in red below.

excel Pivot table

A pivot table is created as shown below:

excel Pivot table

Now we start populating fields in this table. For this, just drag and drop the fields you need from “Choose fields to add to report:” to “Report Filter”, “Column Labels”, “Row Labels” and “Values”.

excel Pivot table

We’ll create our pivot table with respect to data in G across D. So, we put G in Row Labels, D in Column Labels and D again  in Values. Remember to put D in Values for showing data pertaining to cells in column with the heading D. And as you can see a pivot table is created.

excel Pivot tableShare this post if you found it useful and subscribe for more such articles. Cheers!