How to Work with Trendlines in Microsoft Excel Charts

Micorsoft Excel logo.

You can add a trendline to a chart in Excel to show the general pattern of data over time. You can also extend trendlines to forecast future data. Excel makes it easy to do all of this.

A trendline (or line of best fit) is a straight or curved line which visualizes the general direction of the values. They’re typically used to show a trend over time.

In this article, we’ll cover how to add different trendlines, format them, and extend them for future data.

Excel chart with a linear trendline.

[mai mult...]

How to Create a Website Contact Form With Google Forms

Google Forms Header Image

Google Forms is a powerful tool used to create free surveys and quizzes online. However, that’s not all it does. With this guide, you can create a contact form which can be embedded directly into your website.

Creating a contact form on Google Forms is super simple. Google even has a template already made for you to use, which makes your job that much easier. All you need to do is load the template—customize it if you want—then embed the form directly into your website. That’s all there is to it. Let’s get started.

[mai mult...]

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