Sales & Marketing
Microsoft office Excel© Spécialiste

Keyboard Metrics III

In the grand tradition of Keyboard Shortcut Metrics and More Keyboard Metrics, here’s this: Procedure 2016 2017 2018 Grand Total MakeComma 20.54% 18.67% 19.01% 19.19% WrapSheetsDown 13.80% 17.15% 9.93% 14.93% WrapSheetsUp 8.60% 15.36% 7.33% 12.16% FillVirtualScreen 10.50% 11.04% 8.42% 10.40% CopyPasteValues 14.00% 4.84% 2.20% 6.54% ShowFormatting 5.85% 5.13% 7.04% 5.68% IncrementDate 4.25% 4.08% 9.77% 5.23% […]

Incrementing Months and Years

As you know, I love keyboard shortcuts. But I hate entering dates. So I created this little helper. In my new accounting system, they also have shortcut keys for incrementing weeks, months, and years. I don’t have much use for incrementing weeks, but I could kick myself for not thinking of the others. Plus Alt+semi-colon […]

Free Table tools add-in

Do you want to be able to rename your Excel tables and columns without breaking existing PowerQuery queries? Do you always change the default name of a new table? Want to have quick navigation to your tables in your workbook? Use my free TableTools add-in Enjoy! Jan Karel Pieterse

Dose journalière d'Excel...

Page d'accueil | Contact