- 110
- 401 776
Office Nifty
United States
Приєднався 25 січ 2021
I'm Michael Lee and I'm here to help you learn to use LibreOffice Calc.
Having worked as a bookkeeper and software developer, I've often gotten requests from coworkers for help on spreadsheets and IT related questions. I usually take the time to explain and to lend a hand, because it means my team can achieve better skills & outcomes, and we collectively accomplish better work for the company overall.
Follow along and get how-to's, tips & tricks, and advice from someone who is excited to learn deeply about the tools and technology, and truly wants to guide others to their success.
Subscribe now to join other Calc learners and enthusiasts. You'll become that one nifty employee in your job or business and even get recognized for your great work! Feel free to reach out, I'm always here to serve you.
Having worked as a bookkeeper and software developer, I've often gotten requests from coworkers for help on spreadsheets and IT related questions. I usually take the time to explain and to lend a hand, because it means my team can achieve better skills & outcomes, and we collectively accomplish better work for the company overall.
Follow along and get how-to's, tips & tricks, and advice from someone who is excited to learn deeply about the tools and technology, and truly wants to guide others to their success.
Subscribe now to join other Calc learners and enthusiasts. You'll become that one nifty employee in your job or business and even get recognized for your great work! Feel free to reach out, I'm always here to serve you.
Merge Columns in LibreOffice Calc
Quickly combine data from multiple columns into one by using a formula in Calc. This videos goes over two ways, using & (ampersand) symbol and the Concatenate() function. It also explains why using the Merge Cells icon is not necessarily ideal for combining information from columns.
Official help page on how to Merge and Unmerge cells
help.libreoffice.org/latest/en-US/text/scalc/guide/table_cellmerge.html
Official help page for the Concatenate() function
help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html#bm_id3149688
#LibreOfficeCalc
Official help page on how to Merge and Unmerge cells
help.libreoffice.org/latest/en-US/text/scalc/guide/table_cellmerge.html
Official help page for the Concatenate() function
help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html#bm_id3149688
#LibreOfficeCalc
Переглядів: 89
Відео
Limit Number of Rows and Columns (Simplify your Sheet) | LibreOffice Calc
Переглядів 333Місяць тому
Having thousands of columns available, or endless rows, can be a bit annoying and aesthetically unpleasing. This video shows the fastest way to limit the number of rows by hiding them, and then how to unhide them properly as needed. *Video Chapters* 0:00 How it'd look 1:19 Hiding columns 1:57 Hiding rows 2:47 Unhide columns 3:16 Selecting hidden columns 3:52 Unhide rows 4:07 Right click on row ...
Get Day of the Week from Date in LibreOffice Calc
Переглядів 5022 місяці тому
The WEEKDAY() function will return the day of the week as a number value. However, to show the name of the day of the week, we can use cell formatting. This video goes over both scenarios and how to add a custom date format if it's not one of the choices in Calc. *User-Defined Number Formats* help.libreoffice.org/latest/en-US/text/scalc/guide/format_value_userdef.html *Number/Date Format Codes*...
Date Differences Made Easy with the DATEDIF Function in LibreOffice Calc
Переглядів 3023 місяці тому
Calculate date differences and intervals easily with the DATEDIF function. This video goes over the three parameters, a common date format error, and the six different interval types supported. Calculating with dates and times using * and -* operators, instead of a function. ua-cam.com/video/H4LHGTtzC0s/v-deo.html Official LibreOffice Calc help page on using DATEDIF, as shown at 1:20 help.libre...
Add a Button to Run Macro in LibreOffice Calc
Переглядів 1,6 тис.3 місяці тому
This video goes over adding a button to your sheet using Form Controls, and then changing the button's look and feel. Next, we assign an existing macro for one of the button's event, so that it will run every time we click the button. Most importantly, I discuss macro security settings and how to prevent using them in untrusted files. Lastly, I answer a viewer's question about using a button to...
Office Nifty Channel Memberships! What are the Perks?
Переглядів 603 місяці тому
Thank you to all my viewers, and especially subscribers!! Because of you, this channel now gets to have memberships. I've set it up to support Calc learners to by provide upcoming exclusive lessons, spreadsheet templates, having weekly office hours, and more! I really recommend you to give it a try (it's really cheap), and I'd be happy to hear from each one of you to accelerate your learning. #...
Using Arrow Key Navigation in LibreOffice Calc
Переглядів 3374 місяці тому
Using the arrow keys will move your cell selection in the direction you choose. However, when the Scroll Lock key is pressed, it keeps the selection in place and can scroll the sheet instead. This video will show that scenario and the benefits, and also show keyboard shortcuts with arrow keys navigation in the sheet, including selecting multiple cells quickly compared to just using the mouse. 0...
How to Use the OFFSET Function in LibreOffice Calc
Переглядів 6444 місяці тому
Offset lets you target cells in relation to a designated cell location. This video shows how to choose an offset range, and even dynamically choose disjointed ranges. *Formulas used in the video* Selecting One Cell =OFFSET(B4,1,1) Selecting a Range =OFFSET(B4,1,1,1,3) Selecting Every Third Row =SUM(OFFSET(B4,2*(ROW(C1)-1) 1,4,1,3)) Official LibreOffice help page on using the Offset Function hel...
How to Get the Sheet Name in LibreOffice Calc
Переглядів 4645 місяців тому
Populate a cell with the name of a sheet dynamically into your sheet. A benefit of this is to avoid typing it and updating it manually when renaming sheets or duplicating sheets. You don't want the cell to end up with the old name! Formulas used in this video: =CELL("filename") =RIGHT(A1,LEN(A1)-FIND("#$",A1)-1) Video Timestamps: 00:00 Methods to Insert Sheet Name 00:34 Using Edit Mode to Inser...
Check If Cell Contains Text in LibreOffice Calc
Переглядів 4145 місяців тому
This video goes over a few functions that can help with checking or finding specific text in a cell. Using VLOOKUP video tutorial: ua-cam.com/video/LCpYXwGbHDI/v-deo.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/04060...
How to Add and Use a Checkbox in LibreOffice Calc
Переглядів 5 тис.5 місяців тому
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
Using Clicking to Populate Numbers Quickly (AutoFill guide)
Переглядів 3226 місяців тому
AutoFill is a handy way to generate a series of numbers, prices, and dates. It's also quick to apply using the mouse to click and drag. Link to my video on using Sort Lists: ua-cam.com/video/AzsVWezqBj4/v-deo.html Official help page on using AutoFill and Fill Series dialog: help.libreoffice.org/latest/en-US/text/scalc/guide/calc_series.html
Populate Text Quickly (Using Sort Lists) in LibreOffice Calc
Переглядів 2646 місяців тому
Using Sort lists can help fill down cells with values in a column. This video shows how it works, and to add your own specific lists to use and save time. Official help page on using Sort lists: help.libreoffice.org/latest/en-US/text/scalc/guide/sorted_list.html #LIbreOfficeCalc
Enable Macros in LibreOffice Calc
Переглядів 4,6 тис.6 місяців тому
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: ua-cam.com/video/uTreRVO7CC0/v-deo.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)
Переглядів 1,8 тис.6 місяців тому
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
Переглядів 1,8 тис.8 місяців тому
Applying Formatting to Dates in LibreOffice Calc
Getting Started with Macros (Basic Examples) in LibreOffice Calc
Переглядів 11 тис.11 місяців тому
Getting Started with Macros (Basic Examples) in LibreOffice Calc
How to Use Group and Outline in LibreOffice Calc
Переглядів 2,1 тис.Рік тому
How to Use Group and Outline in LibreOffice Calc
Keyboard Shortcuts for Formatting Cells | LibreOffice Calc
Переглядів 570Рік тому
Keyboard Shortcuts for Formatting Cells | LibreOffice Calc
Keyboard Shortcuts for Copying and Renaming Sheets | LibreOffice Calc
Переглядів 468Рік тому
Keyboard Shortcuts for Copying and Renaming Sheets | LibreOffice Calc
Getting Started with Mail Merge in LibreOffice Calc and Writer
Переглядів 8 тис.Рік тому
Getting Started with Mail Merge in LibreOffice Calc and Writer
How to Paste into Multiple Cells | LibreOffice Calc
Переглядів 3,5 тис.Рік тому
How to Paste into Multiple Cells | LibreOffice Calc
How to Use AutoOutline in LibreOffice Calc
Переглядів 658Рік тому
How to Use AutoOutline in LibreOffice Calc
How to Export to CSV in LibreOffice Calc
Переглядів 3,1 тис.Рік тому
How to Export to CSV in LibreOffice Calc
How to Add Days to Date in LibreOffice Calc
Переглядів 2,9 тис.Рік тому
How to Add Days to Date in LibreOffice Calc
How to Set the Print Area in LibreOffice Calc
Переглядів 13 тис.Рік тому
How to Set the Print Area in LibreOffice Calc
How to Lock Cell in Formula (Keep Cell Constant) | LibreOffice Calc
Переглядів 4,4 тис.Рік тому
How to Lock Cell in Formula (Keep Cell Constant) | LibreOffice Calc
How to Jump to the Last Row in LibreOffice Calc
Переглядів 1,5 тис.Рік тому
How to Jump to the Last Row in LibreOffice Calc
Easily Change Between Relative and Absolute Reference in LibreOffice Calc
Переглядів 2,2 тис.Рік тому
Easily Change Between Relative and Absolute Reference in LibreOffice Calc
How to Concatenate Cells in LibreOffice Calc
Переглядів 7 тис.Рік тому
How to Concatenate Cells in LibreOffice Calc
So useful, thank you! I have just moved to Libre from MS Office due to pricing and your videos are so helpful in the transition
Thank you, Office Nifty!
Correct me if i'm wrong but isn't this just getting the name of a sheet that I already know! Like asking my friend Brian what his name is!
thanks!
It didn't work.
Thanks man, so easy. Couldn't find it to save my life.
Worked, thank you!
When I hit PRINT, my Print dialog did not show most of the options yours shows. None of the spreadsheet specific options appeared. I realized it was because I had to check the "Collation and Paper slides" box first. Why would they NOT have those options shown by default? It's not a matter of space, since there is plenty of room to show them all. Apparently this is an example of the couterproductive trend in recent years for coders to make screens "minimalist" in appearance instead of maximizing ease of use and functionality for users.
Thank you! How dumb for the programmers at Libra Calc to not make an easy and obvious way to print the grid lines.
he took 53 seconds to tell us to press shift F7. bro's yapping is unmatched
thanks a lot man! Btw I liked your UI very much, what is it?
Does'nt work for me. I get error messages or zero as an answer.
any way to add a strikethrough button on the toolbar?
Please help
The button didnt work when klick
tks for tutorial!!!
cool tuorial!!!
Only options : select all sheet Protect sheet View grid line Sheet events - are shown when i click on my sheet tab. Alt kry & left click din"t work either ... please help
How can I get my table to print on orientation landscape instead of portrait?
the information I needed, thank you very much!
This is a great tutorial, but it seems that I can only do a calculation only once. It will calculate the numbers together then if I want to add that answer to the original numbers it will just repeat that last number, Any ideas? Thanks.
Thank You So Much! When anything I have to read is that light I can't read it. Just a note to Mac users or maybe a different version of this awesome software. Go to preferences. In that list below personalization is application colors. Change it whatever color works for you. A tutorial never went this easy for me! Thanks.......Oops! Don't forget to click apply to. LOL.
SUBSCRIBED! I love how your LibreOffice vids are straight, well-thought out and to the point. I look forward to seeing if you have any content on LO Base
Works perfectly! Solved my problem. Thank you very much Office Nifty :)
I can’t get mine to print all the rows it’s printing20 I need 25
already out of date, this is nothing like libre calc now! 24.2.5.2
Thanks for sharing this knowledge!
Urgh! Many thanks, saved me quite a few hours formatting as I also couldn't find that setting until I watched this.
شكرا
Open office always shows the grid lines by default. Libre office has the OPTION checked to show the grid lines by default, but does not ACTUALLY show them, and no (format, cells, borders) or (tools, options, calc, view) option seems to show them. This makes it difficult to avoid run--ons between cells. Why does the actual screen not show the grid lines?
Ignore previous comment. I found it.
how can i calc percentage between 2 numbers in a pivot? example a column with 10 and another with 2 how can i say to the pivot table to show me how much percentage its representing that 2 from 10?
Thank you so much for your tremendous help!
Thanks so much you’ve just helped me solve a BIG problem for my school work!! Cheers 🎉
Very helpful. Thank you so much. Needed that.
About the second portion of your video, where we are copying multiple columns: ¿What if I only want to check columns A and B for duplication? That is, if columns A and B duplicate together but C, D, and E don't, I still want to delete the duplicate A & B row. This is because I've merged data from different sources and they may have discrepancies, and I only want to keep the first one.
Oh no man...i couldnt see niks, nada, niente. BO icon. Whqt icon. Do a close up for I eyes
this looks nothing like libre sheets wtf?
Bad tutorial
Thank you so much!
Thanks, that was useful. Would be great if you showed else if here or mention if the program allows it.
How do we do in two different sheet
Thanks! It works. It's kind of stupid of them to only allow you to right-click on the row number to hide the rows rather than right-clicking on the area and then choosing Hide Rows.
Thanks for leaving a comment, I appreciate it! 😃 Yeah I agree it would be more intuitive and user friendly if we could do it without moving the cursor all the way to left.
thanks alot , your video helped me a lot
Trying to find how to do this was a PAIN. I didn't know there was specific words for this like wrap. I kept trying to search, Fit, Match, and Size. So thank you.
I appreciate the help. Now I know LibreOffice is not the solution for me.
Not working.
Libre Tech Tips
can i pay you for a little help just looking for a way to create a formula like X - X / 2000
Yeah for sure! How can I contact you on social media? I don't know if youtube allows email addresses in comment, but you can try to email me *mrhlee* at *gmail* dot com
Thank you for your videos. My question is, is it possible to highlight a column of cells, and just have the system update the year? My cells are MM/DD/ and each year I copy business spread sheets and change all the data, but am generally entering data from a prior year, say it is 2024 and I need to enter data for 2023. Thanks in advance for any help.