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...]

How to set up a Raspberry Pi module with default settings

Raspberry Pi is a single board, low powered single board computer available for a very low price. It is one of the best boards to build solutions that come under the Internet of things or IoT. It comes out of the box with an operating system calls as NOOBS which comes out as New Out Of the Box Software. In this guide, we will be taking a look at how to set this default environment up for a new Raspberry Pi board.

How to set up a Raspberry Pi module with default settings

We will talk about the following aspects of setting up the Raspberry Pi module with default settings:

  • The Power Supply
  • The Storage.
  • Input devices.
  • The output display.

These are the minimum components that will help you in setting up the Raspberry Pi module. In addition to these, you can also connect a case, ethernet connection, and more.

The following will be the steps to get Raspberry Pi ready:

  1. Get the SD Card ready.
  2. Powering on the Raspberry Pi.
  3. Setting up the environment.
[mai mult...]