Any joy with the follow up for getting back to all data if blank and selecting multiple regions?
@mansoorsuhail320626 күн бұрын
Thanks a lot for this beautiful teaching and great way of explanation for beginners to can understand easily
@hashmiyoosuf7252Ай бұрын
boycott Wix
@luigibru8677Ай бұрын
Perfectly explained
@qianli9543Ай бұрын
After merge queries, the data is not in the sequence anymore. How to solve it?❤
@Hurmali1Ай бұрын
Looks like the slicer function??
@karnikkalani417Ай бұрын
I dont get the option to add the other Pivot table what should I do
@mj-ls7qr8xp3nАй бұрын
Informative video! Rather than all the clicking on this and that - why not just assign the wanted text to a shortcut abbrev like theme or a3 or any quick combo that will insert the text instantly.
@rajeevgosavi4514Ай бұрын
Thanks for sharing such a great technique by making it appear so simple. Could you please share practice sheet to follow along.
@bharathiputti6776Ай бұрын
How to do this in Google sheets
@thehonesttruth88082 ай бұрын
How do I add a phrase at the beginning of each paragraph for a section in a report?
@paulsteel87392 ай бұрын
So much easier in 2007, just create some menu options, so thank you for the video
@orsomethingorno2 ай бұрын
Really well explained -- so far I'd made use of the data model functionality for the efficiency of data storage (can process millions of rows of data effortlessly) but I hadn't understood how the relationships work -- it's going to simplify my queries significantly as I don't need to use clumsy conditionals to process data into a better form -- I can just effectively do a lookup by bringing other tables into my data model.
@georgefandamu51152 ай бұрын
how can you match the positive and negative amounts in excel power query
@johnowen27562 ай бұрын
I'd set the rule to reply to the subject of the email you send originally. Chances are they'll reply to that first. Then an extra rule to put those replies in a specific folder to review later
@ALAORYT2 ай бұрын
Excellent, Congratulations.
@amerigo372 ай бұрын
How come I can't see Co-Pilot in the Home ribbon of my 365 Excel?
@NahidulIslam-rz6pf3 ай бұрын
Thank you is not sufficient. Thank you. Please keep on doing this. It is really helpful.
@bayareacali3 ай бұрын
THANK YOU!
@annettefreeman86713 ай бұрын
I cannot give this video ENOUGH thumbs up!!! Thank you for explaining this the way you did. It made my life so much easier!
@piyushchikara69454 ай бұрын
do you need microsoft office subscription for adding data in powerpivot table
@thescorpionstrikes4 ай бұрын
can you restrict editing? I'm worried about someone accidentally deleting or overwriting something important! thanks for sharing!
@kevinamalemba19974 ай бұрын
Wish there was exercise files for practice. Good tutorial
@AlexeiAnisimov4 ай бұрын
Thanks for that ! The way you explained the link with SharePoint here finally settled it for me how this will work with teams also ..
@tutsecret4994 ай бұрын
Here is the scenario: I have master data table, and the another table is Countries and Race. The master data has several columns + countries, with the Race column with blanks. So when I receive new data set I paste it in the master data table replacing the previous/old data and I have to place the race related to each country. Some rows don't have country because not all the individuals are foreigners. My question is after all these queries you set up, if I delete the old data from the master, paste new data set, will the query updating by refreshing, or I have to set up the whole process making the queries? What should I do with the Country Column that has blank. Should I trick it? putting type blank on the Country row and put on the Race column from the Countries and Race list as 12-Unknown? then after merging I would get rid of the blank texting. There are 100, 1000 rows where you don't want to type the race manually or use combo box with excessive clicks and select the race that hurt your hands causing injuries.
@GlitzandGlam554 ай бұрын
This was very helpful. Is there a way to force send emails immediately if you'd like?
@PaulJakob4 ай бұрын
Great video. If I have some dark background slides and want default text to be light but then some light background slides and want dark default, is that possible?
@rrpprp5 ай бұрын
Incredibly helpful, thanks!!!
@Wrenhowsway5 ай бұрын
Can you do this with an email alias?
@andracoisbored5 ай бұрын
I actually learned some new tricks! like the subpage drag. thank you :)
@yamenyehia18315 ай бұрын
Thank you for this informations
@davidsanchez-bu9un5 ай бұрын
Hi, useful video. Is it possible to save the search by using different aspects, like not read + a specific category? When I click on a different criteria, the previous one will be unflagged. Thanks
@duanerobertson82005 ай бұрын
😋 Promo`SM
@bunnyqb25 ай бұрын
wowww... very useful
@sumanthvijjiindia5 ай бұрын
Nice and easy to understand.
@basiclackadaisic5 ай бұрын
DUDE. Absolute lifesaver. Sitting there reformatting Jasper AI's wack af code for hundreds of product descriptions that would take 10 people a month to write (and I'm 1 person) without Jasper takes SOOO LONG even with the replace tool. Your video made it 1 button. A+++ video.
@nattygains29556 ай бұрын
When I create a pivot table from power pivot it always shows up blank. How do I fix this?
@deepeshprasad2396 ай бұрын
Look who is back, thanks Neil
@MuscaDom16 ай бұрын
You saved my life I spent a lot of time trying to figure a workaround. This will work. Very helpful thanks.
@natashaspice26556 ай бұрын
Thank you for sharing, it worked for me. Keep sharing your knowledge 😊
@mollanch6 ай бұрын
Can i hire you for an hour to help me with setting up a rule or condition in outlook 365?
@innab60516 ай бұрын
I've finally found the perfect way to mirror a bar chart! Thank you!!!
@rakesh4n6 ай бұрын
The video is really a great help to many working professionals and helped me a lot. Thank you.
@TheRedTbone6 ай бұрын
Surely it is quicker to read the csv in with power query as in the video, format, then load the whole table, then user a slicer for region? I know the table is large but excel handles millions of rows but its a lot simpler and deals with any new region.
@shaneq19326 ай бұрын
Another excellent video, logical examples and clear delivery. Thank you so much
@dhawalghia7 ай бұрын
Hi team, thanks for this video. I need one help. If some one sends me a request and i want to send him an auto email reply saying "Hi we have ack the receipt of your mail. Someone from the team will revert on your request. Kindly note the ticket number 0001" can we automate this and once the ticket is closed then he will get the email "Hi your ticket number 0001 has been closed". How can we do this using excel and outlook ?
@user-jm4xq4vy9l7 ай бұрын
Thank you, It was great!
@ai_is_a_great_place7 ай бұрын
Vstack just blew my mind!
@delgadoii8 ай бұрын
This was very helpful, thank you for taking the time. Much appreciated. 🙏
@OswinAriaSuryawinata8 ай бұрын
Thanks a lot for the video.. Could you include the link of the file, please?