How to Make an Excel Pivot Table Our guide continues below with additional information on how to create a pivot table in excel 2010, including pictures of these steps. I was recently downloading a lot of CSV orders from a customer, which I then combined into one file using the CSV file combination process in this article. However, all of the data from those orders was itemized, and our production team needed each item combined into one line so that they knew how much of each item to produce....

Using the Outlook Desktop App Launch Outlook from the Office suite and select the calendar. Then, double-click the first day when you plan to be out of the office. In the window that comes up, enter the reason you will be out of the office in the Subject line. Then select the appropriate start time when you will be gone and the time when you will return. After that, make sure to recheck the “All Day Event” box....

You can get ahead of the game by creating filters from scratch. Then when the emails start pouring in, they’ll go to a folder, be marked, or get labeled, making it easier to manage your inbox. Access Gmail Filters in the Settings To set up a filter, open your Gmail settings. Click the gear icon on the top right and select See all settings in the sidebar. Choose the Filters and Blocked Addresses tab and click Create a new filter....

If you’re still contemplating switching to the new Outlook or have done so recently, we’ll show you how to customize the toolbar. This includes your main Outlook screen and the email, calendar, and contacts sections. Customize the Toolbar in Outlook on Mac You’ll follow the same steps for each spot where you can customize the toolbar in Outlook on Mac. The difference you’ll see is the options available for the toolbar in each spot....

When you become friends with someone in Pokemon Go, you open entirely new areas of the game that let you make significant progress by increasing your level, increasing your raid power, and trading for better Pokemon. But there is a maximum number of friends that you can have in Pokemon Go, and people with whom you are friends can see some information about your play habits. If you discover over time that you no longer wish to be friends with someone in Pokemon Go, it’s possible to remove them as a friend in the game....

Deleting iTunes TV Episodes from the iPhone 5 Perhaps you have already stumbled upon the menu that you need to use to remove your videos, but you were nervous that deleting them would force you to forever lose access to the iTunes episodes you have purchased. Fortunately this is not the case, and you can re-download or, in the case of Apple TV, stream those episodes through your TV. So, with this knowledge in hand, you can proceed with the steps below to remove old episodes from your phone and give yourself more space for additional files....

Remove All of Your Songs from Your iPhone 5 Note that there is no way to undo this action once it has been completed, and you will need to re-add the deleted songs through iTunes if you decide that you want them on your phone again. You can also download previous music purchases again (in some countries) directly from the phone, but that is usually slower than importing from iTunes....

Fortunately this is something that you are able to do through the app, and clearing the Chrome iPhone browsing history can be finished with just a few steps. Our tutorial below will show you how. How to Clear History in the iPhone Chrome Browser The steps in this article were performed on an iPhone 7 Plus in iOS 10.3.3. Note that this will delete the entire browsing history from your Chrome browser....

There are a number of different Google services where you might see a profile picture that you had set in the past. Depending on what you chose for that picture, there may come a time that you want to switch to a different picture, or even remove the picture completely. Luckily it’s possible to delete your Google Profile picture and stop it from appearing in locations where others can see it....

Fortunately you aren’t stuck with an add-on forever after you install it, and you can elect to disable it if you aren’t using the add-on, or if you simply need to turn it off briefly. Our tutorial below will help you find the add-ons menu in Firefox so that you can disable any of the installed add-ons that you wish. How to Disable a Firefox Add-On The steps in this article were performed in the desktop version of the Mozilla Firefox Web browser....

Internet Explorer has some built-in tools to protect your privacy and try to keep you safe on the Internet. One of these tools is a pop up blocker. Some sites use pop-ups in a malicious way to try and sneak dangerous content on to your computer. By blocking these pop-ups, Internet Explorer is able to make your browsing experience a little safer. Since the majority of pop-ups are harmful, most browsers will block them by default....

Unpairing your Apple Watch is fairly simple to do; you can do it from your iPhone, or even on the watch itself, although you’ll still need to turn off the Activation Lock elsewhere. If you’re ready to unpair your watch from your iPhone, then learn how to disconnect your Apple Watch below. How to Disconnect Apple Watch from an iPhone The easiest way to unpair your Apple Watch from your iPhone is through the Watch app on your phone....

If you are switching phones or if you have upgraded to a newer iphone model, then you may need to know where to find and how to do an iPhone SIM card removal. How to Take Out the iPhone 13 SIM Card Our guide continues below with additional information on how to perform an iPhone SIM card removal in an iPhone 13, including pictures of these steps. A SIM card (subscriber identity module) is a tiny little card that identifies your phone and lets it connect to your cellular provider’s network....

Using Private Browsing in Firefox Whether you are using a shared computer, or you simply do not want anyone who uses Firefox on your computer to know some sites that you have visited, private browsing is a very helpful tool. Additionally, you can launch a private browsing session with ease, and Firefox provides a simple indicator that lets you know whether a session is private or not. Once you have completed a private browsing session, you can close out the window like normal....

The Spotify app has a large selection of podcasts, including many of the most popular shows that you might be interested in listening to. Podcasts are great to listen to while you’re in the car, working, or exercising. But if you are going to be traveling, or in a situation where you know the Internet will be poor, then you might be trying to download files to listen to offline....

If you’re sick of the current sound that you hear when you get a call, then our how to change ringtone on iPhone 13 guide can show you how to use something different. Downloading Purchased Music on the iPhone 5 The music that you have purchased through iTunes is tied to the Apple ID that you used to purchase it. This means that the music available to you will depend upon which Apple ID you are currently signed in with on your iPhone....

How to Download Google Docs to Word Our article continues below with additional information on how to download Google doc to Word format, including pictures of these steps. While a lot of schools and organizations are making the change to online document editors like Google Docs, you may still need to create a Microsoft Word file from time to time. Fortunately, you can learn how to download from Google Docs as a Microsoft Word file....

But perhaps one of its most useful features involves a menu called the Control Center. You can access this by swiping up from the bottom of the screen ( or swiping down from the upper right corner of the screen on iPhones without a Home button.) Here you will find the Calculator utility, as well as a bunch of other useful tools that you might have been getting to in a different way before....

How to Turn the iPhone Autofill Passwords Option On or Off Our guide continues below with additional information on enabling or disabling password autofill on an iPhone, including pictures of these steps. If you use Google Chrome on your laptop or desktop, then check out our view saved passwords guide and find out more about managing passwords in that app. Your iPhone 7 provides access to your favorite apps and services, (such as location services that can help you if you forget your Airpods,) many of which require passwords to use....

But if you do a lot of running in cities or neighborhoods, you may need to occasionally stop for traffic lights or passing vehicles. These stops can extend the length of your run, and make your pace seem worse than it actually is. If you would like to be able to evaluate your running workouts based solely on when you were actually running, then learn how to enable the auto pause feature for running workouts so that the watch will pause your workouts when it senses that you have stopped moving....