Office Nifty
Office Nifty
  • 101
  • 229 279
Check If Cell Contains Text in LibreOffice Calc
This video goes over a few functions that can help with checking or finding specific text in a cell.
Using VLOOKUP video tutorial:
czcams.com/video/LCpYXwGbHDI/video.html
For further info, here are official help pages:
Using the Find Function
help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html#bm_id3152589
Using the Search Function
help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html#bm_id3151005
Using the Match Function
help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html#bm_id3158407
Using the VLOOKUP Function
help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html#bm_id3153152
zhlédnutí: 70

Video

How to Add and Use a Checkbox in LibreOffice Calc
zhlédnutí 214Před 14 dny
Check boxes are one of many Form Controls available in LibreOffice. This video goes over how to add one, then link it to set values in another cell. Official LibreOffice Help page on using Form Controls ⬇ help.libreoffice.org/latest/en-US/text/shared/02/01170000.html
Populate numbers and dates fast using your mouse (AutoFill guide)
zhlédnutí 61Před 21 dnem
AutoFill is a handy way to generate a series of numbers, prices, or dates. It's also quick to apply using the mouse to click and drag. Link to my video on using Sort Lists: czcams.com/video/AzsVWezqBj4/video.html Official help page on using AutoFill and Fill Series dialog: help.libreoffice.org/latest/en-US/text/scalc/guide/calc_series.html
Applying Sort Lists in LibreOffice Calc
zhlédnutí 119Před měsícem
Using Sort lists makes populating values in a column or row easier. This video shows how to use it, and how to add your own specific lists to use any time. Official help page on using Sort lists: help.libreoffice.org/latest/en-US/text/scalc/guide/sorted_list.html
Enable Macros in LibreOffice Calc
zhlédnutí 430Před měsícem
By default, macro recording is not available in Calc. This video shows where to enable it in the Options section. You can try it by going to Tools ➡ Options ➡ LibreOffice ➡ Advanced, and check the box for Enable macro recording. Link to my Getting Started with Macros video: czcams.com/video/uTreRVO7CC0/video.html Link to official Calc guide on using macro recording: books.libreoffice.org/en/CG2...
How to Import Data from Web into Calc (Using WebQuery)
zhlédnutí 249Před měsícem
Some webpages have tables in them, and using copy and paste can give bad results. This video will show the LibreOffice Calc feature to help insert tables into your spreadsheet. Link to the Wikipedia page of U.S. Presidents: en.wikipedia.org/wiki/List_of_presidents_of_the_United_States Link to official help page for using Web Page Query help.libreoffice.org/latest/en-US/text/scalc/guide/webquery...
Applying Formatting to Dates in LibreOffice Calc
zhlédnutí 256Před 3 měsíci
This video will cover the basics of inputting dates into the spreadsheet, and changing the date format based on your locale and preference.
Getting Started with Macros (Basic Examples) in LibreOffice Calc
zhlédnutí 3,8KPřed 6 měsíci
This video shows the first steps in creating, recording, running, and editing macros in LibreOffice Calc. The video walkthrough follows step by step of the official Getting Started Guide, which is available on their website here books.libreoffice.org/en/GS75/GS7511-GettingStartedWithMacros.html If you prefer the PDF, ODF, or hardcopy version, it's available on this website Click the Getting Sta...
How to Use Group and Outline in LibreOffice Calc
zhlédnutí 924Před 7 měsíci
Calc allows you to group and form an outline to your spreadsheet. This can make the view of your report or data to be more dynamic, especially if you have subtotals (or other calculated data). Link to watch the AutoOutline Video: czcams.com/video/N1n_QnY7Z24/video.html Video Chapters 0:00 Start to Group the Rows 2:27 Grouping Columns 3:19 How to Ungroup 4:23 Demonstrating AutoOutline View the o...
Keyboard Shortcuts for Formatting Cells | LibreOffice Calc
zhlédnutí 297Před 9 měsíci
Keyboard Shortcuts for Formatting Cells | LibreOffice Calc
Keyboard Shortcuts for Copying and Renaming Sheets | LibreOffice Calc
zhlédnutí 273Před 9 měsíci
This video will go over using the keyboard shortcut to copy a sheet with CTRL Click and Drag. The second shortcut is to use the ALT key.
Getting Started with Mail Merge in LibreOffice Calc and Writer
zhlédnutí 3,7KPřed 9 měsíci
Getting Started with Mail Merge in LibreOffice Calc and Writer
How to Paste into Multiple Cells | LibreOffice Calc
zhlédnutí 2,2KPřed 9 měsíci
00:00 Copy and Paste 01:05 Absolute or relative reference Related videos: czcams.com/video/XUt8i6T4GHk/video.html czcams.com/video/e8BiSrJV5nw/video.html czcams.com/video/UIgJx1lVpzg/video.html
How to Use AutoOutline in LibreOffice Calc
zhlédnutí 453Před 9 měsíci
LibreOffice Calc has an automatic way to outline your table with subtotals or formulas. This video goes over this in action and its benefits. Related videos: czcams.com/video/ziUM4ZbOtIY/video.html czcams.com/video/DVcC1uyDkn8/video.html
How to Export to CSV in LibreOffice Calc
zhlédnutí 1,7KPřed 9 měsíci
This video will go over exporting your sheet to a CSV file type, and also export a selection of cells to CSV. 00:00 Export a sheet to CSV 03:32 Export selection to CSV 04:14 Using Concatenate function
How to Add Days to Date in LibreOffice Calc
zhlédnutí 1,8KPřed 9 měsíci
How to Add Days to Date in LibreOffice Calc
How to Set the Print Area in LibreOffice Calc
zhlédnutí 7KPřed 9 měsíci
How to Set the Print Area in LibreOffice Calc
How to Lock Cell in Formula (Keep Cell Constant) | LibreOffice Calc
zhlédnutí 2,3KPřed 9 měsíci
How to Lock Cell in Formula (Keep Cell Constant) | LibreOffice Calc
How to Jump to the Last Row in LibreOffice Calc
zhlédnutí 759Před 9 měsíci
How to Jump to the Last Row in LibreOffice Calc
Easily Change Between Relative and Absolute Reference in LibreOffice Calc
zhlédnutí 1,1KPřed 9 měsíci
Easily Change Between Relative and Absolute Reference in LibreOffice Calc
How to Concatenate Cells in LibreOffice Calc
zhlédnutí 3KPřed 10 měsíci
How to Concatenate Cells in LibreOffice Calc
Create an INSERT ROW Keyboard Shortcut | LibreOffice Calc
zhlédnutí 1,6KPřed 10 měsíci
Create an INSERT ROW Keyboard Shortcut | LibreOffice Calc
How to Insert or Remove Page Break in LibreOffice Calc
zhlédnutí 3,9KPřed 10 měsíci
How to Insert or Remove Page Break in LibreOffice Calc
How to Disable Auto Capitalization in LibreOffice Calc
zhlédnutí 1,4KPřed 10 měsíci
How to Disable Auto Capitalization in LibreOffice Calc
How to Use IF ELSE with a Function in LibreOffice Calc
zhlédnutí 1,1KPřed 10 měsíci
How to Use IF ELSE with a Function in LibreOffice Calc
How to Convert Text to Numbers in LibreOffice Calc
zhlédnutí 3,8KPřed 10 měsíci
How to Convert Text to Numbers in LibreOffice Calc
How to use the SUMIF Function in LibreOffice Calc
zhlédnutí 1,4KPřed 10 měsíci
How to use the SUMIF Function in LibreOffice Calc
How to use the COUNTIF Function in LibreOffice Calc
zhlédnutí 2KPřed 10 měsíci
How to use the COUNTIF Function in LibreOffice Calc
How to Set a Spreadsheet to be Read Only in LibreOffice Calc
zhlédnutí 330Před 10 měsíci
How to Set a Spreadsheet to be Read Only in LibreOffice Calc
How to Use the OR Function in LibreOffice Calc
zhlédnutí 509Před 10 měsíci
How to Use the OR Function in LibreOffice Calc

Komentáře

  • @The100SpinTest
    @The100SpinTest Před 6 hodinami

    Thanks for the help, but this could have been done with three lines of text. A video was not necessary.

  • @ColtraneTaylor
    @ColtraneTaylor Před 2 dny

    Can you reference the other sheet without having to "copy paste" the book titles?

  • @audiofile1178
    @audiofile1178 Před 2 dny

    Thank you, just what I was looking for.

  • @alkamino
    @alkamino Před 4 dny

    You are the god of libreoffice calc. Thank you!

  • @alkamino
    @alkamino Před 4 dny

    Thank you! :D I really appreciate this video! :D You are the best!!!!!

  • @mangoginger8924
    @mangoginger8924 Před 10 dny

    Your explanation is very clear and spoken at the right speed. Wished others who post on CZcams could slow down on their explanation!

  • @DerekLeeEskelson822
    @DerekLeeEskelson822 Před 14 dny

    you're the man, thanks

    • @officenifty
      @officenifty Před 9 dny

      You're welcome! Thanks for watching and leaving a comment 🤜🤛

  • @1rajuindia
    @1rajuindia Před 15 dny

    Good presentation. Please tell me how to count all the check box and generate percentage of attendance of a person (if we enter person by person and day by day)

  • @DerekLeeEskelson822
    @DerekLeeEskelson822 Před 18 dny

    thanks

    • @officenifty
      @officenifty Před 18 dny

      You're welcome, thanks for watching and leaving a comment! Have a great day 😀

  • @megharajh2573
    @megharajh2573 Před 21 dnem

    Today i have learnt from this video how to unhide the libre office sheet

    • @officenifty
      @officenifty Před 20 dny

      I'm glad you learned something new! Thanks for watching and leaving a comment 👍

  • @trevinosoutdoors7239
    @trevinosoutdoors7239 Před 22 dny

    Does not work!

  • @andrewgray8991
    @andrewgray8991 Před 22 dny

    Thanks for the answer to my question. Your video is comprehensive but to the point. I appreciate your work.

    • @officenifty
      @officenifty Před 9 dny

      You're welcome, I'm glad it helped. Thanks for watching and leaving a nice comment, I appreciate it 😃

  • @PrinzyJunior
    @PrinzyJunior Před 23 dny

    very helpful

    • @officenifty
      @officenifty Před 23 dny

      You're welcome, thanks for using Calc and watching my video 👍

  • @cyron5091
    @cyron5091 Před 24 dny

    Thanks for the vid, was able to make sure that I'm doing everything right

    • @officenifty
      @officenifty Před 23 dny

      You're welcome, I'm glad my video can help to confirm it works ok! Thanks for watching my video and leaving a comment, I appreciate it 👍

  • @EminaMujcinovic-fo1cn

    TY bro ur saving lives

    • @officenifty
      @officenifty Před 24 dny

      You're welcome, I'm glad the video was helpful! Thank you for leaving a comment, I appreciate it 👍

  • @ronber7733
    @ronber7733 Před 26 dny

    thank.

    • @officenifty
      @officenifty Před 24 dny

      You're welcome, I'm glad this video was helpful! Thank you for leaving a comment, I appreciate it 👍

  • @RubbittTheBruise
    @RubbittTheBruise Před 27 dny

    Perfect! Seems easy when you put it here, but seemed tricky when I didn't know how. Thanks,

    • @officenifty
      @officenifty Před 24 dny

      Thanks for leaving a kind comment, I appreciate it! I'm glad the video has useful 👍

  • @user-qb9ex8hc9o
    @user-qb9ex8hc9o Před 29 dny

    Doesn't work.

  • @birnajonsd
    @birnajonsd Před měsícem

    Thanks for this tip. It worked on my side when I used a semicolon instead of a comma.

    • @officenifty
      @officenifty Před měsícem

      I'm glad you made this helpful comment! Thank you for sharing what worked for you.

  • @someuser4166
    @someuser4166 Před měsícem

    thank you

    • @officenifty
      @officenifty Před 23 dny

      Thanks for leaving a comment and watching the video! You're welcome, and have a great day 👍

  • @tryptvminxglitch8221
    @tryptvminxglitch8221 Před měsícem

    10/10. Would watch again 😅 for real.

    • @officenifty
      @officenifty Před 23 dny

      For sure, I love using AutoSum in my sheets and seeing numbers total up. Thanks for leaving a comment and have a great day 😀

  • @TheBeardedGamerReviews
    @TheBeardedGamerReviews Před měsícem

    Great explanation thank you!

    • @officenifty
      @officenifty Před 22 dny

      You're welcome, thanks for watching and I appreciate you leaving a comment 👍

  • @marcofloriano
    @marcofloriano Před měsícem

    Amazing thanks

    • @officenifty
      @officenifty Před 23 dny

      Yeah I agree, Calc is awesome! Thanks for leaving a comment and have a great week 👍

  • @alexkhonko4115
    @alexkhonko4115 Před měsícem

    supergeil thank you

  • @markmanning2921
    @markmanning2921 Před měsícem

    I am literally entering a SINGLE lower case i in a cell and even with that option turned off it gets turned into a capital letter I but if I put ii in they are not fixed. I do not want libreoffice *ANYTHING* changing ANY PART of ANYTHING i input into any field. I want to permanantlfy disable every single "I am smarter than you are and will fix everything you type like it or not" feature. *EVERY SINGLE ONE*. Seriously A-Noying!

  • @terrenceolivido741
    @terrenceolivido741 Před měsícem

    this may be the only guy in the world who has done this. ... and after his explanation he will continue to be. i give him 100% credit for this, but also recommend that someone else read his narrative or he take elocution lessons.

    • @officenifty
      @officenifty Před měsícem

      Thank you for your kind comment and constructive criticism! I bought a public speaking course and am going through it to elocute better.

    • @Outside-In.
      @Outside-In. Před 15 dny

      ​@@officenifty I am not sure, but I do believe you elocuted very well LOL. Elocution??. I had to look that one up, but it was just as I thought. I thought your execution and follow through was very good indeed, and I understood completely everything you were saying, so great great job. Glad that I subscribed, as I love spread-sheeting, and using IF statements, nested IF statements, and nested nested IF statements... These macros look very interesting as well, and am sure they will come in handy. Spreadsheet is my name, and statistics is my game for sure. 👍👍👍

  • @vinceb7918
    @vinceb7918 Před měsícem

    Nicely done tutorial video with your attention to explaining optional choices in detail in a clear voice. Please keep up the excellent effort.

    • @officenifty
      @officenifty Před měsícem

      I'm glad this video helped you out, thanks for the kind comment and subscribing to my channel! I really appreciate it

  • @birdmann1010
    @birdmann1010 Před měsícem

    Just watched a couple of these videos. Moving from other Office products to Libre and struggled with a few changes. Appreciate the assistance you provided.

    • @officenifty
      @officenifty Před měsícem

      Thank you for the kind comment! I'm glad some of the videos have been helpful for your Office switch

  • @motivation_day_day
    @motivation_day_day Před měsícem

    İ wish it was possible to move with keyboard arrow keys instead of just clicking with mouse while choosing formula arguments.

  • @kingstontie4219
    @kingstontie4219 Před měsícem

    How to automatically to expand array formula to include new rows or columns?

  • @connierichard9123
    @connierichard9123 Před měsícem

    Wonderful tutorial.thanks

    • @officenifty
      @officenifty Před měsícem

      I appreciate your kind comment! I'm glad the tutorial was useful for you, have a great week!

  • @robgrider2390
    @robgrider2390 Před měsícem

    Thank you

    • @officenifty
      @officenifty Před 23 dny

      Thanks for watching and leaving a kind comment. You're welcome and have a great day! 😀

  • @avatharb
    @avatharb Před měsícem

    its NOT TRUE

  • @healthy_palace
    @healthy_palace Před měsícem

    Great video! Thanks!

  • @unitedsoulwarriorsfreedom4313

    Thank you so much, exactly what i needed.. you are a gem..apprechiate you, hit that like and sub people

    • @officenifty
      @officenifty Před měsícem

      You're welcome, thanks being so kind and leaving an awesome comment for this video!

    • @unitedsoulwarriorsfreedom4313
      @unitedsoulwarriorsfreedom4313 Před měsícem

      @@officenifty just doing what an honourable man or woman should, your hard work saved me hours of research.. much love and peace to you and your works.

  • @NeeerB
    @NeeerB Před měsícem

    The 'page style' tab is freeze ,

  • @Phagocytosis
    @Phagocytosis Před měsícem

    I was hoping when you started by moving columns that the sorting shown in this video would also be horizontal. I know how to sort by the contents of a column, vertically, and there are many videos about this, but it's really difficult to find a good explanation on how to do it horizontally (sorting such that columns are re-ordered, say, alphabetically).

    • @officenifty
      @officenifty Před 23 dny

      Thanks for watching and leaving a comment! It is possible to sort horizontally by using the Sort dialog. This can be done by going to Data -> Sort -> Sort Criteria (tab) -> on the bottom is the Sort Options with Direction radio buttons. Instead of the default "Top to bottom", choose "Left to right". The Sort dialog appears at 4:10 in the video, and the "Left to right" radio button is visible at that time.

  • @psychoticwhitebunny
    @psychoticwhitebunny Před měsícem

    bro's 100% asian.

  • @jimthrowaway
    @jimthrowaway Před měsícem

    My Calc formula =DAY(NOW()) is returning an actual value instead of an err mssg, but the day & date of the field are wildly *incorrect.* I'm getting "Wednesday, January 10, 1900" instead of what should be "Saturday, May 11, 2024" appearing in cell. My PC's system clock isn't malfunctional, it's working fine & accurate, same as it always has.... to just clarify that up front. That formula used however is literally cut & pasted directly from the actual tutorial page of the Calc help system as an example for inserting =DAY function into a cell to populate that cell with the current day. Syntax will vary of course by formatting selected elsewhere, within the altogether separate feature dedicated to the formatting of cells, I understand that, and that aspect seems to be working fine. It's just how very inaccurate the date generated by formula is what is my dilemna here..... I''m an older gent & quite PC literate, yet I'm new to Calc, learning it to create docs needed for a busn venture. I'm completely lost in the weeds here. Any tips | suggestion ? . . . . I otherwise found the video informative . . . Liked & Subbed . . . . thanks in advance

    • @officenifty
      @officenifty Před 18 dny

      Thanks for subbing and asking a question! The function *DAY()* returns the numerical day of a date value, which would be an integer from 1 to 31. If you simply use *NOW()* , then you can get the full date with month and year (and time) included. You couid also try using *TODAY()* to show today's date. You can adjust the formatting by going to Format → Cells → Numbers (tab) → Date (category) and select the date format that you prefer. Sorry for the slow repsonse, but I hope it helps.

  • @Eiphory
    @Eiphory Před měsícem

    Good, but custom rows height will not preserved.

    • @officenifty
      @officenifty Před 18 dny

      You're right, inserting multple rows before or after a selection may not preserve their height. To view and then set row heights, one could go to *Format → Rows → Height* in the menu. Thanks for watching and leaving a comment! Have a nice day 👍

  • @anthonyledesma9883
    @anthonyledesma9883 Před měsícem

    this stuff should be incorporated in the print preview, along with "print selected cells".

  • @gogumarc
    @gogumarc Před 2 měsíci

    you could have showed it to us in like 10 seconds but you chose to take 1:54. respect

  • @ecospline
    @ecospline Před 2 měsíci

    I wondering if this behaviour can be incorporated to sheets as copying sheets with dependencies to other sheets acts in the same way (relative reference)

  • @stephenhavilland
    @stephenhavilland Před 2 měsíci

    Thank you, Thank you, Thank you - for your detailed tutorial. I was despairing of ever being able to send emails using a template without manually sending them individually to my list of about 40 newsletter subscribers using a Theme for each week. This would have been incredibly tedious, as I would have had to repeat the process every week. It would have created the potential for many errors, as well. Also, I appreciate you going through items such as "correcting" zip codes starting with the 0 numeral, synchronizing the fields. etc.

    • @officenifty
      @officenifty Před měsícem

      I'm glad this video was helpful and will save you some time every week! Thanks for your thoughtful and detailed response, I appreciate it 👍

  • @Ivcifer
    @Ivcifer Před 2 měsíci

    appreciate it, man 🙏

    • @officenifty
      @officenifty Před 22 dny

      you're welcome, i'm glad this helped u. thanks for leaving a comment 👍

    • @Ivcifer
      @Ivcifer Před 22 dny

      @@officenifty it really did. you deserve it bro, and thank you for your kindness 🤜🤛

  • @user-bz5uk3yv1f
    @user-bz5uk3yv1f Před 2 měsíci

    the wrong title. 2.5 mins complete waste of time. Its not autofit its hand resize. Learn English dude

    • @officenifty
      @officenifty Před 22 dny

      Sorry I wasted 2.5 minutes of your time. I'm glad your English is better than mine, could you please explain what autofit is for me? Then I could make the right video for it.

    • @gersitranslation5080
      @gersitranslation5080 Před 5 dny

      @@officenifty Autofit is the feature that makes the cell adjust to the content in it so that you can read the whole content. Here, you have red arrows indicating that there is more text. We would like to be able to see the whole text in the cell. Just like with the "Autofit" feature in Excel.

    • @gersitranslation5080
      @gersitranslation5080 Před 5 dny

      I hope you found the solution. It is Format > Cell > Alignment > Properties > tick the first option

  • @cindaellas
    @cindaellas Před 2 měsíci

    thanks a lot! thats what I was looking for

    • @officenifty
      @officenifty Před 22 dny

      You're welcome, I'm glad this video helped you! Thanks for watching and leaving a kind comment 👍

  • @lciavarella
    @lciavarella Před 2 měsíci

    Go to Format then Print ranges

  • @lciavarella
    @lciavarella Před 2 měsíci

    Go to Format then Print ranges

  • @gtimf2142
    @gtimf2142 Před 2 měsíci

    Thanks. Do you know how to insert copied rows?

    • @officenifty
      @officenifty Před 18 dny

      Yes, I have another video that shows how to move columns, which would work in a similar way for copying and pasting multiple rows. czcams.com/video/AFBQ2SOYCJ8/video.html