Knack Training (@KnackTraining) header
Knack Training (@KnackTraining) profile picture

We make businesses the best at what they do by providing individualized software training.

Orlando, FL
Joined July 2017
Don't miss out on the opportunity to enhance your professional development this June with our specialized summer programs created for educators. Our first training is tomorrow with @DeniseTsamouris! Secure your spot now by using this link to register: buff.ly/3wxMcFV
247
New #copilot webinar tomorrow, 2-3 Eastern. Register free today! knacktraining.arlo.co/w/even…
1
349
We always develop our materials first in #OneNote, then convert to other formats. Being able to export an entire section is very helpful for that.
1
1
291
Did you know that Find & Replace works on a lot more than just text? If you click the More button, you can find and replace using wildcards, formatting, or even special situations like returns. #tipsandtricks
1
188
Are you still using #vlookup, or even Index and Match to combine and compare tables? Here's a how-to on the new #xlookup function in #Excel youtu.be/mUy1qpHMdbE?si=wgUr…
1
180
As @NinaBaliga says in this talk, we're all going to experience some disability in our lives; on top of that, accessible design is just good business! #accessibility youtube.com/watch?v=2115c0GL…
68
Conditionally formatting your Inbox is easy, and it helps you identify the most important emails quickly.. youtube.com/watch?v=nZetQ3HA…
89
The latest episode of the @AskEvOffice podcast is with Alan Murray of @Computergaga1 - we talk about how functions like UNIQUE, FILTER, and SORT will change the way you work in @msexcel! buff.ly/3eJ7Ed8
1
2
One of @msexcel's new super powers, courtesy of #PowerQuery - Text to Rows!
Did you know butterfly charts can be done with two Pivot Charts back-to-back? #Datavisualization youtube.com/watch?v=m8U7Se0B…
1
1
#PowerQuery in @msexcel is capable of not only Text to Columns, but Text to ROWS! This is invaluable in a lot of unfortunate situations. youtube.com/watch?v=nwxVHvY4…
Replying to @iaapflsatlantic
@iaapflsatlantic - you're going to want to have @Outlook power tools and @msonenote in your toolbox: youtu.be/LhADA3mYiZM
Next Saturday, @KnackTraining presents @Outlook Triage: Inbox Automation and OneNote Integrations, register today.
In 2020, you should be using #PowerQuery in @msexcel for hundreds of situations. Here's a powerful example - pulling a live, filtered segment of a huge dataset: youtu.be/q2_FWbZJv3Q
Just an awesome @msexcel #shortcut - insert the current date with [CTRL] + [;]