Tips and Tricks

Tip #1 – Beware SharePoint and OneDrive Phishing

Warnings about phishing and scams are becoming commonplace as there are new iterations every day. Be on alert! This one can catch you with your guard down.

The bad guys have a new way of stealing your login credentials. They target you by sending you an invite via email to open a SharePoint document. The link takes you to an actual SharePoint page where you will see a OneDrive prompt. The prompt will have an “Access Document” link in it- don’t click this link!

This link is malicious and will take you to a fake Office 365 login screen. Any credentials you enter here will be sent to the bad guys. Don't be tricked.

Whenever you're submitting login credentials to any site, make sure to check the URL of the page for accuracy. Always remember to hover over links to see where they are taking you. Remember, Think Before You Click! And if you're not sure about something, STOP! Call the sender or ask technical support for a second pair of eyes.

Tip #2 - Upgrading your iPhone or iPad to Apple iOS 12? Back up your device first

You can back up your Apple device using either iCloud or iTunes. iCloud will back up your device to your iCloud account that comes with 5GB of storage by default, you can purchase more if needed. Or you can us iTunes to back up locally to your PC or Mac. You will need to have iTunes installed on your computer and enough free space to be able to store the back up. In general backing up to your computer using iTunes and encrypting the back up will give you the most complete back up. If you do encrypt your back up make sure to store the password in a secure location.

To back up using iCloud all you need to do is:

  1. Connect your device to your Wi-Fi network.
  2. Go to Settings > [your name], and tap iCloud.
  3. Tap iCloud Backup.
  4. Tap Back Up Now. Stay connected to your Wi-Fi network until the process completes.
  5. You can check the progress and confirm the backup completed. Go to Settings > [your name] > iCloud > iCloud Backup. Under Back Up Now, you'll see the date and time of your last backup.

To back up using iTunes all you need to do is:

  1. Update to the latest version of iTunes.
  2. Open iTunes and connect your device to your computer.
  3. If a message asks for your device passcode or to Trust This Computer, follow the onscreen steps.
  4. Select your iPhone, iPad, or iPod when it appears in iTunes. If your device doesn't appear in iTunes, learn what to do.
  5. If you want to save Health and Activity data from your iOS device or Apple Watch, you need to encrypt your backup: Select the box called Encrypt [device] backup and create a memorable password. If you don't need to save your Health and Activity data, you can make a backup that isn't encrypted. Just click Back Up Now.
  6. When the process ends, you can see if the backup finished successfully on the Summary screen in iTunes. Just look under Latest Backup to find the date and time.

See full article from Apple here.

Tip #3 - Excel Pro Series Tip #8 | Hide Spreadsheet Rows and Columns

Sometimes spreadsheets can get very cluttered, but rows/columns will contain information that you still need access to, or are referenced elsewhere, but don't need to be seen. You can use the following steps to hide rows/columns

  1. Select the first column or row in the range you want to hide.
  2. Click Format under the Home menu.