- Видео 227
- Просмотров 26 438
Clyve's Excel Corner
Южно-Африканская Республика
Добавлен 15 ноя 2020
Power Query Filter function
Power Query Videos:
ruclips.net/video/6BdGxhP_Mkg/видео.html
ruclips.net/video/6BdGxhP_Mkg/видео.html
Просмотров: 113
Видео
Day299 Value formula to solve false #NA VLOOKUP error
Просмотров 122 года назад
Day299 Value formula to solve false #NA VLOOKUP error
Day286 Notes & Comments
Просмотров 72 года назад
In this video I explore the two excel annotating functionalities and evaluate the benefits of each. I conclude by recommending the one that i think is the best to use in most cases
Day284 Add, Multiply, Subtract, Divide using paste special
Просмотров 92 года назад
Day284 Add, Multiply, Subtract, Divide using paste special
Day281 Excel Tip pin your workbook to excel taskbar
Просмотров 372 года назад
In this video I take a look at how you can pin a frequently used workbook to the task bar so that you can easily access it without going through your folders. Please stop cluttering your desktop please.
Day279 Trunc function to remove the decimal part of the number without rounding
Просмотров 102 года назад
In this video we look at how to use Trunc Excel function to remove the decimal part of a number without rounding up or down.
Day278 How You can remove Outliers from your data using Trimean function
Просмотров 402 года назад
In this video, I take a look at how you can remove outliers from your data Using a very simple excel formula when calculating your population average in excel.
Day277 Top 10 Excel Shortcuts you should know
Просмотров 232 года назад
Top 10 Excel Shortcuts you should know 0:00 Intro #1 0:47 Add numbers #2 1:08 Copy #3 1:21 Paste #4 1:31 Navigate between two or more open windows #5 1:57 See all open windows on your screen and pick the one you want to focus on #6 2:31 Go to the last or first record of your data #7 3:29 Select all data #8 3:38 Repeat the most recent excel command #9 3.59 Undo most recent excel command #10 4:18...
Day199 Trim Remove extra spaces Trim covered in day 112
Просмотров 62 года назад
Day199 Trim Remove extra spaces Trim covered in day 112
Day195 Do you sometimes prepare workbooks with comments but you don't knw how to Print comments
Просмотров 192 года назад
Day195 Do you sometimes prepare workbooks with comments but you don't knw how to Print comments
Day194 Red Negative and green positive shape bars
Просмотров 142 года назад
Day194 Red Negative and green positive shape bars
Day193 Make shapes not move or move when column or rows are added or removed or hidden
Просмотров 202 года назад
Day193 Make shapes not move or move when column or rows are added or removed or hidden
Day192 My chart periods don't show when I had my data? Show Chart Values for Hidden cells
Просмотров 32 года назад
Day192 My chart periods don't show when I had my data? Show Chart Values for Hidden cells
Day190 Show Chart line end pointer & beginning pointer
Просмотров 62 года назад
Day190 Show Chart line end pointer & beginning pointer
Day189 Avoid Cluttered Charts, use Chart Display Units
Просмотров 152 года назад
Day189 Avoid Cluttered Charts, use Chart Display Units
thank you sir, big appreiation from me
Thank you for the explanation. Really appreciated.
Great explanation, thank you.
Thanks this is the best explanation I found of this.
Glad it was helpful!
Thank you, this is very helpful. Wish you had done this video in the beginning of the year when I was going through thousands of worksheets manually looking for errors.
Glad it was helpful!
Thank you so much :) :) :)
You're welcome!
Love it!! I will use the effects function from now on.
Have fun!
This is wonderful!! :)
Thank you so much!
WOW , I didn't know there was a formula for this. Thank you :)
Happy to help!
Thanks so much for sharing your knowledge, i learn daily from these videos👌👌
Happy to hear that!
aykk9 vyn.fyi
t2w86 vyn.fyi
ipkxd vur.fyi
ed09y vum.fyi
This is awesome!!
Thank you
wow this is beautiful, thanks so much !
Glad you like it!
Hi Clyve, thanks so much. I automated some reports using this Macro tool. Thanks for the lessons, I had also watched the first video you uploaded on Macros in the past which enabled me to do my automations :)
Fantastic!
Nice work
Thanks for the visit
hahahaha so funny indeed
Thanks this is wonderful :)
Thanks I did not know this function :)
Thanks Rufie, I am glad you learning new things here :)
Now you know, learning never ends
Thanks for this :)
I love this!!!!
Thanks Clyve, I didn't know this 👌
Very informative presentation. Learnt new thing today
Thanks Mr Tsekera, I am glad you learnt something new and I am glad to add some value.
wow proper
wow thank you
Your excel videos are always on point and they assist me a lot...thank you sir.
I'm glad to hear. Thanks for the feedback👌
Nice one!!!
Wow just learnt something new about find function. The options part :)
Wow this is next level. Brilliant. I used it on one of my reports at work. Thank you so much!!!!
I love this video, so powerful!!
This is proper !! Thank you
This is so cool!
This is excellent! Thanks Clyve
Wonderful!!!
Great work here, Excel is a powerful tool which can help all of us do so much in our work spaces. Glad you are spreading that knowledge, looking forward to a lot of learning.
Thanks, yes in most cases it's being underutilized hey.
This is so cool, thanks Clyve!
OMG!! I just tried it for my report and it saved me a great deal of time :) :)Very accurate and efficient
The video freezez after you enter the find formula
Hi Khensani please refer to the updated video on the link below: ruclips.net/video/T8KaEMgSsqg/видео.html
Wow I have just learnt a quick way the table array in the formula, I usually lock each part of the arrays separately eg, J1 first then K6. Thanks for the short cut :) :) Feeling super excited
This def helped me bro. Thanks
Nice 1 I am glad its helping.
This is so cool!! Thanks a lot
Impressive 👏🏻👏🏻👏🏻. Happy belated birthday Clyve .🥂to more life 🥳
Thanks so much 👌
Wow nice content well explained
Thank you. I'm glad you enjoyed it.
Wow thanks I just learnt something new :)
I'm glad!
Thanks Clyve, I used this for my reports at work :)
Glad it helped!
Hi Clyve, this is so cool! I needed this
Thanks
Lovely! Thanks Clyve. This is very useful.
Thanks Rufaro :)
Hi Clyve, thanks for the beautiful lesson !
Thanks Rufaro, I am motivated :)