10 Excel Things You Should NEVER Do and What to do Instead

Рет қаралды 587,243

Күн бұрын

Bad Excel habits are easy to pick up when you learn on the job, but they can make you inefficient. These are the 10 worst habits I see, but thankfully they're easily avoided.
🔻 DOWNLOAD the Excel file here: www.myonlinetraininghub.com/1...
LINKS TO SOLUTIONS
- Fix non-tabular data with Power Query: www.myonlinetraininghub.com/p...
- Fix dates formatted as text: www.myonlinetraininghub.com/f...
- Use Power Query to get data instead of External Links: • How to easily automate...
- OFFSET function for dynamic SUM ranges: www.myonlinetraininghub.com/e...
🎓 LEARN MORE: view my comprehensive courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Introduction
0:12 Merge & Center Cells
1:49 Non-tabular Data
3:21 Dates Formatted as Text
4:26 External Links
5:40 Formatting Ranges
7:07 Formatting to Encode Data
8:10 Formatting Colours
8:33 Cells Containing Multiple Records
9:13 Cells Omitted from SUM Formulas
10:34 Old .xls File Types

Пікірлер: 880

@MyOnlineTrainingHub Жыл бұрын

The PROBLEMS with using the CTRL key to select cells around a merged cell: 1. You often don't realise/remember there's a merged cell nestled in the data you're selecting until it's too late. By then you've already tried to select the cells and then the merged cell gets in the way. A waste of time that could be avoided if the cells were formatted with 'center across selection'. 2. You can't use the keyboard to select cells either side of the merged cells, so it's no good for all those keyboard shortcut users. 3. Having to hold down the CTRL key to select non-contiguous cells is more time consuming than just applying the 'center across selection' format in the first place.

@woxz1 2 жыл бұрын

Been years working with excel, but just found out "center across selection". Thank you

@MyOnlineTrainingHub 2 жыл бұрын

Glad I could spread the word :-)

@court2379 2 жыл бұрын

@@MyOnlineTrainingHub Was that an Office pun?.. The question I have, is there a button to add to the ribbon to replace the merge and center with center across section?

@Ancovg 2 жыл бұрын

I also didn't know about ctrl+1

@JatinMaharaj 2 жыл бұрын

@@court2379 Check out this video from MrExcel (link provided from the relevant time in the video): kzfaq.info/get/bejne/nd-lnMJ1ms2ZfX0.html

@EduardoTicianelli 2 жыл бұрын

Same here. My jaw dropped.

@cryptidcage3615 2 жыл бұрын

I was in a job I couldn't stand and asked to do a rotation in another department. Fell in love with the job during my rotation but the one skill was lacking was using excel. Ran across your videos and I love the way you break every skill down and explain the steps. My rotation was a three month only rotation but I noticed many people lacked proficient excel skill so I decided to teach myself. But thanks to the skills I was gaining my three month rotation turned into a year and at the end of the year I was offered a job because of what I was able to do. One week ago I was promoted into a job that requires a minimum of five years of experience to qualify for. It took me half that time and I have never loved a job the way I love this one. Thank you for taking the time to make these videos and doing them in a way that's easy to follow.

@MyOnlineTrainingHub 2 жыл бұрын

Wow, congratulations on your success! Just goes to show what you can achieve with hard work 👍

@andylea5314 Жыл бұрын

Cracking story ! Well done you !

@ronspi 2 жыл бұрын

This is one of those videos that remind me an Advanced Admin Class in Excell. I remember when I was stunned to find advanced features in one of the complex commands and asked: "Is this a new feature?". The instructor replied, "since 1997". Excel is such a huge boatload of functions and possibilities, it can be overwhelming and many don't use more than 1% of the functions anyhow. As a developer, it is always refreshing to see more and more usages for those features and functions. Thank you for the video. Loved it!

@MyOnlineTrainingHub 2 жыл бұрын

Thanks so much, Ron!

@vickieroberts9560 Жыл бұрын

much like our brains...if only we understood HOW to use it. 😁

@stickoutofthemud Жыл бұрын

I love ASAP Utilities. Saves me tons of labor.

@JatinMaharaj 2 жыл бұрын

Centre across selection???? 🤯 I've been Excelling in the stone-age! Plus the other tips and tricks are super-helpful! Thanks Mynda!

@sanandresano01 2 жыл бұрын

this feature also blew my mind

@MyOnlineTrainingHub 2 жыл бұрын

Glad you picked up some new ideas, Jatin!

@sideshowbobby71 2 жыл бұрын

Center across selection!!! That was an amazing tip!!

@alquinn8576 2 жыл бұрын

Center across selection: there is no way I'm falling for this post-modernist vomit. Al Quinn will continue to merge cells while being mindful of and mitigating against the potential pitfalls of doing so.

@hotflashfoto 2 жыл бұрын

If you write or use any VBA in your workbooks, merged cells mess with the code there as well. Where I work, we had to ensure that everyone on our small team that modified any of our many workbooks (over 200) did so using Center Across Selection. When someone forgot, the reports for that day came to a grinding halt!

@themortal1 2 жыл бұрын

This has to be in my top 5 most useful videos ever! We get in such ruts and ways of doing things, we don't realize what a profound impact, such simple changes can make for ourselves and others. Thank you!

@MyOnlineTrainingHub 2 жыл бұрын

Well said, Chris!

@mariaalcala5159 2 жыл бұрын

I actually learned a lot of the Tipps while doing your courses but definitely the merge and center cells is the most annoying thing I usually see in lots of files. Thanks for sharing this video Mynda!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Maria!

@cathyb2204 2 жыл бұрын

Lovely. Thank you for sharing your knowledge.

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure 😊

@grtraders 2 жыл бұрын

Brilliant. Most of them are my pet peeves. Almost all of them, I would say. Been a long time user of excel since the past two decades but never met "center across selection". Just feel happy to keep learning something anew from you. Please keep up the good work. Thanks a lot.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Ravi!

@davidferrick 2 жыл бұрын

This video was worth it as soon as I saw Center Across Selection. :)

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Dayve!

@JohnRohoboth 2 жыл бұрын

I as well wasn't aware of this. Thank you.

@logon235 2 жыл бұрын

Centre accross selection was the option well before cell merging was introduced. Merging has its uses but has side effects as this lady has shown.

@marshalxu8082 2 жыл бұрын

Thank so much for “Center across selection”. It is so helpful!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear!

@ThothWhoWrites 2 жыл бұрын

Tips #2 and #8 are part of normalization in databases. Mynda shows the proper normalization techniques in each case as if this were a database and not a spreadsheet. Bravo. There's nothing wrong with using Excel as a database, in spite of what some people will tell you. Especially if you have a low number of records and if you have issues with getting the know-how to create and use databases (such as in MS-Access) instead. Some people just don't have the time.

@MyOnlineTrainingHub 2 жыл бұрын

Thanks, Scott! Well said 😊

@grrgrrgrr0202 Жыл бұрын

Hard disagree. Excel might be okay for small scale projects. Or as a way to write up your initial batch of data if the alternatives are lacking. But with bigger data, Excel gets inefficient real fast. Not to mention it is way too easy to mess things up. In many cases, Excel is a necessary evil as the managers don't wanna invest into better databases. But that is just incompetence; it doesn't make Excel suitable at all.

@jawadahmadehssan6251 2 жыл бұрын

Thank you for this great content. It really adds value to what we as Excel Users do on day to day basis.

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure 😊

@zonboss 2 жыл бұрын

So much value. Thank you.

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it 😊

@AlDunbar 2 жыл бұрын

Been using excel for a long time, but in a relatively simplistic way. I have long known there was way more functionality than I knew how to use, so it is great to see some of those demonstrated with straightforward explanations. And, at least half of this video is of features I will be able to use, hopefully more effectively than my current workarounds. Subscribed, liked, and following.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Al 😊

@Velisus 2 жыл бұрын

Great refresher on some of these important nuances and even some great new tips as well. Thanks!

@MyOnlineTrainingHub 2 жыл бұрын

Glad you enjoyed it!

@scatton61 2 жыл бұрын

Thank you... I have learned loads

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear!

@Cosmioful 2 жыл бұрын

So many vids claim to solve all your problems in Excel, but this is the first vid in which I actually learned something. Very well explained and paced - thanks!

@MyOnlineTrainingHub 2 жыл бұрын

So great to hear 🙏

@charleschance80 Жыл бұрын

I love your video's so informative and to the point. As always great job and thank you so much for these videos.

@MyOnlineTrainingHub Жыл бұрын

So pleased to hear that 🙏

@tedjohnson64 Жыл бұрын

Just showed my excel guru your first tip and they were quite excited and impressed! Thanks for sharing these tips.

@MyOnlineTrainingHub Жыл бұрын

Great to hear!

@marshallhosel1247 2 жыл бұрын

Informative, thank you!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear!

@ranjanajoshi3099 2 жыл бұрын

Was so much useful! Thank you!!

@MyOnlineTrainingHub 2 жыл бұрын

Glad it was helpful!

@bccabernet Жыл бұрын

Another brilliant video, Mynda! I've been working with excel for years and found I still have more to learn. TY and sharing!

@MyOnlineTrainingHub Жыл бұрын

Thanks so much!

@waynethompson5098 Жыл бұрын

Brilliant information. So helpful. Thank you very much. 😃

@MyOnlineTrainingHub Жыл бұрын

Great to hear!

@goldendice2254 2 жыл бұрын

Excellent job as usual. Thanks a lot

@MyOnlineTrainingHub 2 жыл бұрын

Thanks so much 😊

@Cloudsofa Жыл бұрын

Very helpful. Thank you!

@MyOnlineTrainingHub Жыл бұрын

You're welcome!

@alastairbishop2450 2 жыл бұрын

Excellent video, thank you.

@MyOnlineTrainingHub 2 жыл бұрын

Cheers, Alastair!

@victorrweyongeza8634 2 жыл бұрын

Small Tips but very key, thanks very much for sharing.

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure, Victor!

@bu0sultan Жыл бұрын

This is very useful. Thanks for posting. Keep up the good work

@MyOnlineTrainingHub Жыл бұрын

Glad it was helpful!

@nblack2867 2 жыл бұрын

Not sure how I didn't know about the offset function, but that is incredibly useful. So is the "center across selection" functionality as well. Thanks for this video.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear!

@c.s.m.k5737 Жыл бұрын

Thank you so much for your tutorials. I have found them very useful.

@MyOnlineTrainingHub Жыл бұрын

Glad to hear that 🙏

@canebro1 Жыл бұрын

Well done. Clearly explained without being super long and wordy.

@MyOnlineTrainingHub Жыл бұрын

Thanks for your kind words!

@TheRealStructurer 2 жыл бұрын

Great advices 👍🏻 I knew some but not all, so learned something new today. Thanks for that!

@MyOnlineTrainingHub 2 жыл бұрын

Glad it was helpful!

@lewtabakin 2 жыл бұрын

Great video, thank you!

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure 😊

@ozeroner_OOT 2 жыл бұрын

Brilliant tips. Thanks.

@MyOnlineTrainingHub 2 жыл бұрын

Thanks so much!

@tuanvnguyen872 2 жыл бұрын

This is very helpful, thank for your video.

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure 😊

@wayneedmondson1065 2 жыл бұрын

Hi Mynda. Great video! Thanks for all the useful warnings and solutions :)) Thumbs up!!

@MyOnlineTrainingHub 2 жыл бұрын

Cheers, Wayne 😊

@shoaibwarriah 2 жыл бұрын

This video help alot and I learned about not to Merge Cells and Sum Offset,Conditional Table formatting & Days calculation from Date formatting. Thank alot

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Shahi!

@angelacollins5666 2 жыл бұрын

Thanks for this - glad to see some of my personal fixations mentioned - especially Merge/Centre and External Links. For the automatic updating of rows included in a sum I find it simpler to set my SUMs up to include a blank row and to include that in the sum. e.g. if the data is in A1:A8 the the sum will be in A10 and it will be '=SUM(A1:A9)'. Then if I need to insert a row in the sum I just insert at A9 (not A10) and the sum updates automatically.

@MyOnlineTrainingHub 2 жыл бұрын

Glad you could relate, Angela. Your SUM fix is fine if you're the only person using the workbook and you know never to insert data in the empty row! 😉

@angelaw7055 2 жыл бұрын

These tips are fabulous. Thank you!

@MyOnlineTrainingHub 2 жыл бұрын

You are most welcome!

@Sixstringslust 2 жыл бұрын

Your videos are really helpful & easy to understand, thanks Mynda! I just decided to watch all videos in this channel starting from the oldest one

@MyOnlineTrainingHub 2 жыл бұрын

Wow, thanks so much!

@tha2irtalib343 2 жыл бұрын

Awesome and perfect article , it's really helpful , thanks for sharing.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@stephenbrickwood1602 2 жыл бұрын

Love your work.

@MyOnlineTrainingHub 2 жыл бұрын

Thank you! Cheers!

@humorous2me 2 жыл бұрын

This video is golden for the first tip. Center across selection?!? Where has that been my whole Excel life? Thank you.

@MyOnlineTrainingHub 2 жыл бұрын

:-) glad you liked it, Traci!

@howardOKC 2 жыл бұрын

Wow, the "center across selection", the first tip, already so useful and makes a ton of sense! I haven't gone to tip No.2 yet. Thanks and great video.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear!

@JennTheWriter 2 жыл бұрын

Learned a lot from this one, some of which I am doing. But, other things I had no clue about. Thank you as always!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Jennifer 😊

@wojwoj06 2 жыл бұрын

0:12 Center Across Selection - simply Wow! :) Thank you for this very elegant and proper approach!

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it, Max!

@alistairkirk3264 Жыл бұрын

This video should be mandatory viewing for all accountants. Your point about data that is difficult to aggregate likely being in stored in the wrong shape is spot on. The amount of time I spend re-factoring other people's spreadsheets in Python into 1st normal form so that they can be pivoted! The same thing kind-of applies to merged cells - it's a giveaway sign your data is in the wrong shape. And how did I not know about ctrl-1 after all these years! Thank you!

@MyOnlineTrainingHub Жыл бұрын

Glad to hear you agree 🙏 you might like to try Power Query as an alternative to Python for automating gathering and cleaning data: www.myonlinetraininghub.com/introduction-to-power-query

@justinschlatter4189 2 жыл бұрын

This is really outstanding, thank you so much!

@MyOnlineTrainingHub 2 жыл бұрын

Glad it was helpful!

@paulb9453 2 жыл бұрын

Thank you, your presentation style and video footage are superb, v informative.

@MyOnlineTrainingHub 2 жыл бұрын

Thank you very much, Paul!

@bertblankenstein3738 2 жыл бұрын

Good info, thank you.

@MyOnlineTrainingHub 2 жыл бұрын

Thanks for watching!

@tlnn6598 2 жыл бұрын

EXCEL is my favorite software! I love record keeping and EXCEL makes it easy to organize all your files. Thanks for sharing these tips.

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure :-)

@AlipashaSadri 2 жыл бұрын

Extremely useful! Thanks for making the video :)

@MyOnlineTrainingHub 2 жыл бұрын

Glad you enjoyed it!

@geoffreyschmidt 2 жыл бұрын

Lots of great tips! Thanks!

@MyOnlineTrainingHub 2 жыл бұрын

You are most welcome!

@castor007troy 2 жыл бұрын

This was very useful and very well explained.

@MyOnlineTrainingHub 2 жыл бұрын

Glad it was helpful, Paawan!

@smileycindy 2 жыл бұрын

What a fantastic tip video! Just to learn what you shared in tip #1 alone was worth the watch (but the rest was really enlightening as well.) Thanks for all that info!

@MyOnlineTrainingHub 2 жыл бұрын

Glad you enjoyed it!

@mikefochtman7164 2 жыл бұрын

Very nice. Learned some new things. Going to go checkout your channel right now!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Mike!

@kirrilywelsh 2 жыл бұрын

Great tips. I knew some but definitely learnt something :)

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@germaingyesah5724 Жыл бұрын

Awesome excel navigation. Will use them for work. Thank you

@MyOnlineTrainingHub Жыл бұрын

Great to hear!

@IvanCortinas_ES 2 жыл бұрын

Excellent tutorial Mynda. The example with SUM-DESREF works perfectly in Excel 365 in both cases. Thank you for the tips.

@MyOnlineTrainingHub 2 жыл бұрын

Cheers, Ivan!

@35jays 2 жыл бұрын

Thanks for the tips!

@MyOnlineTrainingHub 2 жыл бұрын

You’re welcome 😉

@tombirkland Жыл бұрын

I just stumbled across this today and it's brilliant. It covers a lot of my pet peeves, but I also learned a lot about Excel I didn't know before--and I thought I was sort of a power user!

@MyOnlineTrainingHub Жыл бұрын

Glad you enjoyed it!

@glecas 2 жыл бұрын

SUPER Useful! I am guilty of many of these myself but now I'm a bit wiser! Thank you so much.

@MyOnlineTrainingHub 2 жыл бұрын

Glad it was helpful!

@slideybackfast 2 жыл бұрын

One of the best videos I’ve watched on excel in a very long time!!

@MyOnlineTrainingHub 2 жыл бұрын

Thanks so much, Simon 🙏

@markman8489 2 жыл бұрын

Thanks Mynda - as unusal my knowledge of Excel has grown after watching this video I like the offset trick with the Sum formula and I need to learn a lot more about Power Query. Also, had a recent issue with external links but after modifying all formulas to use the current workbook, I still encountered this message when opening the workbook. After persevering with the issue for a few days, I opened the Named Manager to modify a reference and was relieved to find a number of external references hiding in there.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Mark! Yes, those pesky external links can hide in all sorts of places including data validation and conditional formatting!

@hoavo4061 2 жыл бұрын

This is very helpful. Thanks.

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it 😊

@rohitkhanna 2 жыл бұрын

brilliant tips !!

@MyOnlineTrainingHub 2 жыл бұрын

Thanks, Rohit!

@muhammadsaddique3634 2 жыл бұрын

Offset funtion in Sum was new for me. Great!!! Thanks

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it 😊

@Martin-jw7xo 2 жыл бұрын

you had me at "centre across selection" - brilliant!

@MyOnlineTrainingHub 2 жыл бұрын

:-) great to hear, Martin!

@hcandts 2 жыл бұрын

This is a video to my heart, I have been trying to explain it to users that they're making life very difficult by using merged cells. I've managed to circumvent most using VBA but it is a p in the a when I run into them Great video (as always)

@MyOnlineTrainingHub 2 жыл бұрын

Hope you can share it with others, Hans 😊

@hcandts 2 жыл бұрын

@@MyOnlineTrainingHub I always point to your site when people ask where they can find clear and concise explanations.

@sorenweisshartmann 2 жыл бұрын

Excellent tips. Thanks

@MyOnlineTrainingHub 2 жыл бұрын

Thanks, Soren!

@betaorionis2164 2 жыл бұрын

Very useful video about very specific Excel issues 👍🏻

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it :-)

@indzara 2 жыл бұрын

Relevant tips. Thanks for sharing. We have come across all these scenarios. The 'dates formatted as text' is the most common one for me. Whenever customers reach out to me asking why formula results are not as expected, the first thing I check is if the date inputs are treated as text. Best wishes.

@MyOnlineTrainingHub 2 жыл бұрын

Cheers, Indzara!

@dearloop1513 2 жыл бұрын

Kindly share Power query for external link

@conniesky5361 2 жыл бұрын

Very helpful. Thanks.

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure, Connie!

@1Chitus Жыл бұрын

Great tips! I fully agree with table formatting (5:50) however, row- and column formatting are internally stored just like that - the (default) format for an entire row or column, and not as the formatting of a million cells for a single column. Still, it's adding formatting to unused cells which can be distracting and look sloppy, so it's good to avoid it where better alternatives are available.

@MyOnlineTrainingHub Жыл бұрын

Thanks 😊

@rabiaouenza6377 2 жыл бұрын

Great video. Thank you

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure 😊

@adamhindle9215 2 жыл бұрын

Some great tips, cheers. Interesting to see how other users tackle problems; some similar, some different. Thanks

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it 😊

@davidroddick91 2 жыл бұрын

I always considered myself to be competent in Excel; but most of these I never knew. This will improve my worksheets significantly! Thank you!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@terjidjurhuus1917 2 жыл бұрын

This was pretty cool, thanks for sharing it with your calm and pleasant voice. :-)

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure 😊

@Rice0987 Жыл бұрын

Thanks for tip with offset function. 😊

@MyOnlineTrainingHub Жыл бұрын

My pleasure 😊

@ernestochavez9560 2 жыл бұрын

There is something, always something, that those ex-"Excel experts" can learn. I learn and enjoy. Thank you, Mynda.

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it, Ernesto!

@countduckula9977 2 жыл бұрын

Thanks Mynda - I learnt a lot from this video.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@BenoitLamarche 2 жыл бұрын

I am very often preaching some of the very same things to colleagues. Now I will simply share this video. However OFFSET was new to me - I’ll watch the video dedicated to it! Thanks and have a great week!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Benoit! Thanks for sharing my video too 😊

@stoggies2421 2 жыл бұрын

I've been through quite a few comments and the biggest hit is the merged cell problem. I never new center across selection existed and the ;;; trick was also new to me. Good stuff.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@jimmysaints3289 2 жыл бұрын

I learned so much from this one video. Thank you!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@sgauntt 2 жыл бұрын

This is awesome, thank you.

@MyOnlineTrainingHub 2 жыл бұрын

You're very welcome!

@nadermounir8228 2 жыл бұрын

Very helpful video thank u for your hard work

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear you liked it, Nader!

@gavdownes100 2 жыл бұрын

Immediate uses. Thank you

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@VladimirKozomara Жыл бұрын

How did I miss this video, plenty of good stuff, Thanks Mynda

@MyOnlineTrainingHub Жыл бұрын

Glad you enjoyed it!

@snicho 2 жыл бұрын

100% Mynda! Absolutely! I sometimes wonder what life would be like if everyone followed these best practices. However, in some twisted way, I'm sure that it would mean that the 'Excel gurus' of the world would be less valued. Great content as always! 😊

@MyOnlineTrainingHub 2 жыл бұрын

😊 the Excel help forums would certainly be quieter.

@seanh884 2 жыл бұрын

Several good tips!

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it 😊

@txkflier 2 жыл бұрын

I learned several things in this one. Thanks!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@JimWhitaker 2 жыл бұрын

Thank you. I learnt something by watching this. The Centre across selection got my attention straight away and the rest of the video kept it. Registration on your website returned a Wordpress error but the registration has been created successfully anyway.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear you found the video helpful. Thanks for the feedback about the Wordpress error. We'll look into it.

@randomrandy3059 2 жыл бұрын

It is crazy to me how much I've learned off the world wide web. Thank you much for this video. I got some bits of useful information. Now to apply this knowledge and get me a job.

@MyOnlineTrainingHub 2 жыл бұрын

Glad it was helpful!

@davidrmohr 2 жыл бұрын

Excel'lent (get it?) tutorial and presentation. I really liked the explanation about putting too much data in a single cell; I've spent a lot of time showing people the benefit (as you did) with keeping the data separated so that it can be better worked with. Keep up the good work. Oh, also, thank you for reminding me about the "center across selection" feature. I had completely forgotten about that one!!! :)

@MyOnlineTrainingHub 2 жыл бұрын

So glad you enjoyed it, David!

@hermo1977 2 жыл бұрын

Hi and thanks for the video. I watched the video on Sunday and on Tuesday I needed an offset function :D

@MyOnlineTrainingHub 2 жыл бұрын

Great timing!

@user-jp5lb1kq3x 2 жыл бұрын

Learned. Thanks

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@ahmedh.a.a.5216 2 жыл бұрын

Thanks! very useful tips

@MyOnlineTrainingHub 2 жыл бұрын

Glad you think so!

@rudiklein 2 жыл бұрын

How is it possible that after decades of intensive advanced Excell usage, you still are able to learn me stuff that is really useful? Like the center across selection! How much more did I miss?! Great video, thanks.

@MyOnlineTrainingHub 2 жыл бұрын

Glad it was helpful 😊

@furtim1 2 жыл бұрын

Great stuff. The center across selection, rather than merge center, is very interesting. I am going to have to see about adding a quick button for that one, rather than doing a menu dive for it.

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it. A shortcut for that is a great idea!