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.
Personal Miscellaneous

New Year's Resolutions 2020

A look back at 2019 and forward to what 2020 might bring.
Miscellaneous

Top 10 Blog Posts from 2019

A look at my top 10 blog posts from 2019 compared to where those same posts hit in 2018.
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.
SmartList & SmartList Builder

SmartList Tips - search

A #TipTuesday post about how to search in SmartList including using generic date filters, case sensitivity, field comparisons, and other more advanced options.
SmartList & SmartList Builder

SmartList Tips - favorites

A #TipTuesday post about working with favorites in SmartList.
SmartList & SmartList Builder

SmartList Tips - working with columns

This #TipTuesday post is about working with columns in SmartLists.
SmartList & SmartList Builder

SmartList Tips - printing & exporting

This #TipTuesday post is about SmartList printing and exporting.
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.