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 Dynamics GP databases in 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.
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & Dynamics GP
Learn about using Power BI to report on Dynamics GP data, starting with some basic approaches to getting started.
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 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
Learn how to copy budgets in Microsoft Dynamics GP with this step-by-step guide for streamlining your budget management process.
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.
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.