Close

Not a member yet? Register now and get started.

lock and key

Sign in to your account.

Account Login

Forgot your password?

Office: Word, Excel, Outlook…  // Office Apps like Word, Excel, Visio, Outlook, Project, Powerpoint, 2003, 2007 and 2010

SOLVED: Outlook Not Showing Presence Icons From Skype – Lync

If your Outlook is not showing the Presence Icons (Green, Red, Blue… squares beside names) there are several possible issues: UPDATED January 18 2017 – If you have Mitel MiCollab make sure you read the item 1 AND item 5. 1 – REGISTRY POINTS TO SOMETHING OTHER THAN SKYPE – LYNC This was my issue.  […]

Read more...

SOLVED: GPO To Block Macro’s On Local PC But Not File Shares

Macros in Word, Excel and PowerPoint used to be one of the most common attack vectors but they largely died out near 2010.  In 2016 they are being used aggressively in Crypto/Ransomware attacks and you may want to disable them.  Specifically, they are often sent in email attachments. Word / Excel / PowerPoint 2013 and […]

Read more...

Video: SOLVED: How To Use Flash Fill in Excel to Separate Numbers From Text

If you have messy data that includes both numbers and letters in the same cell but want to separate the numbers from the letters, you can use Flash Fill.  Flash Fill is built into Excel 2013, 2016 and presumably every future version. Flash Fill typically populates cells automatically (like and autocorrect function) but if the […]

Read more...

SOLVED: How To Invert a Table In Excel (Swap The Columns and Rows)

If you want to invert (swap the columns for rows) using Excel 2007 through Excel 2016, you can use the TRANSPOSE function. In Excel, select all of the data you are interested in, right click select COPY Right click on an empty cell elsewhere in the same or a different worksheet Select PASTE SPECIAL > PASTE […]

Read more...

SOLVED: How Disable CONVERSATION VIEW in Office365 Webmail OWA and Outlook 2016

Conversation View was a pretty neat idea that I thought I would really like when it was released in 2013.  The idea of bringing all of the replies into a single thread in Outlook sounded great.  In practice I HATE IT because I find it much harder to find individual messages and because if you […]

Read more...

Video: SOLVED: How To Check / Release Office365 Quarantine Email Messages

If you have ever not received an email that you know was sent but did not bounce back to the sender, it might be that the backend server has marked it for deletion and put in the Quarentine.  Microsoft, and all good companies, have email filtering that saves you from the most aggressive spam.  In […]

Read more...

Video: SOLVED: How To Use Negative Search Terms In Outlook

If you want to filter out some results from a search in Outlook, you can use a ‘negative search term’.  It Outlook that negative term is NOT.  It has to be in capital letters.  That is the ‘gotcha’ that most people screw up on if they know about the use of NOT in Outlook. Filtering or […]

Read more...

SOLVED: How To Filter or Select or Remove Rows in An Excel Table Based on A Cells Contents

If you have an Excel table with a number of ROWS you want to have selected and removed based on the contents of a cell, you can use the SORT & FILTER editor.  It is very easy to use. Simply click on the column you want to evaluate On the HOME tab click  SORT & […]

Read more...

SOLVED: Video: How to Separate Numbers From Letters In an Excel Text String

UPDATE: Oct 6 2016 – Before you spend a lot of time on creating a formula to separate text from numbers in Excel, watch our two minute video on how to use Excel’s little used but totally awesome FLASH FILL function to do this work for you. ___________________________ If you have a column of data […]

Read more...

SOLVED: Video: How To Change Outlook Attachments From Linking to SharePoint OneDrive

If you are attaching files from your Office365 Onedrive Sharepoint cloud storage using Outlook 2016 you will find that it provides a lovely drop down showing you your recently edited files.  If you select files from that list and they are stored on OneDrive / SharePoint what it will actually attach is a lLINK to […]

Read more...

SOLVED: VIDEO: How to Select Copy Paste Only The Visible Cells in Excel

If you want to select copy paste only the visible cells in Excel: In Excel 2007, 2010, 2013 or Excel 2016, select the cells you are interested in On the HOME tab, click SELECT GOTO Click GOTO SPECIAL Click VISIBLE CELLS ONLY Right click on the cells you selected in step 1 and click COPY […]

Read more...

SOLVED: How to Disable OneNote From Automatically Starting and Putting an Icon in Notification Area

Having OneNote start up by default everytime you sign into Windows is obnoxious.  If you want to get rid of the OneNote icon in system tray / notification area permanently: Launch OneNote Click FILE Click OPTIONS Click DISPLAY uncheck PLACE ONENOTE ICON IN THE NOTIFICATION AREA OF THE TASKBAR Have a nice day   Share […]

Read more...