Rather than use the Merge and Center button which destroys a Worksheet's structure, in the Alignment tab for Format, use Center Across Selection for the Horizontal Alignment. This accomplishes the same result visually without breaking the column structure. I prefer using the "IFS" version of the aggregation functions rather than the "IF" version - they allow more conditions and all have the same parameter structure. There's no real need to use the "IF" versions of the functions.
@LearnitTraining
5 ай бұрын
Thanks for sharing!
@ianl1052
4 ай бұрын
Nicely explained and easy to follow using your files. I jumped through to conditional formatting, which was the best place for me personally to start. One tip I learned elsewhere. Instead of dragging the fill handle, you can double click the fill handle providing there's data entered nearby showing where the columns end. That saves a few microseconds. Thanks for your effort.
@LearnitTraining
4 ай бұрын
Thank you for the great tip!
@nairobi203
5 ай бұрын
Although I am using it for years, it is always useful to do some basic training. Best case you know all, else you learn something new. It makes a difference dedicating a time slot, rather than just quick tutorials. Looking forward to watch also the other two episodes.
@LearnitTraining
5 ай бұрын
Thank you for the kind words
@joukenienhuis6888
5 ай бұрын
Thank you for this great basic course. It is always good to review my knowledge in excel. But as I saw it in the beginning there is a difference in pressing Control and a or clicking on the upper left corner, because the last one selects the entire sheet
@KCT102
8 күн бұрын
Subscribed, i love how you have practice files, it is absolutely amazing
@LearnitTraining
7 күн бұрын
Thanks for the sub!
@gandikotavennela7757
3 ай бұрын
Thanks alot!!👏The way you are explaining in detail motivates me to learn more and more....
@LearnitTraining
3 ай бұрын
Glad to hear that
@linda7915
Ай бұрын
Elissa, thank you for your detailed yet simple explanation.
@LearnitTraining
Ай бұрын
Thanks for watching!
@ihabziyad8611
5 ай бұрын
thanks , we need more courses like your courses which is very benefited
@LearnitTraining
5 ай бұрын
More to come!
@d.harrison1570
5 ай бұрын
Thank you. Best Excel training I've had.
@LearnitTraining
5 ай бұрын
You're very welcome!
@d.harrison1570
5 ай бұрын
@@LearnitTraining when does Part II of this come out?
@mohamedmbangura5779
2 ай бұрын
This tutorial of Excel learnit is stunning
@LearnitTraining
2 ай бұрын
Glad you think so!
@tomjun8945
5 ай бұрын
Wonderful video! Very helpful and detailed. Thank you for the content.
@LearnitTraining
5 ай бұрын
You're very welcome!
@goodman-it2qy
6 ай бұрын
Thanks a lot, you bring us very important topics.
@LearnitTraining
5 ай бұрын
You are welcome!
@akshita2akshay2002
5 ай бұрын
Basic to advance all in one 😮 Wonderful!
@LearnitTraining
5 ай бұрын
👍👍👍👍
@rajput09697
5 ай бұрын
@@LearnitTraining❤. Thank you madam ❤
@ojiehkingsley918
3 ай бұрын
For a complete beginner with power bi knowledge? is the series sufficient for the learner? And is there no financial analyst course???
@AnnaOlander-pn3rm
19 күн бұрын
When selecting the merge and center option after attempting to combine two cells, it tells me that "Merging cells only keeps the upper-left value and discards other values". How do you prevent this?
@user-zc5pt8pd7j
5 ай бұрын
Σας ευχαριστούμε για το μάθημα!
@LearnitTraining
5 ай бұрын
Παρακαλώ!
@ankitabegwani9820
5 ай бұрын
There is another video from this channel for excel.. excel for beginners and experts .. should i watch them also?? Im a finance student though!
@LearnitTraining
5 ай бұрын
You definitely can. This video series is going to focus on Excel functions and formulas that are helpful in the finance and accounting world.
@autumnslatest9893
3 ай бұрын
Thank you for this course it's really helpful. I have a question though, are there any guides to use the files in Part 1 named Practice 1, 2, 3, 4, 5? I'd like to know if there's something like a quiz which would be really helpful. Thank you again!
@LearnitTraining
3 ай бұрын
No quiz yet but we are working on adding on one to Learnit Anytime - www.learnitanytime.com later this year.
@barefoot2566
3 ай бұрын
Thanks for this video
@LearnitTraining
3 ай бұрын
You are very welcome!
@Financial-Times_Emrys
22 күн бұрын
Please I am unable to download the document
@LearnitTraining
21 күн бұрын
We just checked the links and files. They are currently working
@ihabziyad8611
5 ай бұрын
THANKS
@LearnitTraining
5 ай бұрын
You're welcome!
@BaneenAbad
6 ай бұрын
Thank you🌹
@LearnitTraining
5 ай бұрын
You’re welcome 😊
@MichaelAdekpey
Ай бұрын
@LearnitTraining How do i access the exercise files because the link is not working please
@LearnitTraining
Ай бұрын
Hello Michael! We just tested the link and files. They are currently working.
Пікірлер: 58