Latest Posts
How to Remove Table Formatting in Excel 2016
When using Excel today, I hit a roadblock and found a solution that I want to share. Here’s some back story to give it context: The Back Story: Our General Manager, Darren, asked me to track down the Excel workbook we used last year to determine which clients receive Christmas Cards and then create a mail merge to print labels with their addresses to use on the card …
Read onWhy I’m Using an Excel 2016 Spreadsheet to Manage Data
As I have only blogged about Excel seven times since I created this blog in 2013, I felt the need to give you some context around why I am using it more. Also, I’m going to be using the same spreadsheet in my screenshots, and some of you savvy readers may, be shaking your head …
Read onWhat Happens in OneNote 2016 When You Rename a Folder Where a OneNote Notebook File Lives
I use folders in my OneDrive for Business to help me manage my sharing permissions. I want it to be very clear what should be shared, and what should not, for example my private Microsoft MVP NDA Notebook. Recently I realized that it would be easier to have all my Notebook-related folders together in one bunch. …
Read onWhat Happens When You Move a OneNote Notebook Before Closing the Notebook in OneNote 2016
When I knew that we were planning a migration to SharePoint Online at work, I read up feverishly on everything Microsoft posted about best practices. It was clear that closing Notebooks in OneNote 2016 was very helpful for a seamless experience for end users. However, I’ve been curious about what would happen if a OneNote Notebook was …
Read onHow to Attach Files Stored in SharePoint into an Email in Outlook 2016
In the past, to attach a file stored in a SharePoint site, we’d have to open SharePoint in the browser, navigate to the file stored in a library in a site, download it to the desktop, then drag it into the email. And if you wanted to attach multiple files, you’d have to download each file …
Read onHow to Set Up Connected Services in Outlook 2016
There’s a new way to attach files stored in SharePoint into an email using Outlook 2016. The first step is to make sure Outlook is connected to SharePoint so the two systems can talk to each other. Here’s how: How to Set Up Connected Services in Outlook 2016: Step 1: Open Outlook 2016. Step 2: Click on …
Read onCan OneNote Be Used to Create Print Documents?
I recently appeared as a guest on Tech Talk with tech evangelist Alan Perry , a radio show on radio station CFAX 1070, focused on “keeping [listeners] current on the latest technology, and help [them] overcome any tech issues while keeping hackers and scammers at bay.” I was asked by my friend and fellow MVP Joel …
Read onWhat Version of OneNote Am I Using?
There are three different versions of Microsoft OneNote that you may be using: OneNote App OneNote 2016 Desktop App OneNote Online #1 – If you are not sure what version of OneNote you are using, check the OneNote icon: OneNote 2016 Desktop App – Free download from Website – here (Remember to click on Windows …
Read onWhat’s New Button in OneNote App (Ink Effects)
Another OneNote feature that is only available in the OneNote App is the “What’s New” button. When I lived my entire OneNote experience in OneNote 2016 (and 2013), I was missing out on all the New Features only being released in the OneNote App. Take a look: Click on the hamburger (or pancake stack) icon. …
Read onConvert to Shapes Button in the OneNote App
Another OneNote feature that is only available in the OneNote App is the Convert to Shapes button. It that allows you to transform lightly sketched shapes that you draw in OneNote into precision-sharp shapes. It’s pretty neat, but I rarely use it for business, but it can come in handy for sketching rough wireframes. …
Read on