Configurare program

How to Cross Reference Cells Between Microsoft Excel Spreadsheets

excel logo

In Microsoft Excel, it’s a common task to refer to cells on other worksheets or even in different Excel files. At first, this can seem a little daunting and confusing, but once you understand how it works, it’s not so hard.

In this article, we’ll look at how to reference another sheet in the same Excel file and how to reference a different Excel file. We’ll also cover things like how to reference a cell range in a function, how to make things simpler with defined names, and how to use VLOOKUP for dynamic references.

[mai mult...]

How to Use Siri to Control Your Apple TV From Your iPhone

Smart homes are best when controlled using just your voice. Siri can already control your lights, plugs, and more. You can use it to control your Apple TV, too. Here’s how to survive the next time you lose the remote.

Apple knows that when you’re watching TV, you’ve probably got your iPhone nearby. That makes it the perfect remote control, but nowadays nobody wants to push buttons. Voice control is where it’s at, and with Siri, you can choose what to watch and then control it, too. Barking orders at your TV might make you look like a crazy person, but it’s surprisingly fun.

[mai mult...]

How to password-protect and secure your documents with LibreOffice

LibreOffice is a free popular office suite used by many. It is an open source application program which shares most of the features similar to Microsoft Office. LibreOffice offers a simple interface and rich tools to increase your productivity. Like Microsoft Office, LibreOffice can be used to create professional looking documents like brochures, marketing reports, newsletter, thesis, technical drawings and many more. LibreOffice is mostly popular among open source fraternity because of its open standard, and the office suite is compatible with most of the documents formats like PowePoint, Excel, Microsoft Word, etc. If you are using Libre office currently and want to secure the information with a password, you are in the right place. One good thing about LibreOffice is that it takes the security level one step forward by making encryption easy and allows its users to encrypt all the sensitive documents using strong AES encryption. LibreOffice allows its users to  Password protect the documents effortlessly so that one can make sure that the unauthorized users will not be able to open your important documents. In this article, we explain how to secure and encrypt your documents with LibreOffice.

[mai mult...]