Just Click Here
Just Click Here
  • Видео 33
  • Просмотров 237 315
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
Add blank page in Microsoft Word
Просмотров 1,3 тыс.3 года назад
Add blank page in Microsoft Word
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)
Using AutoSum In LibreOffice Calc
Просмотров 11 тыс.3 года назад
Using AutoSum In LibreOffice Calc
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!)
Curved Text in Canva
Просмотров 1 тыс.3 года назад
Curved Text in Canva

Комментарии

  • @JéssicaCevey
    @JéssicaCevey 4 дня назад

    My pages are all different sizes and margins, how to I set a single measurement to create consistency throughout the whole document?

    • @JustClickHere-ITtraining
      @JustClickHere-ITtraining 4 дня назад

      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!

  • @renaglubay9395
    @renaglubay9395 19 дней назад

    This was very helpful and I was very hopeful but unfortunately, it didn't work for me. Not sure why.

    • @JustClickHere-ITtraining
      @JustClickHere-ITtraining 18 дней назад

      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!

    • @renaglubay9395
      @renaglubay9395 18 дней назад

      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.

    • @JustClickHere-ITtraining
      @JustClickHere-ITtraining 14 дней назад

      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!

    • @renaglubay9395
      @renaglubay9395 13 дней назад

      It will certainly be useful in the future. Thank you for all you do!​@@JustClickHere-ITtraining

  • @gouravkumar2668
    @gouravkumar2668 Месяц назад

    From India plz reply to me ❤❤

  • @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 Месяц назад

    Thank you, you got a new subscriber.

  • @SaaranshShrivastava-w3p
    @SaaranshShrivastava-w3p Месяц назад

    Thank you so much

  • @Venom.IQ2
    @Venom.IQ2 Месяц назад

    Thank you

  • @garimakaurfintalks
    @garimakaurfintalks 2 месяца назад

    Thnx❤

  • @aadhishivam2652
    @aadhishivam2652 2 месяца назад

    Thank you mam it really helped (:

    • @JustClickHere-ITtraining
      @JustClickHere-ITtraining 2 месяца назад

      Happy to help! Thank you for taking the time to comment 😀

    • @aadhishivam2652
      @aadhishivam2652 2 месяца назад

      @@JustClickHere-ITtraining 😁 thank you for taking the time to upload.

  • @faridsameh50
    @faridsameh50 2 месяца назад

    You saved me hours of work ❤❤

  • @Sidhcheudj
    @Sidhcheudj 3 месяца назад

    nice video thank you very much

  • @AndrewFalls-f2j
    @AndrewFalls-f2j 3 месяца назад

    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 3 месяца назад

      oh no.... Thanks for taking the time to let me know - I really appreciate it.

  • @hooplernono7033
    @hooplernono7033 4 месяца назад

    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 4 месяца назад

      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 5 месяцев назад

    You earned a subscriber

  • @babithathiyagarajan8146
    @babithathiyagarajan8146 5 месяцев назад

    I found it very useful.. very simple and short.. Thank you so much.. u got a new subscriber 😊

  • @seagullspb
    @seagullspb 5 месяцев назад

    Спасибо !

  • @mordantseer314
    @mordantseer314 6 месяцев назад

    Life Saver

  • @PatrickKaligis-i8s
    @PatrickKaligis-i8s 6 месяцев назад

    Thank you so much. Really appreciate this knowledge!

  • @SoltGamingOfficial
    @SoltGamingOfficial 6 месяцев назад

    Its still show in recent when i open google sheets what to do??

    • @JustClickHere-ITtraining
      @JustClickHere-ITtraining 6 месяцев назад

      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 6 месяцев назад

      @@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 6 месяцев назад

      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 6 месяцев назад

      @@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 🥹🥲

  • @amymayodesertpineshs3130
    @amymayodesertpineshs3130 6 месяцев назад

    Thank you! I wish I had known this years ago, but I know it now!

  • @ЯнаДовгун-х1с
    @ЯнаДовгун-х1с 7 месяцев назад

    Thanks. Really helpful advice

  • @MindMathMoney
    @MindMathMoney 7 месяцев назад

    Thank you so much :)

  • @barkatthemoons
    @barkatthemoons 7 месяцев назад

    It works! Thank you.

  • @saifxalikhan6078
    @saifxalikhan6078 7 месяцев назад

    Thank you sir.

  • @amalkardaly1652
    @amalkardaly1652 7 месяцев назад

    THANK YOU

  • @orderla8877
    @orderla8877 7 месяцев назад

    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 7 месяцев назад

      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 8 месяцев назад

    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 7 месяцев назад

      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 4 месяца назад

      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 8 месяцев назад

    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 8 месяцев назад

    clear and lucid explanation. thank you.

  • @caslan1000
    @caslan1000 9 месяцев назад

    A great tip! Thanks!

  • @carolynt402
    @carolynt402 9 месяцев назад

    very helpful still...thank you.

  • @alnoorinternational3628
    @alnoorinternational3628 10 месяцев назад

    Jazak Allah This Video saved my Time Thankyou

    • @JustClickHere-ITtraining
      @JustClickHere-ITtraining 10 месяцев назад

      I'm really pleased to hear that! Thank you for taking the time to comment - much appreciated :-)

  • @jamespaul4618
    @jamespaul4618 10 месяцев назад

    Your tutorial is appreciated - thanks 123

  • @InnerSunshine
    @InnerSunshine 10 месяцев назад

    Thanks, a lifesaver😄

  • @tom-rz4to
    @tom-rz4to 11 месяцев назад

    Perfect!

  • @Justeen026
    @Justeen026 Год назад

    You have saved me so much time! thankyou!

  • @cassidybeaton5602
    @cassidybeaton5602 Год назад

    Thank you very much. I really appreciate it.

  • @ronmanson3000
    @ronmanson3000 Год назад

    Straight to the point, thanks

  • @moriomislam6693
    @moriomislam6693 Год назад

    thanks

  • @humberto8911
    @humberto8911 Год назад

    Thank you! It's very well explained.

  • @rohitdavid8559
    @rohitdavid8559 Год назад

    Great information

  • @focootto
    @focootto Год назад

    It´s dont useful anymore, but I like so much of the explanation, thank you anyway!

  • @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!!

  • @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

  • @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! 😊 ruclips.net/video/6GniX7KWJdU/видео.html

    • @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