- Видео 50
- Просмотров 269 453
lifedesigner9
Добавлен 28 авг 2017
Welcome to our channel, where we explore the world of Microsoft and how it can revolutionize your work life! In today's video, we dive into the incredible efficiency-boosting powers of Microsoft tools. Discover how learning Microsoft can empower you to streamline your work processes, collaborate seamlessly with colleagues, and achieve more in less time. From mastering Excel's advanced functions to harnessing the power of PowerPoint's dynamic presentations, we'll guide you through the essential skills that will make you a productivity superstar. Join us on this exciting journey as we unlock the full potential of Microsoft, helping you become a more efficient and effective professional. Don't forget to subscribe to our channel for more tips, tricks, and insights on leveraging Microsoft to supercharge your workday!
Видео
Combining Multiple Workbooks Into One (Simple VBA)
Просмотров 372Год назад
I am a dummy in VBA, can only do COPY & PASTE, but somehow managed to combine MANY workbooks into ONE workbook. On the other hand, you may also SORT based on the Worksheet Tabs in ascending order. Hope it's useful. Thanks to these references I have found on Website: ruclips.net/video/JiAYngRcN0s/видео.html www.exceljunction.com/combine-multiple-excel-workbooks-into-one-workbook/ www.automateexc...
Excel | Validation + IndexMatch & vLookup
Просмотров 3162 года назад
Excel | Validation IndexMatch & vLookup
How to Autofill Formulas in Excel Quickly
Просмотров 4242 года назад
How to Autofill Formulas in Excel Quickly
How to Autofill Formulas in Excel without Dragging | Using Shortcuts
Просмотров 76 тыс.2 года назад
How to Autofill Formulas in Excel without Dragging | Using Shortcuts
How to Autofill in Excel without Dragging | Using Fill Series
Просмотров 4,8 тыс.2 года назад
How to Autofill in Excel without Dragging | Using Fill Series
How to Add a Blank Row after each Subtotal | Excel 2019
Просмотров 9352 года назад
How to Add a Blank Row after each Subtotal | Excel 2019
How to Add a Blank Row after each category using Constant | Excel 2019
Просмотров 432 года назад
How to Add a Blank Row after each category using Constant | Excel 2019
ICDL Word 2019 | Q41 - Q69 | Diagnostic Test
Просмотров 6 тыс.3 года назад
ICDL Word 2019 | Q41 - Q69 | Diagnostic Test
ICDL Word 2019 | Q1 - Q20 | Diagnostic Test
Просмотров 8 тыс.3 года назад
ICDL Word 2019 | Q1 - Q20 | Diagnostic Test
ICDL Word 2019 | Q21 - Q40 | Diagnostic Test
Просмотров 6 тыс.3 года назад
ICDL Word 2019 | Q21 - Q40 | Diagnostic Test
ICDL Advanced Word 2019 | Q31 - Q40 | Diagnostic Test
Просмотров 4,4 тыс.3 года назад
ICDL Advanced Word 2019 | Q31 - Q40 | Diagnostic Test
ICDL Advanced Word 2019 | Q21 - Q30 | Diagnostic Test
Просмотров 4 тыс.3 года назад
ICDL Advanced Word 2019 | Q21 - Q30 | Diagnostic Test
ICDL Advanced Word 2019 | Q11 - Q20 | Diagnostic Test
Просмотров 5 тыс.3 года назад
ICDL Advanced Word 2019 | Q11 - Q20 | Diagnostic Test
ICDL Advanced Word 2019 | Q41 - Q47 | Diagnostic Test
Просмотров 2,7 тыс.3 года назад
ICDL Advanced Word 2019 | Q41 - Q47 | Diagnostic Test
ICDL Advanced Word 2019 | Q1 - Q10 | Diagnostic Test
Просмотров 9 тыс.3 года назад
ICDL Advanced Word 2019 | Q1 - Q10 | Diagnostic Test
ICDL Computer Essential | Q61 - Q82 | Diagnostic Test
Просмотров 3,8 тыс.3 года назад
ICDL Computer Essential | Q61 - Q82 | Diagnostic Test
ICDL Computer Essential | Q41 - Q60 | Diagnostic Test
Просмотров 3,8 тыс.3 года назад
ICDL Computer Essential | Q41 - Q60 | Diagnostic Test
ICDL Computer Essential | Q1 - Q20 | Diagnostic Test
Просмотров 8 тыс.3 года назад
ICDL Computer Essential | Q1 - Q20 | Diagnostic Test
ICDL Computer Essential | Q21 - Q40 | Diagnostic Test
Просмотров 3,7 тыс.3 года назад
ICDL Computer Essential | Q21 - Q40 | Diagnostic Test
ICDL Excel 2019 | Q26 - Q50 | Diagnostic Test
Просмотров 6 тыс.3 года назад
ICDL Excel 2019 | Q26 - Q50 | Diagnostic Test
ICDL Excel 2019 | Q1 - Q25 | Diagnostic Test
Просмотров 9 тыс.3 года назад
ICDL Excel 2019 | Q1 - Q25 | Diagnostic Test
ICDL Excel 2019 | Q51 - 73 | Diagnostic Test
Просмотров 4,5 тыс.3 года назад
ICDL Excel 2019 | Q51 - 73 | Diagnostic Test
ICDL Online Essential | Q50 - 76 | Diagnostic Test
Просмотров 3 тыс.3 года назад
ICDL Online Essential | Q50 - 76 | Diagnostic Test
ICDL Online Essential | Q26 - 50 | Diagnostic Test
Просмотров 3,2 тыс.3 года назад
ICDL Online Essential | Q26 - 50 | Diagnostic Test
ICDL Online Essential | Q1 - 25 | Diagnostic Test
Просмотров 6 тыс.3 года назад
ICDL Online Essential | Q1 - 25 | Diagnostic Test
ICDL Photoshop | Q1 - 20 | Diagnostic Test
Просмотров 1,1 тыс.3 года назад
ICDL Photoshop | Q1 - 20 | Diagnostic Test
ICDL Photoshop | Q21 - 40 | Diagnostic Test
Просмотров 1 тыс.3 года назад
ICDL Photoshop | Q21 - 40 | Diagnostic Test
ICDL Photoshop | Q41 - 62 | Diagnostic Test
Просмотров 5803 года назад
ICDL Photoshop | Q41 - 62 | Diagnostic Test
ICDL Digital Marketing | Q41 - 66 | Diagnostic Test
Просмотров 3,3 тыс.3 года назад
ICDL Digital Marketing | Q41 - 66 | Diagnostic Test
Very helpful - thank you. 🙂
I just impressed my girl thank you 😂
Thanks !!!!!!
Having some problems. I'm trying to auto fill division horizontally. But I need all cells divided by one cell. I have =b13/j2 but when I auto fill, it goes c13/k2. I need the 2nd cell to.remain j2
thanks for this useful method.
Ok thank i ve understood
It doesn't work to me
Hi,Please where did you get vba code text from ?
Its in my above content actually www.exceljunction.com/combine-multiple-excel-workbooks-into-one-workbook/#google_vignette www.automateexcel.com/vba/sort-tabs/ Hope it helps. :)
thanks man you really helped meeee (i have a competition on this and this si exactly what i was looking for :) )
One of the most important video
please can you upload icdl advance database diagnostic?
Thanks a lot! I spent so much time trying to drag down the formula into the other cells and this trick really helped me!
Thank you, this saves a lot of time
Quick and easy😊
Thanks buddy ot worked
Awesome
just fucking talk if you are going to make a video
🙏🏽audio would be nice
5:24 in this question, you didn't stop recording using the macro. it wasn't asked in the question, so that wouldn't make the answer wrong? i'm asking, just in case this question pops up in my exam tomorrow.
Hi Darren, you have to stop recording macro before you save your file or go to the next question, or else it will pose an issue and continue to record. hope it helps. Thank you.
did he pass
Yes :)
OK finally, the required elegant solution that I knew must exist out there somewhere. Thanks.
tqsm. u saved me a lot of time. appreciated much 😀
You are most welcome. I'm happy to hear it helps.😄
Hello sir How can we put headings in those blank rows ??
Thank you
Thanks for these videos, can you upload of diagnostic of Advance Access?
Thanks 😍
Thank you, so easy. This is a life saver.
Crtl+D is save tab as favorite. Is there a way to go around that?
thank you so much. do you have the one for teamwork module please ?
What are you doing with the IF function at 3:15, please? It seems like you are adding an 'S' before and after the K and another one before and after the N? What is that and why?
Hi, actually that is not an 'S', it's a dollar sign $. In excel, everytime you do auto fill, what happen is the formula will automatically eg. Multiply by K2, then K3, then K4, which those are empty cells. In this case, later you will get errors and wrong answers.therefore , if you go back to 'K2' and 'N2', you need to lock both by adding $ sign to LOCK it. Eg. $K means lock column, $2 means lock the row. You can try not to lock ($) first, then you autofill and drag down, after wards you take a look at the formula, you will understand why I fixed $. Hope it helps..thank you. Keep going. :)
@greengrassofhome so sorry, you can refer to my answer on the next comment. :)
Shouldn't question number 36 be people with visual impairments? PS: Awesome videos really useful thank you.
thanks
excllento
Thank you you’re amazing
Thank you.. :)
what did u do at 0:14 ?
I highlight C4, then on my keyboard I press function key F4 (First row of keyboard), it is a shortcut to lock the column $C and row $4 cell. In case F4 is unable to work, then you have to press FN and F4 together to achieve that. Hope it helps.
24 is wrong
Hi,I just checked, it is right. Probably you can highlight to me what is the mistake? Thanks so much.
Can you try some test questions?Can you try some test questions?
Thank you for providing these videos.
Most welcome. Hope it helps. :)
bro play minecraft
Hey I have a opinion pls, The Q17 that the answer I think is not that file, you need to press your mouse into the icon that above the other icon and next to the icon "New Folder".
Pls this make you reply
Hi, thanks for bringing this up😊..no worries, this is one of the correct answers too. Meaning when you 'right click' on winword.exe, the create shortcut menu will come out. 😊
@@lifedesigner9787 Oh year, Thanks for your reply!
@@HUT228 You are most welcome. :)
duma day la anh hoang 6³ phai k ha
Thanks 😊👍
how about going horizontally? do you have tricks?
Ctrl R
SHOULD REMOVE THE BACKGROUND MUSIC IS ANNOYING
Thank you so much!
Hi there, thanks for this. Are all these answers completely correct? Just have a question on protecting the cells and only certain cells. Otherwise this seems straight forward.
Hi Jones, yes the diagnostic test answers are correct. I understand what you meant. For test, you need to follow their instructions, so like what you have mentioned, if they asked you to protect certain range you have to follow. So no worries. Hope it helps. :)
Very easy to follow. Thanks much
ICDL IT SECURITY PLEASE
The goat of all goats 🎉
GOATT
Best tutorial video for the ICDL series. Thank you very much!