Stop Excel from opening “Book1”
This #TipTuesday post is about a minor irritant which is how to stop Excel from opening a blank workbook and enable the start screen instead.
Microsoft Excel
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & GP – SQL sources
A post in the series that covers connecting to SQL directly in Power Query.
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & GP – Data Access
The third post in the series, discussing data access considerations and options to securely handle your data in a report.
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & GP – Starting from scratch
The first part of my series around Power BI, Excel & Dynamics GP begins with some of the basics, and a way to start learning Power Query, starting from scratch.
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & Dynamics GP
Details about a planned series of posts on Power BI with Dynamics GP.
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 SmartList & SmartList Builder
SmartList Export Options
A tip about using the Export Options feature in Dynamics GP to automate some of the Excel steps after exporting a SmartList.
Dynamics GP Microsoft Excel
How to copy budgets
A #TipTuesday about how to copy budgets in Dynamics GP.
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”.
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.