Outlook 2016 Search Does Not Find Recent Emails

Had an issue where the search feature was not finding mails earlier than "Two Weeks Ago" solved with the following link

• File > Account Setting
• Then under the email tab click on the email account and select Change...
• Uncheck the box for "Use Cached Exchange Mode".
• Click Next and finished.
• Close and restart Outlook.
• It should now bring up recent emails

Powerpoint 2016 Flashes Table Before It Appears

This is not a post with a solution, just noting I'm not the only one seeing it: https://answers.microsoft.com/en-us/msoffice/forum/all/table-flashes-in-powerpoint-2016-presentation/214e3675-eacb-4a5d-89e1-2c001f53dbc4

Display or Hide Zero Values in Excel

Annoying issue where when I changed the formatting to Scientific, all the blank cells became 00E00. I didn't want that crowding my spreadsheet.

Solution:

• File > Options > Advanced 
• Under Display options for this worksheet, select a worksheet, and then do one of the following:
• To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
• To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.

Source

Github Backup for Organization with Script

I'm not a github wizard, but I needed to backup the repos on our organization by cloning them all, where most of the repositories are private. After playing around I found a script that would work in the windows git console below. The text in read is what you change.

1. Go to: https://github.com/settings/tokens and generate a personal access token. Make sure you write it down because it will disappear afterwards
2. In the below code, orgname is the name of your organization, and your_access_token is the token you just generated, you will also need to run it for each page.

CNTX=orgs; NAME=orgname; ACCESS_TOKEN=your_access_token; PAGE=1
curl "https://api.github.com/$CNTX/$NAME/repos?page=$PAGE&per_page=100&access_token=$ACCESS_TOKEN" |
  grep -e 'clone_url*' |
  cut -d \" -f 4 |
  xargs -L1 git clone

Echo Dots Not Turning On After Switching Location, Solid Blue Ring

When I moved, my Echo Dots were only giving me a solid blue line instead of activating. Turns out you really need to use the USB cables that come with them. I had tried to use some random ones that were lying around.

Comcast Xfinity Illogical Equipment Transfer

Long story short, I moved from one location to another and tried to use my modem. Because Comcast services are incredibly unhelpful, instead of allowing me to use my original account, they made me create a new account and transfer the credentials. When they removed my modem off my old account and I tried to activate the services at the new location they got 'illogical equipment transfer'

I spent over an hour on the phone with them not being able to figure it out. This is more or less the same issue documented on reddit here, they wanted me to drive to a service center and have it scanned :(

The solution? Use the Chat tool! The person in the chat window managed to resolve the problem in like 15 min.  

Password Protect a PDF

Unfortunately, the one really awesome feature Foxit Reader does NOT have is protecting a PDF with a Password. The next best option is to use https://www.pdfmate.com/download.html PDFMate!

If you are applying a signature in Foxit Follow the Below Steps:

1. Finish Editing the Form in Foxit
2. Save a new version of the document if desired and [Apply Signatures] 
3. Print the Document using Foxit PDF Printer
4. In PDF Mate use the Foxit PDF printed version, use the settings "Letter" and "1N1"