Awesome tips. The new ones to me: 1- End of Week Day, and 2- Bringing back the formula wizard. Even the tips I knew, I've already forgotten them. 😅 Thank you Wyn. 🤝 👏
Awesome 👍 tricks. I have a question whenever I add a new column need to make convert column format as text. Can you please let ke know how to set as text for new columns too? Actually I make a monthly report with every month so i. This case add a column for next month and than convert as text for do some calculation.
Normally if having multiple months across columns I would be unpivotting them into a single column for easier use in analysis. Is that something you want to avoid?
@@AccessAnalytic No I am not avoid. I m using unpivot for sum but before unpivot need to convert column as int. If any steps to do for get auto all columns and set as int when I add a new column in existing table? Sorry in my query I used text.
Extremely helpful!! Thanks for sharing these tips 🙌🏽🙌🏽🙌🏽
You’re welcome.
Neat and precise. Like it =) Especially this ignoring case.
Cheers
Awesome. And whenever I see that word, I now hear it in your voice 😀
😆
Gr8 tips will be very useful. Could you pls add some more.
Great. Here’s a couple of older video
th-cam.com/video/D_hQQUebPyA/w-d-xo.html
th-cam.com/video/Jwts3JyJCNs/w-d-xo.htmlsi=u1pyOQri9Ocios0P
Thank you for the nice tips,,, we are looking for this type of tips all time, so we are waiting more from tips and tricks from you.
You’re welcome.
Great tips as usual, I hope to remember them when I need them 😀, at least filter I won’t forget it as it’s the most one that I use 😀
Thanks, yes I often refer to these videos as I forget all the time!
Absolutely perfect ! Thanks a lot.
You’re welcome.
Awesome tips. The new ones to me:
1- End of Week Day, and 2- Bringing back the formula wizard.
Even the tips I knew, I've already forgotten them. 😅
Thank you Wyn. 🤝 👏
Cheers for taking the time to let me know you found it useful
nice trick as always mate.
Thanks 🙂
Super tips¡¡¡, Thanks for sharing
No worries, I appreciate you taking the time to let me know you found it useful
Awesome!
Cheers !
Brilliant
Thank you
Awesome 👍 tricks. I have a question whenever I add a new column need to make convert column format as text. Can you please let ke know how to set as text for new columns too? Actually I make a monthly report with every month so i. This case add a column for next month and than convert as text for do some calculation.
Normally if having multiple months across columns I would be unpivotting them into a single column for easier use in analysis. Is that something you want to avoid?
@@AccessAnalytic No I am not avoid. I m using unpivot for sum but before unpivot need to convert column as int. If any steps to do for get auto all columns and set as int when I add a new column in existing table? Sorry in my query I used text.
I haven’t seen a good method for doing this yet. I would do my calculations after Unpivotting
When pivot column and some column not contain value give me errors, how can i save columns that not contain value??
Maybe this video will help
th-cam.com/video/Tzv7jZ9WjAM/w-d-xo.html