Aplicații

E-mail 948 Solutii

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 Change Your Apple ID Email Address

If you get a new email address or no longer have access to an old one, updating your Apple ID is important for protecting your account. Here’s how to update your Apple ID.

Changing the email address you use as your Apple ID isn’t difficult under the right circumstances. If your Apple ID is a third-party email address, such as gmail.com or outlook.com, you can choose another third-party address when changing your Apple ID. But if your Apple ID is an Apple email address, like icloud.com, you’re unlikely to be able to change your Apple ID at all.  We’ll cover that scenario in more detail below.

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