All the Best Google Sheets Keyboard Shortcuts

The Google Sheets logo.

No one likes to do things the hard way, which is why we have keyboard shortcuts! We’re going to look at the shortcuts you can use in Google Sheets to save yourself some time.

By no means is this a complete list of all keyboard shortcuts available in Google Sheets. We’ve limited our list to those that are more generally useful. There are plenty more you can explore if you can’t find what you’re looking for in this guide.

To open a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows and Chrome OS), Cmd + / (macOS) If you want to see the complete list, check out the Google Sheets support page.

[mai mult...]

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