Default Shipping Address in Amazon Checkout Cart is not modified by the "Manage Addresses" page

For some reason even if I set the default address in Manage Addresses on Amazon, that default address would not appear when I went through checkout normally. I finally identified this problem to being, a different address was set in my Fire Tablet Amazon App. Extremely Frustrating the tablet settings always override the webpage ones.

Game Bar Prevents Steam Overlay

When you first plug in an Xbox controller, you will see a pop-up for the game bar if you click the Xbox button. To turn off this feature so you can use the steam overlay in big picture mode do the following:

In Steam, press Win+G or Xbox button to open Game bar (choose "Yes, this is a game.")
Open the settings (cog icon) on Game bar and uncheck "Open Game bar using [Xbox logo] on a controller"
Uncheck "Remember this as a game" and Game bar should close
Now Game bar won't open when pressing the Xbox button anymore (seems to be global) and the Xbox button works as expected again in Big Picture mode. To open Game bar later, press Win+G.

Source: here

When saving a word document all comments become by "Author"

As stated in the subject, it is hugely annoying when you are trying to review papers from multiple people that have been passing along a draft if this happens. You need to :

In Word 2010, go to File->Options->Trust Center->Trust Center Settings. Then, uncheck "Remove personal information from the file properties on save"

In Word 2013, it falls under File -> Options -> Trust Center -> Trust Center Settings... -> Privacy Options. It is found under the Document-specific settings section.

 
Source:  here

Different Colors for Labels on Axis in Graph/Chart for Excel

I needed to come up with a way to have the labels different colors to add additional categorization my charts. I had seen a co-worker do this before, but he make several copies of the same graph with different colors and then just used paint to edit them. Turns out there is a much simpler answer here:
Link

Short Ver.

• Create a separate column for each colored label, and have the output be Zero or #N/A
• Change the plot of these to "Line Chart"
• Click on the label and select "Category Name" uncheck the rest
• Under the labels set the alignment label position to "below" 
• Click on the actual lines and hide them 
• Change the color of the labels 

Okay, lets say you copied the chart and the labels disappeared. 

•  Add the legend back if you removed it
• Click on the legend marker for labels "it should still be there even if there is nothing" change the color so it appear son the graph
• Right click on the line, and click "Add Data Labels" 
• Now you can edit it just like above, just make sure to make the line no color again afterwards

Teamviewer still prompts for confirmation in saved computer contacts when unattended access is setup

The issue. I click connect, and it prompts the other computer for a confirmation....no idea why that started. This was the only computer that did it. You just, unfortunately have to uninstall and reinstall.

Google Mail (GMail) Back Up

Best tool for backing up all things Google is with something called Google Takeout. See an article describing it here: https://www.howtogeek.com/216189/how-to-create-and-download-an-archive-of-all-your-google-data/

You can directly access the location here: https://takeout.google.com/settings/takeout

Cannot Locate Contact after restoring the contact from "recently deleted" in GSuite

Another admin accidentally deleted an account instead of suspending it in GSuite. I went to "Recently Deleted Contacts" and restored the user, but was unable to find them in the Console under "Users." It turns out when you restore unfortunately, it won't appear in the console under "Users" until google propagates it which could take up to 24 hrs. If you want to check the status manually, go to "Admin Console" > " Apps" > "G Suite" > "Gmail" > "Email Addresses" Then you can see his account there, and suspend it.