Tag

Microsoft Excel

Microsoft Excel

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.
Power Query Power BI & Fabric Microsoft Excel

Power BI, Excel & GP - SQL sources

The fourth post in the series, showing how to connect to SQL in Power Query (Excel or PowerBI).
Power Query Power BI & Fabric Microsoft Excel

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.
Power Query Power BI & Fabric Microsoft Excel

Power BI, Excel & GP - Starting from scratch

The second post of the series discussing some very simple ways to get started with Power BI or Excel and GP data utilizing items a standard user may have access to.
Power BI & Fabric Microsoft Excel Power Query

Power BI, Excel & Dynamics GP

The first post in a series, an introduction to what I will discuss around Power BI, Excel, Power Query and Dynamics GP data.
Microsoft Excel Microsoft Office

Excel - where did my workbook go?

A #TipTuesday post about Excel and hiding workbooks.
Microsoft Excel Power Query Microsoft Office

Excel Background Refresh & Pivot Tables

A post about Excel and the Enable Background Refresh setting as it relates to Pivot Tables.
SmartList & SmartList Builder Microsoft Excel

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 post about two options for copying budgets in Dynamics GP.
Microsoft Excel Microsoft Office

Excel tip - is X in the list?

A tip in Excel for data validation where the out-of-the-box data validation may not be suitable. This example is validating using COUNTIF to validate data input.
You've successfully subscribed to JenKuntz.ca
Great! Next, complete checkout to get full access to all premium content.
Welcome back! You've successfully signed in.
Unable to sign you in. Please try again.
Success! Your account is fully activated, you now have access to all content.
Error! Stripe checkout failed.
Success! Your billing info is updated.
Error! Billing info update failed.
Press ESC to close.