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