Dynamics GP Email – Login Failed error
Troubleshooting the error “Login Failed: check your login information and try again”, for the Exchange Log On prompt in Dynamics GP.
Dynamics GP Microsoft Office
Microsoft Office
Remove all notes in PowerPoint
This post contains a tip about how to remove all notes from PowerPoint slides instead of removing them one at a time.
Dynamics GP Microsoft Office
Issues with Word Templates
A post about some issues with Word templates and Microsoft Dynamics GP relating to 2020 Microsoft Office updates.
Microsoft Excel Microsoft Office
Excel – where did my workbook go?
A #TipTuesday post about Excel and hiding workbooks.
Microsoft Excel Microsoft Office Power Query
Excel Background Refresh & Pivot Tables
A post about Excel and the Enable Background Refresh setting as it relates to Pivot Tables.
Microsoft Excel Microsoft Office
Excel tip – is X in the list?
A #TipTuesday for Excel about how to tell is something is in a given column or table, for validation scenarios.
Microsoft Excel Microsoft Office
Excel Navigation tips
A #TipTuesday post about Excel navigation shortcuts.
Microsoft Excel Microsoft Office
Excel’s hidden gem – IFERROR
This #TipTuesday post explains the fantastic formula IFERROR and how it can help return meaningful data to users.
Microsoft Excel Microsoft Office
Excel VLOOKUP – numbers as text & vice versa
This #TipTuesday is about looking up numbers in text and text in numbers when the data types are not matching.
Microsoft Excel Microsoft Office
Excel tip – “corner” copy
This #TipTuesday post is about one of my favourite shortcuts in Excel: “Corner Copy”.
Dynamics GP Microsoft Office
Dynamics GP & Office 365
This #TipTuesday is a post about converting from Office 2016 to Office 365 and some of the issues one might experience with email functions in Dynamics GP.
Microsoft Office
Outlook credentials issue
This post is about credentials in Outlook for Office 365 and having difficulties with Outlook recognizing my email address.
Microsoft Excel Microsoft Office
Excel Paste Special – Operations
This #TipTuesday post is how to Paste Special with a multiply or divide operation to quickly change the sign on a set of data.
Microsoft Excel Microsoft Office
Excel tip – copy & paste unique values
This #TipTuesday is for Excel users, and it is a tip about how to copy and paste only the unique values from a list.
Microsoft Excel Microsoft Office
Flash Fill in Excel
A #TipTuesday post for Microsoft Excel, and how the Flash Fill feature works.
Microsoft Excel Microsoft Office
Upload Pending issue in Excel with OneDrive
This post is about the annoying “upload pending” issue in Excel with OneDrive.
Microsoft Excel Microsoft Office
Cool Excel Tip – dates without holidays included
A post about some formulas to help generate dates without holidays included in the calculation.