I filter

Sorting and filtering data offers a way to cut through the noise and find (and sort) just the data you want to see. Microsoft Excel has no shortage of options to filter down huge datasets into just what’s needed. How to Sort Data in an Excel Spreadsheet In Excel, click inside the cell atop the column you want to sort. In our example, we’re going to click cell D3 and sort this column by salary. From the “Data” tab on top of the ribbon, click “Filter.” Atop each column, you’ll now see an arrow. Click the arrow of the column you wish to sort to bring up a menu that enables us to sort or filter the data. The first and most obvious way to sort data is from smallest to largest or largest to smallest, assuming you have numerical data. In this case, we’re sorting salaries, so we’ll sort from smallest to largest by clicking the top option. We can apply the same sorting to any of the other columns, sorting by the date of hire, for example, by selecting the “Sort … [Read more...] about How to Sort and Filter Data in Excel

DuckDuckGo is a privacy-focused search engine that’s been online since 2008. Find websites, maps, videos, news, and more—without tracking your searches and serving you targetted ads. Here’s how to make the switch from Google, Bing, or any other search engine. Most Browsers Already Include DuckDuckGo as a Search Option DuckDuckGo has been gaining ground for over a decade, finally breaking through to the “mainstream” in September of 2014 when Apple offered it as a default search engine option in Safari for iOS 8 and OS X Yosemite. Later, in November of the same year, Mozilla added it to Firefox 33.1. RELATED: What Is DuckDuckGo? Meet the Google Alternative for Privacy Since then, almost every major browser has recognized DuckDuckGo by making it an optional default search engine. This includes Chrome, Firefox, Safari, Edge, and Opera. Google Chrome Launch Chrome, click on the “three dots” menu icon in the top-right corner of the window, and click “Settings.” … [Read more...] about How to Switch to DuckDuckGo, a Private Search Engine

CES looked a bit different this year after going all-digital, but that didn’t stop companies from unveiling new products. After careful deliberation, the How-To Geek and Review Geek teams have awarded the following 11 products with How-To Geek’s Best of CES 2021 awards. Before jumping into the awards, Review Geek has been hard at work covering all of the CES 2021 announcements that you need to know about. Head on over there if you’ve missed anything from the internationally renowned trade show. Best in Show: Kensington StudioDock In order to stand out from everything announced at CES 2021 and win Best in Show, a product needs to make an entrance. The Kensington StudioDock did just that, causing most of the team to say, “I want that.” Using the StudioDock in conjunction with a Bluetooth keyboard and mouse, you can turn your iPad Pro or Air into an iPadOS iMac. Use the two built-in wireless chargers and the optional Apple Watch charger (which is coming soon) and … [Read more...] about Best of CES 2021: The Top Products Coming This Year

Ecosia is a not-for-profit search engine that uses advertising revenue gained from searches to plant trees. It doesn’t have the privacy-focus of DuckDuckGo , nor does it have the search results of Google. But it does have a unique mission. This search engine is getting bigger and more widely recognized. For example, starting with Apple’s iOS 14 and iPadOS 14 , Ecosia is one of the few options you can use as your default search engine in Safari. Google Chrome also includes it as a built-in option. Ecosia’s Main Mission Is to Plant Trees Ecosia is a not-for-profit search engine that aims to help the environment by planting trees. The search engine’s mission is to absorb as much CO2 as possible by planting trees to try and reduce the impact of climate change. This is done for the planet, for people, and for animals. The service acknowledges that trees can help empower and lift vulnerable populations out of poverty through the regeneration of depleted soils and … [Read more...] about What Is Ecosia? Meet a Google Alternative That Plants Trees

Pivot Tables are both incredibly simple and increasingly complex as you learn to master them. They’re great at sorting data and making it easier to understand, and even a complete Excel novice can find value in using them. We’ll walk you through getting started with Pivot Tables in a Microsoft Excel spreadsheet. First, we’ll label the top row so that we can better organize our data once we apply the PivotTables in a later step. Before we continue, this is a good opportunity to get rid of any blank rows in your workbook. PivotTables work with blank cells, but they can’t quite understand how to proceed with a blank row. To delete, just highlight the row, right-click, choose “Delete,” then “Shift cells up” to combine the two sections. Click inside any cell in the data set. On the “Insert” tab, click the “PivotTable” button. When the dialogue box appears, click “OK.” You can modify the settings within the Create PivotTable dialogue, but it’s usually unnecessary. … [Read more...] about How to Use Pivot Tables to Analyze Excel Data