03-05 Use the Excel IF function
8:41
09-13: Implement Macro Security
10:54
Пікірлер
@rabiakhan7731
@rabiakhan7731 3 ай бұрын
How to remove group boader line or make it transparent?
@timlin6431
@timlin6431 6 ай бұрын
love your videos/books. i saw the on your website you have the free video walkthrough for the Expert Skills 2016 book owners. Would you happen to have the videos for the Expert Skills Jan 2021 version because i have the book? thanks
@Nyckipace
@Nyckipace Жыл бұрын
Thank you for the assist friend - I was going blind trying to finish this for taxes...Now I can go drink dinner...Cheers!
@GosCee
@GosCee Жыл бұрын
Well presented! Thank you.
@takeepsmillingr6353
@takeepsmillingr6353 Жыл бұрын
Legends watch before exam😂😂😅
@hasbyfarul
@hasbyfarul Жыл бұрын
very useful. thanks for the tricks
@raedalzubaidi2382
@raedalzubaidi2382 Жыл бұрын
Thank you boss. It is very simple and clear explanation. Great
@YASHVEERSINGHDAHIYA
@YASHVEERSINGHDAHIYA Жыл бұрын
Love you From Roshanpura village najafgarh Delhi 🇮🇳🕉️
@arch.l.a.deleon445
@arch.l.a.deleon445 2 жыл бұрын
Thanks!
@ziadshehata1125
@ziadshehata1125 2 жыл бұрын
Thank You, for giving me an idea of what i should do
@muhammadarif8006
@muhammadarif8006 2 жыл бұрын
Excellent Sir it is amazing. M.Aarif 🇵🇰 Pakistan
@benedictjadraque4702
@benedictjadraque4702 2 жыл бұрын
how to change the default start date of 01-01-1900 to current month and year 08-2022? example if i type 1 it will be 01-08-2022
@sridharCPS
@sridharCPS 2 жыл бұрын
kzbin.info/www/bejne/hXSZept7mN2AmZI
@mawarerni6856
@mawarerni6856 2 жыл бұрын
#private
@mrpakistanpashto5049
@mrpakistanpashto5049 2 жыл бұрын
kzbin.info/www/bejne/a3nNZGdjid97ick
@VincentHardwick
@VincentHardwick 2 жыл бұрын
You mentioned lesson 7-14 talks about obtaining a digital certificate... but that lesson video doesn't appear to be available on your channel?
@jacksonville2164
@jacksonville2164 2 жыл бұрын
Thank you for this. Excel is hard for me. Half the time these videos are to hard for me to understand. I loved how easy & fast your video was for me. Thanks a million 😊
@debanjanbanik5232
@debanjanbanik5232 2 жыл бұрын
thank you boss..... it helped me
@pankajsrivastava6083
@pankajsrivastava6083 2 жыл бұрын
The Excel 2013 Expert Skills contains 9 Sessions & 158 lessons. So why random videos of only 20 lessons are shown on this channel & why not videos of each 158 lessons are included. However for Excel 2013 Essential Skills the videos of all 139 lessons & 8 Sessions are included on this channel. So by when we can expect the same for Expert skills lesson videos ?
@SakshiSingh-qi7ry
@SakshiSingh-qi7ry 2 жыл бұрын
When You uploaded this video I was just one year old ,and now I am watching this video for my practical exams
@anjanamg5745
@anjanamg5745 2 жыл бұрын
Thankyou very much for the complete course playlist. I have been looking for excel classes for a while now... and now only found this....This is the best playlist to study excel.😍😍😍
@URKAEJoyalJoshi
@URKAEJoyalJoshi 2 жыл бұрын
Thank you
@simoiyahector-morales3781
@simoiyahector-morales3781 2 жыл бұрын
Excellent tutorial
@ShortnsweetNB
@ShortnsweetNB 2 жыл бұрын
Thanks for the video! Learned a few things I didn’t know. How do you change multiple days at once?
@vivekraj7520
@vivekraj7520 2 жыл бұрын
Very nice
@TheSmartMethod
@TheSmartMethod 2 жыл бұрын
Thanks
@tito5538
@tito5538 3 жыл бұрын
thank you so much, I've tried a lot and you are the only one who mentioned the system format date, when I adjusted it, the magic happened. you deserved a subscribe
@TheSmartMethod
@TheSmartMethod 2 жыл бұрын
Glad it helped
@mqurram
@mqurram 3 жыл бұрын
Thank you so much very well explained
@TheSmartMethod
@TheSmartMethod 2 жыл бұрын
You are welcome!
@Tip-Top23
@Tip-Top23 3 жыл бұрын
great
@FaltuGiri86
@FaltuGiri86 3 жыл бұрын
Very useful and informative video. Thank you.
@TheSmartMethod
@TheSmartMethod 2 жыл бұрын
Glad it was helpful!
@ditsibaboy5222
@ditsibaboy5222 3 жыл бұрын
Hays
@sergiolopez1592
@sergiolopez1592 3 жыл бұрын
How to printing page 1 and 4
@TheSmartMethod
@TheSmartMethod 3 жыл бұрын
Just select the cells you want to print and then use "Print Selection" in print options.
@salamisalone1848
@salamisalone1848 3 жыл бұрын
Thankyou
@TheSmartMethod
@TheSmartMethod 2 жыл бұрын
You’re welcome 😊
@venettesherwood6492
@venettesherwood6492 3 жыл бұрын
This really helps alot thank u
@TheSmartMethod
@TheSmartMethod 2 жыл бұрын
Glad to hear that!
@Up4Excel
@Up4Excel 3 жыл бұрын
It's amazing what I miss in Excel sometimes...I never knew that 'Add to Print Area' option existed. That'll come in handy, thanks for sharing 👍
@TheSmartMethod
@TheSmartMethod 3 жыл бұрын
Glad it was helpful!
@soumiamoujane3695
@soumiamoujane3695 3 жыл бұрын
What's the formula for totalling up Yearly shopping. Can I use autosum to total up a shopping list for the whole year?. For example can I type =SUM(D6:Z38 in Total box and click enter. And for monthly total do I use autosum by typing =SUM(D6:D38 in the total box and click enter
@jimmyshops
@jimmyshops 3 жыл бұрын
Exactly what I wanted to know. Straight to the point as well. Good video. 👍
@soumiamoujane3695
@soumiamoujane3695 3 жыл бұрын
What's the formula for totalling up Yearly shopping. Can I use autosum to total up a shopping list for the whole year?. For example can I type =SUM(D6:Z38 in Total box and click enter. And for monthly total do I use autosum by typing =( SUM(Z6:D38 in the total box and click enter
@TheSmartMethod
@TheSmartMethod 3 жыл бұрын
You can use AutoSum to sum any column of numbers. Make sure that the column only contains numbers (for example not text) and that there are no blank cells. You can also manually type in a SUM function to reference any range of cells (see Lesson 2-12: Create Excel formulas the correct, professional way: kzbin.info/www/bejne/fYOao5iYj7OSnqc).
@vedantsartcraftanddrawinga4804
@vedantsartcraftanddrawinga4804 3 жыл бұрын
thanks for valuable video
@TheSmartMethod
@TheSmartMethod 2 жыл бұрын
Most welcome
@akask6458
@akask6458 3 жыл бұрын
Thank you - the best video on using option form controls
@TheSmartMethod
@TheSmartMethod 3 жыл бұрын
Really pleased that it helped you.
@kelvingeorge5124
@kelvingeorge5124 3 жыл бұрын
So much appreciates
@amnamubasu4392
@amnamubasu4392 3 жыл бұрын
Great
@kss2066
@kss2066 3 жыл бұрын
useful lesson
@kss2066
@kss2066 3 жыл бұрын
useful lesson
@kss2066
@kss2066 3 жыл бұрын
useful lesson
@kss2066
@kss2066 3 жыл бұрын
useful lesson
@kss2066
@kss2066 3 жыл бұрын
useful lesson
@kss2066
@kss2066 3 жыл бұрын
loved the lesson
@kss2066
@kss2066 3 жыл бұрын
useful lesson
@kanchansankar4634
@kanchansankar4634 3 жыл бұрын
very interesting lesson
@kanchansankar4634
@kanchansankar4634 3 жыл бұрын
loved the lesson