Tutorials

How to Calculate Fields in Pivot Tables in LibreOffice Calc

You can calculate fields in LibreOffice Calc by adding a custom formula to a pivot table. The calculated column becomes part of the table,...

Create Hyperlinks in Microsoft Word with Ctrl+V

https://youtube.com/shorts/OpnMOJMYAc4 You can create hyperlinks in Microsoft Word by copying a URL, highlighting your text, and pressing Ctrl+V. Word adds the hyperlink directly to the...

Print Specific Pages and Selected Text in LibreOffice Writer

https://youtu.be/a1rj47UdsyQ You can print specific pages in LibreOffice Writer by choosing Pages in the print dialog and entering the page numbers or ranges you want....

Excel Slicers for Tables: Filter Without the Drop-Down

https://youtube.com/shorts/PEyZhzqf75w Subscribe for More Tutorials ...

How to Remove Blank Rows in Excel in Seconds

https://youtube.com/shorts/MxQWNYSnThE Blank lines can turn a clean worksheet into a cluttered mess. If you're trying to filter, sort, or build a pivot table, those gaps...

Automatically Bold Totals in Excel (No Tables Required)

Totals should not depend on row numbers, and you definitely shouldn't be formatting them manually. When you have about 200 rows of data (and...

Paste Special Not Working in Excel? Full Troubleshooting Guide

https://youtu.be/-GtA23bz4Y4 When Paste Special is not working in Excel stops you mid-task, it feels like Excel is just refusing to cooperate. You copied the data,...

Excel Row Numbering: 2 Ways That Update Automatically

We need to number our rows, but we have no idea how large our data set's gonna get. That's why Excel row numbering needs...

Quick Way to Add Leading Zeros in Excel

https://youtube.com/shorts/upVL8oU3Hzg Employee data can look perfect until you notice the ID column. You expect a six-digit ID number, but Excel shows something shorter because the...