- Видео 33
- Просмотров 237 315
Just Click Here
Великобритания
Добавлен 28 май 2019
Creating Basic Formulas in LibreOffice Calc (+ - / *)
This video covers using basic formulas to add, subtract, divide or multiply two cells in LibreOffice Calc. It also covers being aware of order in calculations (BODMAS). The version of Calc used in this video is 7.4.7.2
Просмотров: 6 422
Видео
How to Hide Comments in Microsoft Word
Просмотров 2,5 тыс.2 года назад
Quick tutorial covering how to hide comments in Microsoft Word (Tutorial uses the desktop version of Word 365).
How to change page orientation in Google Docs
Просмотров 3,1 тыс.3 года назад
How to change page orientation on Google Docs - for either ALL pages or selected text. Table of Contents: 00:00 - Introduction 00:00 - Change all pages to landscape 00:33 - Change part of a document to landscape
How to create a pdf in Google Docs
Просмотров 3 тыс.3 года назад
This tutorial shows you how to download a document from Google Docs as a .pdf and how to use the print options to create a .pdf document. Table of Contents: 00:00 - Introduction 00:11 - Downloading a document as a .pdf 00:43 - Create a .pdf using the print menu
How to change case in LibreOffice Writer (e.g. from UPPERCASE to lowercase)
Просмотров 6 тыс.3 года назад
How to change case easily in LibreOffice Writer (e.g. from UPPERCASE to lowercase or tOGGLE cASE etc)
How to change case in Excel: UPPER, Proper & lower
Просмотров 583 года назад
This quick tutorial covers changing case in Excel using the UPPER, Proper and lower functions.
How to change page orientation (e.g. from portrait to landscape) for ALL pages in LibreOffice Writer
Просмотров 5 тыс.3 года назад
This tutorial covers how to change page orientation (for example from portrait to landscape) for all pages in a document in LibreOffice Writer.
How to Change Case in Microsoft Word (e.g. from UPPERCASE to lowercase)
Просмотров 3,2 тыс.3 года назад
There are a few different ways you can easily change the case of your text in Microsoft Word. You can change UPPERCASE to lowercase, to tOGGLE cASE to sentence case quickly. This tutorial shows you how to use an icon on the ribbon to change case easily, and how to use a keyboard shortcut to toggle through several different cases.
How to add a drop-down list in Microsoft Excel
Просмотров 993 года назад
How to add a drop down list to a cell (or range of cells) in Microsoft Excel.
LibreOffice Calc - how to find and remove duplicates
Просмотров 17 тыс.3 года назад
How to find duplicates using advanced filters, then copy your data (with the duplicates removed) to a new location in LibreOffice Calc.
How to dim incorrect answers in a Presentation in Canva
Просмотров 3,1 тыс.3 года назад
Quick tutorial showing how you can dim incorrect answers in a quiz, in a presentation in Canva.
Remove Duplicates in Excel
Просмотров 1663 года назад
How to remove duplicate records from your data in Excel. There are several different ways of doing this - this tutorial covers the remove duplicate feature, and using advanced filters.
How to Change Google Slides from Landscape to Portrait
Просмотров 22 тыс.3 года назад
The default in Google Slides is for slides to be landscape, but you can change them to portrait easily.
How to change slides in LibreOffice Impress to Portrait
Просмотров 4 тыс.3 года назад
The default in LibreOffice Impress is for slides to be landscape, but you can change them to portrait easily.
How to change PowerPoint slides to Portrait
Просмотров 7 тыс.3 года назад
The default in PowerPoint is for slides to be landscape, but you can change them to portrait easily.
How to Remove the background of a photo or image in Canva
Просмотров 483 года назад
How to Remove the background of a photo or image in Canva
How to add a drop-down list in Google Sheets
Просмотров 1433 года назад
How to add a drop-down list in Google Sheets
How to Add Page Numbers in Microsoft Word
Просмотров 2063 года назад
How to Add Page Numbers in Microsoft Word
How to Change or Amend Margins in LibreOffice Writer
Просмотров 1,3 тыс.3 года назад
How to Change or Amend Margins in LibreOffice Writer
Delete a spreadsheet permanently from Google Drive
Просмотров 22 тыс.3 года назад
Delete a spreadsheet permanently from Google Drive
11 Keyboard shortcuts for presentations in Canva
Просмотров 1,6 тыс.3 года назад
11 Keyboard shortcuts for presentations in Canva
How to Convert a Canva Presentation to a PowerPoint Presentation (.pptx)
Просмотров 6533 года назад
How to Convert a Canva Presentation to a PowerPoint Presentation (.pptx)
Import an Excel Spreadsheet into Google Sheets
Просмотров 6673 года назад
Import an Excel Spreadsheet into Google Sheets
How to use AutoSum in Microsoft Excel (how to add cells automatically)
Просмотров 403 года назад
How to use AutoSum in Microsoft Excel (how to add cells automatically)
How to remove the background of an image using a free online tool
Просмотров 583 года назад
How to remove the background of an image using a free online tool
Google Slides - How to change all of the fonts in a presentation
Просмотров 32 тыс.3 года назад
Google Slides - How to change all of the fonts in a presentation
How to Download LibreOffice (includes Writer, Calc, Impress, Draw, Base, Math and Charts!)
Просмотров 2593 года назад
How to Download LibreOffice (includes Writer, Calc, Impress, Draw, Base, Math and Charts!)
My pages are all different sizes and margins, how to I set a single measurement to create consistency throughout the whole document?
Writer uses page styles... have you tried right-clicking on the document, selecting Page, then adjusting the page settings for your document? Let me know how you get on!
This was very helpful and I was very hopeful but unfortunately, it didn't work for me. Not sure why.
Oh no! I'm sorry to hear that... I'd be interested in finding out why? Do you know what version of PowerPoint you are using? At what point did the instructions not work for you? Or did you follow the instructions & find that nothing changed? Let me know!
I appreciate you getting back to me. I wish I knew why it didn't work. Your instructions were perfect. But after I changed the font size and closed the window nothing happened. I'm on 365.
That's really bizarre... I've been trying to figure out why it didn't work for you... but I can't think of a reason... I'll keep trying!
It will certainly be useful in the future. Thank you for all you do!@@JustClickHere-ITtraining
From India plz reply to me ❤❤
Apologies for not replying sooner! Hope you are keeping well 😀 Do you have a question? 😀
@@JustClickHere-ITtraining I have no questions
Hello from the UK! Lovely to hear from you ❤️
But what if you have dups a few places. Can you have it search and remove dups without highlighting it.
Thank you, you got a new subscriber.
Brilliant! Thank you so much
Thank you so much
You are very welcome! I'm glad you found it useful 😀
Thank you
You're welcome!
Thnx❤
Welcome!
Thank you mam it really helped (:
Happy to help! Thank you for taking the time to comment 😀
@@JustClickHere-ITtraining 😁 thank you for taking the time to upload.
You saved me hours of work ❤❤
Glad I could help!
nice video thank you very much
Thank you!
Unfortunately doesn't work as of 7/24 - They've replaced "master" with a "theme builder" that works about 1000x worse
oh no.... Thanks for taking the time to let me know - I really appreciate it.
ok, but how is it if I do not want all slide to change, only one specific page is needed as portrait
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).
You earned a subscriber
Thank you!!
I found it very useful.. very simple and short.. Thank you so much.. u got a new subscriber 😊
Thank you so much 🙂
Спасибо !
You are very welcome!
Life Saver
Thank you so much. Really appreciate this knowledge!
Glad it was helpful!
Its still show in recent when i open google sheets what to do??
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...
@@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!
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...
@@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,RUclips and etc 🥹🥲
Thank you! I wish I had known this years ago, but I know it now!
You're so welcome! And thanks for commenting 😀
Thanks. Really helpful advice
Glad it was helpful! And thanks for taking the time to comment
Thank you so much :)
No problem 😊
It works! Thank you.
Great! You are welcome 😀
Thank you sir.
You are most welcome!
THANK YOU
You are welcome 😀
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.
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...
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.
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)
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.
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 !
clear and lucid explanation. thank you.
A great tip! Thanks!
No problem!
very helpful still...thank you.
Glad it helped! 😀
Jazak Allah This Video saved my Time Thankyou
I'm really pleased to hear that! Thank you for taking the time to comment - much appreciated :-)
Your tutorial is appreciated - thanks 123
Glad it was helpful! :-)
Thanks, a lifesaver😄
Glad it helped! 😀
Perfect!
You have saved me so much time! thankyou!
You are welcome! I'm delighted to hear that 😀
Thank you very much. I really appreciate it.
You are very welcome 😀
Straight to the point, thanks
You are welcome! 😀 Thanks for taking the time to comment 😀
thanks
You're welcome!
Thank you! It's very well explained.
Glad you liked it 😊
Great information
Glad it was helpful!
It´s dont useful anymore, but I like so much of the explanation, thank you anyway!
I think you just made my day with that comment! Love a bit of positivity 😊
This video is old. I don't see Master option under View.
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.
Thanks for these tips!!
You are welcome! And thanks for commenting too 😀
Excellent! Couldn't get default lowercase in my table. Thank you very much for your clear explanation!
You are very welcome! (And I really appreciate the fact you took the time to comment - thanks!)
tysm
You are very welcome!
Great! So, do you happen to know where the subtraction button is located? Just curious is all... :)
Here you go! Quick video on basic formulas, hope you enjoy! 😊 ruclips.net/video/6GniX7KWJdU/видео.html
@@JustClickHere-ITtraining Thanks! It sure helps... 👍
Is there a way to password protect comments, so only you can see them?
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!
@@JustClickHere-ITtraining Thank you for your help.
This range does not contain a valid query
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!
Thanks
No problem!