Відео

Download a copy of the file used in this video: theexceltrainer.co.uk/excel-pivot-table-calculated-fields/

yes of course it was helpful Mike! Thank you - nice to see the big MVP plaque as well - congrats 🐼

Helpful as always, thanks Mike 😊

Can we use this for ipad 10

Thank you SO MUCH!

Thank you Mike for making this video specifically to answer my question! However, being new; I don't understand how the formula seemed to magically apply to B3-B7 at the 3:36 mark. Did you have to use the formula =SUBSTITUTE(ARRAYTOTEXT(A2.[Official language])," language","") and then when applying to B3 to B7 change the A2 to A3 then A4 etc. Or is there a simpler way to apply it to those columns? Sorry, just not connecting the dots. I really appreciate your teaching!

Thanks Mike! Hope you have an Excel-lent day as well.

Hi Mike another interesting demo - thank you 🙏🐼🐼👍👍

Thanks Mike 😊

man... You are a savior sir. Amazing! Thanks a trillion!

ChatGPT could not help me, Mike Thomas could :) Thank you

Hi Mike, thank you for this video, very helpful! What is the best practice for saving old data transferred to Excel (before you update with new week’s data)? Just copy and paste to a new worksheet or is there a better way?

Thank you very much for the clear explanation. That's what I was looking for, and unexpectedly just solved my problem. With VBA you can just use Workbooks.Open() with that URL, nice!

Great video. I love method 4.

Instead of hiding qryMonth sheet you can just delete it and it will be a connection and still work

Thank you Sir. I needed this today😊

Useful information, i didn't know there was a 15 digit rule in xl

Thanks Mike, very well explained. That's really useful 😊

Thanks a lot, Mike. This is super useful.

Fantastic! Thanks a lot! Neither ChatGPT nor Gemini AI was able to give solution without VBA (which is restricted in our organization for security reasons).

hi sir how are u ..i have try this on window 11 and i am using excel 2024 version ...but when i put image in cell and image is ok but when i save the file and close it and reopen it the image is all gone and show the error massage ...kindly guide me how i solve this error

Hello, does this refresh in the background without having to open the file?

This is exactly what i was looking for everyone else was just going round the bush

Thank you mike!!

Just confirming, the map would be static. One could change the locations, but the map will always stay the same. Is that accurate?

You are awesome!! Thanks for such a nice explanation!

I was specifically looking for a solution to use on Tables. Fortunately I discovered a section of the "View" tab called "Sheet View" where I was able to do exactly the same thing without converting my table to a range!

Very useful, thanks Mike!

Hello and thank you for this information. I oversee a large department... I use M365 excel web version, which I share with my team through Microsoft Teams... I have a large document with a tab for each employee (47), the data in those tabs is displayed in a dashboard tab for the director to see the departments standing... I need to share the tabs with each individual employee along with the dashboard, but I need to prevent them to see any other employees information... #1. Would I be able to do this with the web version? #2. would I be able to accomplish any level of protection in the M365 excel web version? If not, #3. would I be able to set up the excel workbook through the desktop version, secure it (hidden sheets, password protection) and then upload to MS Teams to share with the team and allow every employee to see their tab while updating the data every month? Thank you...

Hi Mike, great presentation once again! Newbie question. On the sheets with Language cells, when I have the geography pull down and select official language, the cells fill with not only the "language" of the country but then has the word "language" immediately after. So for instance, for Belgium it has in the language cell Dutch language. How would I convert those to just the language? So it just had "Dutch" not "Dutch language". Thanks.

Thanks. Mike 😊

Extraordinary video sir

Can you display a slicer option without using pivot table. I use slicers in a table, but do I need to create the PivotTable?

Glad to see some Excel on Mac specific content. Thank you Mike!

Thank you Mike🎉🎉 you helped me a lot to fix this problem since other videos are all suggested to use wizard which is no doubt disappeared in excel for Mac nowadays. THANK YOU again for your so many professional tutorial videos ❤❤🎉🎉

Thank you, very helpful. Quick question; is it possible to have the cell value show "All" when all values in the slicer are selected ? could we work around this with a formula?

I gave a like and subscribed, unfortunately I still have my issue. I am new to Macros and I work with Windows in work and use Cells.EntireColumn.AutoFit but I couldn't find that in your file. Am I doing something wrong here?

Amazing. Thank you! I was trying to build out the steps to creating dependencies in a gantt and this helps a lot!

Thank you!!!

Nice Video Mike! Finally found someone who posts informative video for Excel on Mac!!!

Thanks Mike. Nice to see how far Excel for the Mac has come.

Thanks Mike 😊

1. View code; 2. Insert this "Private Sub Worksheet_Activate() End Sub;" 3. Done!

Not sure how I managed to miss watching and commenting last week but this is very interesting and helpful so thanks 🙏🐼👍🐼😎

Perfect! Very clear and concise. You've saved me hours....thank you!

Bu eklenti excel kurdum. Ama URL yazdıpımda çalışmıyor. Neden olduğununu çözemedim. Bir ayar yapmak gerekiyor mu? Yada bu eklentinin güncel haline nereden ulaşabilirim? Size hata kodu atsam bana yardımcı olabilirmisiniz? Şimdiden teşekkürler

my excel is opening using browser ! and i can't select them with holding ctrl

Is this a one time use mail merging method? I'm trying to save a word doc template that contains the mail merge linkage for future use too. I tried other methods but I wasn't able to save it for future use. My goal is to update the source excel file periodically and reprint the mail merge doc with new data and updates

👌🏼

Thank you! Solved a problem I had in moments!