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?
Learn how to unhide Excel workbooks that have mysteriously disappeared from view and prevent accidentally hiding them again.
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
Master essential Excel navigation shortcuts to move efficiently through worksheets, select data ranges, and boost your productivity.
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
Learn the Corner Copy shortcut in Excel to quickly fill formulas and data down columns – a time-saving tip every user should know.
Dynamics GP Microsoft Office
Dynamics GP & Office 365
A post about converting from Office 2016 to Office 365 and some issues 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
Learn how Excel’s Flash Fill feature automatically detects patterns in your data and fills columns, saving time on repetitive formatting tasks.
Microsoft Excel Microsoft Office
Upload Pending issue in Excel with OneDrive
Learn how to fix the frustrating “upload pending” error that prevents Excel files from syncing properly with OneDrive and SharePoint.
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.