How to create a pdf in Google Docs
1:32
Remove Duplicates in Excel
2:56
3 жыл бұрын
Add blank page in Microsoft Word
1:53
Using AutoSum In LibreOffice Calc
2:01
Curved Text in Canva
1:58
3 жыл бұрын
Пікірлер
@SuggonDeeznutz-z6o
@SuggonDeeznutz-z6o Күн бұрын
But what if you have dups a few places. Can you have it search and remove dups without highlighting it.
@hellmunddegenhard
@hellmunddegenhard 3 күн бұрын
Thank you, you got a new subscriber.
@JustClickHere-ITtraining
@JustClickHere-ITtraining 12 сағат бұрын
Brilliant! Thank you so much
@user-zb7lw5hv4g
@user-zb7lw5hv4g 9 күн бұрын
Thank you so much
@JustClickHere-ITtraining
@JustClickHere-ITtraining 8 күн бұрын
You are very welcome! I'm glad you found it useful 😀
@Venom.IQ2
@Venom.IQ2 11 күн бұрын
Thank you
@JustClickHere-ITtraining
@JustClickHere-ITtraining 10 күн бұрын
You're welcome!
@garimakaurfintalks
@garimakaurfintalks Ай бұрын
Thnx❤
@JustClickHere-ITtraining
@JustClickHere-ITtraining Ай бұрын
Welcome!
@aadhishivam2652
@aadhishivam2652 Ай бұрын
Thank you mam it really helped (:
@JustClickHere-ITtraining
@JustClickHere-ITtraining Ай бұрын
Happy to help! Thank you for taking the time to comment 😀
@aadhishivam2652
@aadhishivam2652 Ай бұрын
@@JustClickHere-ITtraining 😁 thank you for taking the time to upload.
@faridsameh50
@faridsameh50 Ай бұрын
You saved me hours of work ❤❤
@JustClickHere-ITtraining
@JustClickHere-ITtraining Ай бұрын
Glad I could help!
@Sidhcheudj
@Sidhcheudj 2 ай бұрын
nice video thank you very much
@JustClickHere-ITtraining
@JustClickHere-ITtraining Ай бұрын
Thank you!
@AndrewFalls-f2j
@AndrewFalls-f2j 2 ай бұрын
Unfortunately doesn't work as of 7/24 - They've replaced "master" with a "theme builder" that works about 1000x worse
@JustClickHere-ITtraining
@JustClickHere-ITtraining 2 ай бұрын
oh no.... Thanks for taking the time to let me know - I really appreciate it.
@hooplernono7033
@hooplernono7033 3 ай бұрын
ok, but how is it if I do not want all slide to change, only one specific page is needed as portrait
@JustClickHere-ITtraining
@JustClickHere-ITtraining 3 ай бұрын
Sadly Google Slides does not support mixed orientations within a single presentation. The orientation you set will apply to all slides in the presentation. If you need different orientations, you could create separate presentations, then link them. (For example, add a link from your original presentation to your portrait presentation. then you can add a back button to your portrait presentation, linking it to your original document).
@wilfrednoble3630
@wilfrednoble3630 3 ай бұрын
You earned a subscriber
@JustClickHere-ITtraining
@JustClickHere-ITtraining 3 ай бұрын
Thank you!!
@babithathiyagarajan8146
@babithathiyagarajan8146 3 ай бұрын
I found it very useful.. very simple and short.. Thank you so much.. u got a new subscriber 😊
@JustClickHere-ITtraining
@JustClickHere-ITtraining 3 ай бұрын
Thank you so much 🙂
@seagullspb
@seagullspb 4 ай бұрын
Спасибо !
@JustClickHere-ITtraining
@JustClickHere-ITtraining 4 ай бұрын
You are very welcome!
@mordantseer314
@mordantseer314 5 ай бұрын
Life Saver
@user-nk7hv1vh2c
@user-nk7hv1vh2c 5 ай бұрын
Thank you so much. Really appreciate this knowledge!
@JustClickHere-ITtraining
@JustClickHere-ITtraining 5 ай бұрын
Glad it was helpful!
@SoltGamingOfficial
@SoltGamingOfficial 5 ай бұрын
Its still show in recent when i open google sheets what to do??
@JustClickHere-ITtraining
@JustClickHere-ITtraining 5 ай бұрын
Who owns the spreadsheet? And who else can edit it? Who owns the folders it is/was in? Are they in My Drive or a shared drive? Can you open it from the Recent list? Or not? (A while ago, I had a similar problem when we were migrating across to shared drives. My personal drive folders couldn't be directly moved into the shared drives. So we moved the files into a cloned folder structure in the shared drive (and then deleted the personal folders afterwards). But… any files that I had added to someone else's folder, couldn't be moved into the shared drive as that would affect my ownership privileges. I ended up making many copies of files (so I owned them), moved the copies to the shared drive.) Hope this helps! Let me know...
@SoltGamingOfficial
@SoltGamingOfficial 5 ай бұрын
@@JustClickHere-ITtraining They are not in my shared drive, my drive it open when i click i m not the owner when i remove it get removed from view but after i refresh tab it show again in earlier section again and agin i am too frustrated now!
@JustClickHere-ITtraining
@JustClickHere-ITtraining 5 ай бұрын
Only the file owner can delete a file. Do you get an "InsufficientFilePermissions" error at all? If you have read-only permission to this file, and it cannot be removed from your Google Drive account. This happens when someone shares a file with you but gives you read-only access...
@SoltGamingOfficial
@SoltGamingOfficial 5 ай бұрын
@@JustClickHere-ITtraining bruh why can't I remove it from my drive or sheets I want to there are a lot of sheets I got from web,KZbin and etc 🥹🥲
@amymayodesertpineshs3130
@amymayodesertpineshs3130 5 ай бұрын
Thank you! I wish I had known this years ago, but I know it now!
@JustClickHere-ITtraining
@JustClickHere-ITtraining 5 ай бұрын
You're so welcome! And thanks for commenting 😀
@user-xt8tf9fx8x
@user-xt8tf9fx8x 6 ай бұрын
Thanks. Really helpful advice
@JustClickHere-ITtraining
@JustClickHere-ITtraining 6 ай бұрын
Glad it was helpful! And thanks for taking the time to comment
@MindMathMoney
@MindMathMoney 6 ай бұрын
Thank you so much :)
@JustClickHere-ITtraining
@JustClickHere-ITtraining 6 ай бұрын
No problem 😊
@barkatthemoons
@barkatthemoons 6 ай бұрын
It works! Thank you.
@JustClickHere-ITtraining
@JustClickHere-ITtraining 6 ай бұрын
Great! You are welcome 😀
@saifxalikhan6078
@saifxalikhan6078 6 ай бұрын
Thank you sir.
@JustClickHere-ITtraining
@JustClickHere-ITtraining 6 ай бұрын
You are most welcome!
@amalkardaly1652
@amalkardaly1652 6 ай бұрын
THANK YOU
@JustClickHere-ITtraining
@JustClickHere-ITtraining 6 ай бұрын
You are welcome 😀
@orderla8877
@orderla8877 6 ай бұрын
Thank you. But it changes orientation of all slides at once. I have images with different aspect ratios, so is there a way to to change one slide at a time? Thank you again, dear.
@JustClickHere-ITtraining
@JustClickHere-ITtraining 6 ай бұрын
Sadly PowerPoint doesn't allowing for the mixing of landscape and portrait slides in the same presentation... there is a workaround here though (where essentially you create one portrait presentation, one landscape presentation, then use action buttons to link them) support.microsoft.com/en-gb/office/can-i-use-portrait-and-landscape-slide-orientation-in-the-same-presentation-d8c21781-1fb6-4406-bcd6-25cfac37b5d6#:~:text=PowerPoint%20doesn't%20allowing%20for,would%20on%20a%20portrait%20slide. Hope this helps! Let me know if it doesn't...
@phillipfry8141
@phillipfry8141 7 ай бұрын
This doesn't fucking happen and it's driving me insane, I've been trying to just add up a column of numbers for like 20 minutes what the fuck.
@JustClickHere-ITtraining
@JustClickHere-ITtraining 6 ай бұрын
Apologies for my late reply - school half-term. Did you get it sorted? If not, can you email me a copy & I'll have a look for you. (email address on contact page on website - thanks)
@Mishef-3832
@Mishef-3832 3 ай бұрын
The same thing is happening on my machine. I tried to format cells as currency, as numbers, as text and got nothing but the formula.
@jhart3785
@jhart3785 7 ай бұрын
I got the "The range does not contain a valid query" error, then realised the top A & B column just both had "0", so I deleted that row, tried it again and it worked on the 7056 items! Thank you @JustClickHere-ITtraining !
@MegaRavi66
@MegaRavi66 7 ай бұрын
clear and lucid explanation. thank you.
@caslan1000
@caslan1000 7 ай бұрын
A great tip! Thanks!
@JustClickHere-ITtraining
@JustClickHere-ITtraining 7 ай бұрын
No problem!
@carolynt402
@carolynt402 8 ай бұрын
very helpful still...thank you.
@JustClickHere-ITtraining
@JustClickHere-ITtraining 8 ай бұрын
Glad it helped! 😀
@alnoorinternational3628
@alnoorinternational3628 9 ай бұрын
Jazak Allah This Video saved my Time Thankyou
@JustClickHere-ITtraining
@JustClickHere-ITtraining 8 ай бұрын
I'm really pleased to hear that! Thank you for taking the time to comment - much appreciated :-)
@jamespaul4618
@jamespaul4618 9 ай бұрын
Your tutorial is appreciated - thanks 123
@JustClickHere-ITtraining
@JustClickHere-ITtraining 8 ай бұрын
Glad it was helpful! :-)
@InnerSunshine
@InnerSunshine 9 ай бұрын
Thanks, a lifesaver😄
@JustClickHere-ITtraining
@JustClickHere-ITtraining 9 ай бұрын
Glad it helped! 😀
@tom-rz4to
@tom-rz4to 10 ай бұрын
Perfect!
@Justeen026
@Justeen026 11 ай бұрын
You have saved me so much time! thankyou!
@JustClickHere-ITtraining
@JustClickHere-ITtraining 11 ай бұрын
You are welcome! I'm delighted to hear that 😀
@cassidybeaton5602
@cassidybeaton5602 Жыл бұрын
Thank you very much. I really appreciate it.
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
You are very welcome 😀
@ronmanson3000
@ronmanson3000 Жыл бұрын
Straight to the point, thanks
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
You are welcome! 😀 Thanks for taking the time to comment 😀
@moriomislam6693
@moriomislam6693 Жыл бұрын
thanks
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
You're welcome!
@humberto8911
@humberto8911 Жыл бұрын
Thank you! It's very well explained.
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
Glad you liked it 😊
@rohitdavid8559
@rohitdavid8559 Жыл бұрын
Great information
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
Glad it was helpful!
@focootto
@focootto Жыл бұрын
It´s dont useful anymore, but I like so much of the explanation, thank you anyway!
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
I think you just made my day with that comment! Love a bit of positivity 😊
@josephyang8135
@josephyang8135 Жыл бұрын
This video is old. I don't see Master option under View.
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
Yes it is - I amended the description (after the update) to say "After the latest update, Slide Masters can be found under View, then Theme Builder." It changed after the update in around October 2021.
@SNBCHAN101
@SNBCHAN101 Жыл бұрын
Thanks for these tips!!
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
You are welcome! And thanks for commenting too 😀
@fionajones8231
@fionajones8231 Жыл бұрын
Excellent! Couldn't get default lowercase in my table. Thank you very much for your clear explanation!
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
You are very welcome! (And I really appreciate the fact you took the time to comment - thanks!)
@mot1w759
@mot1w759 Жыл бұрын
tysm
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
You are very welcome!
@Fr4nkL33-D34DLY
@Fr4nkL33-D34DLY Жыл бұрын
Great! So, do you happen to know where the subtraction button is located? Just curious is all... :)
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
Here you go! Quick video on basic formulas, hope you enjoy! 😊 kzbin.info/www/bejne/bHjRmottgLx9mrc
@Fr4nkL33-D34DLY
@Fr4nkL33-D34DLY Жыл бұрын
@@JustClickHere-ITtraining Thanks! It sure helps... 👍
@carultch
@carultch Жыл бұрын
Is there a way to password protect comments, so only you can see them?
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
I don’t think you can password protect comments… It’s not a feature I’ve come across (although I think it would be a useful function). In case it’s useful, Word does let you show/hide comments by author? (I appreciate that’s not exactly what you need.) To show only comments added by a specific author: Go to the Review tab, in the Tracking group select Show Markup, then choose Specific People: Deselect all authors, except the author(s) whose comments you want to see. If I think of a way to password protect comments, I'll let you know!
@carultch
@carultch Жыл бұрын
@@JustClickHere-ITtraining Thank you for your help.
@minhnguyenbinh609
@minhnguyenbinh609 Жыл бұрын
This range does not contain a valid query
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
Sorry to hear that this didn't work for you - I have seen this error before though! 🙂 From my experience it seems to be caused by the range that is selected being different from the range displayed (in the "Read Filter Criteria From" box) in the Advanced Filter dialogue box. I hope that helps! If it doesn't help, you can get in touch with me through my website - justclickhere.co.uk (It is difficult to know exactly what the problem is without seeing your data...sorry!) Let me know!
@marfelchairstian8309
@marfelchairstian8309 Жыл бұрын
Thanks
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
No problem!
@dogukanilbay3126
@dogukanilbay3126 Жыл бұрын
very undrstandable gut english
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
Thank You!
@fredericgiudicelli4410
@fredericgiudicelli4410 Жыл бұрын
Thanks. Love your accent.
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
Thank you! 😃
@pauls7056
@pauls7056 Жыл бұрын
Very nicely explained. Thanks for posting. It worked for some calculations for me - not for others. I think it is a formatting problem. But, great video. I cannot understand why so many librecalc videos go through the process of highlighting all the content and writing "sum()" when this does it so easily. Thank you for posting.
@JustClickHere-ITtraining
@JustClickHere-ITtraining Жыл бұрын
Glad it was helpful! 😀