Perfectly explained

After merge queries, the data is not in the sequence anymore. How to solve it?❤

Looks like the slicer function??

I dont get the option to add the other Pivot table what should I do

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.

Thanks for sharing such a great technique by making it appear so simple. Could you please share practice sheet to follow along.

How to do this in Google sheets

How do I add a phrase at the beginning of each paragraph for a section in a report?

So much easier in 2007, just create some menu options, so thank you for the video

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.

how can you match the positive and negative amounts in excel power query

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

Excellent, Congratulations.

How come I can't see Co-Pilot in the Home ribbon of my 365 Excel?

Thank you is not sufficient. Thank you. Please keep on doing this. It is really helpful.

THANK YOU!

I cannot give this video ENOUGH thumbs up!!! Thank you for explaining this the way you did. It made my life so much easier!

do you need microsoft office subscription for adding data in powerpivot table

can you restrict editing? I'm worried about someone accidentally deleting or overwriting something important! thanks for sharing!

Wish there was exercise files for practice. Good tutorial

Thanks for that ! The way you explained the link with SharePoint here finally settled it for me how this will work with teams also ..

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.

This was very helpful. Is there a way to force send emails immediately if you'd like?

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?

Incredibly helpful, thanks!!!

Can you do this with an email alias?

I actually learned some new tricks! like the subpage drag. thank you :)

Thank you for this informations

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

😋 Promo`SM

wowww... very useful

Nice and easy to understand.

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.

When I create a pivot table from power pivot it always shows up blank. How do I fix this?

Look who is back, thanks Neil

You saved my life I spent a lot of time trying to figure a workaround. This will work. Very helpful thanks.

Thank you for sharing, it worked for me. Keep sharing your knowledge 😊

Can i hire you for an hour to help me with setting up a rule or condition in outlook 365?

I've finally found the perfect way to mirror a bar chart! Thank you!!!

The video is really a great help to many working professionals and helped me a lot. Thank you.

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.

Another excellent video, logical examples and clear delivery. Thank you so much

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 ?

Thank you, It was great!

Vstack just blew my mind!

This was very helpful, thank you for taking the time. Much appreciated. 🙏

Thanks a lot for the video.. Could you include the link of the file, please?

Hello how do you edit or change a marked entry? If you made a typo or don't like the category?

Why practice excel sheet is missing?🙄

very helpful video thanks bro