Blogroll

Excel has “Sort A to Z” and “Sort Z to A” features that let you sort values alphabetically or numerically, and a “Custom Sort” feature that lets you sort using multiple criteria.  Here’s how to use them.

Let’s Look at an Example

In this example, we have chosen nine chemical elements from the periodic table, and we will sort the data based on the cell contents using the “Sort A to Z” feature and the “Custom Sort” feature.

The “Sort & Filter” drop-down is located on the far right of the “Home” tab.

The drop-down has several features listed, but we are focusing on the first three.

Here is our example data, taken from the periodic table. Each “Element” has information that is unique to it, such as its “Symbol” and “Atomic Number.”  But each element also belongs to other categories, such as its “Phase at STP” (i.e., whether it is a solid, liquid, or gas in a room at standard temperature and pressure) and its “Element Category” on the period table.

Read the remaining 40 paragraphs

YouTube is changing its "strike" policy in an effort to make it easier to understand.

With the changes, first-time offenders who violate YouTube's policies will receive a warning instead of a "strike," which carries more serious consequences. The new policy will take effect next week, beginning Feb. 25. 

SEE ALSO: This was YouTube's most viral video of 2018

YouTube's strike system is the main way the service polices content on its platform. Creators get strikes when they violate the company's policies, such as those prohibiting harassment and hate speech, for example.

"We want to give you even more opportunities to learn about our policies, so starting February 25, all channels will receive a one-time warning the first time they post content that crosses the line, with no penalties to their channel except for the removal of that content," the company wrote in a blog post.  Read more...

More about Tech, Google, Youtube, Tech, and Big Tech Companies

It's been nearly six years since the series finale of  The Office aired on NBC, but the workplace comedy still has an extremely dedicated fanbase.

To kick off 2019, amidst passionate pleas for an Office reboot, Funko decided it was finally time to release a collection of adorable Pop! figures inspired by some fan favorite Dunder Mifflin employees.

The figures debuted at the 2019 New York Toy Fair — along with figures inspired by Shazam!, Post Malone, Dragon Ball Z, and more — and as a die-hard Office fan, I can honestly say they look damn near perfect.

ICYMI: The Office Pop!s are on the way! #FunkoTFNY https://t.co/P0ufsDMkXA pic.twitter.com/ImMcfeAQ73

— Funko (@OriginalFunko) February 17, 2019 Read more...

More about Television, Culture, The Office, Toy Fair, and Funko Pop

Maybe you've already yeehaw-ed your way through 100% completion of Red Dead Redemption 2, Rockstar Games' recent western masterpiece; maybe you've only seen the in-game screenshots that have been snuck onto r/EarthPorn. Either way, anyone who's even remotely into gaming knows that RDR2 is unrivaled graphics-wise, which begs an important question: HOW?

Like many other leading gaming companies — Electronic Arts and Ubisoft, to name a couple — Rockstar has made its game engine a proprietary software. (Translation: It isn't available for us plebian developers to use.) But that doesn't mean you have to dash your dreams of creating the next RDR2 just yet: There are plenty of game engines out there that are free for anyone to download and use. Read more...

More about Development, Video Games, Mashable Shopping, Shopping Stackcommerce, and Shopping Solo

While you can get away with plugging your HDTV Antenna straight into your TV, a separate tuner opens up so many more possibilities. A tuner adds some upfront cost, but also a huge benefit for cord cutters.

Your TV (most likely) has a tuner built-in, but having an external tuner means you can split the signal from the antenna into a number of different channels. Different models of external tuners have different numbers of individual internal tuners and this indicates the number of concurrent streams it can handle.

For example, if you have a four tuner model, you can watch four different channels on four different screens—or watch three different channels on three different screens while using the fourth tuner to record another program. Or, perhaps more practical to most people, you can watch one channel while other people in your household watch different channels (or you record those channels for later viewing).

Tuners will connect to your home network with Ethernet or Wi-Fi, and the manufacturer of the tuner will offer an application to watch the live stream on most platforms. Some tuners have hard drives built-in to record shows, or you can record straight onto your Plex server.

HDHomeRun Connect Quatro ($150) Silicon Dust

This unit features four tuners inside, just as the “quatro” name implies. It features one coaxial jack to connect to your antenna and an Ethernet jack to connect to your home network. I’ve personally used this tuner to record and stream live TV with Plex, and it set up in an instant. If you don’t have a Plex subscription, HDHomeRun has a live TV app for every platform imaginable, as well as a website. If you want to use their software as a DVR, however, be forewarned that there is a $35 a year subscription cost that includes both their multi-platform software as well as a TV-guide type system—a Plex Pass will run you $40 a year or $120 for a lifetime subscription and many people prefer their live TV interface and recording system.

The Connect Quatro is currently bundled with a 30-mile OTA antenna, but it’ll work with any antenna. Set up is a breeze: connect the coaxial cable from the antenna, connect it to your network, plug it into power, and let it scan your channels. That’s it!

Buy on Amazon Amazon Fire TV Recast ($230-$280) Amazon

If you’re all in on Amazon’s ecosystem (or Echosystem, if you will), the Fire TV Recast will be a natural fit in your home. The Fire TV Recast comes with either two tuners and a 500GB hard drive (good for 75 hours of recording), or four tuners and a 1TB hard drive (good for 150 hours). There’s a $50 difference between the two, which isn’t trivial, but it’s also not an exorbitant amount if you want to give yourself some spare capacity.

RELATED: Should You Buy the Fire TV Recast?

Read the remaining 10 paragraphs

The trailer for Leaving Neverland has arrived, giving a dramatic glimpse at the documentary about two men who allege that they were sexually abused by Michael Jackson when they were children.

Leaving Neverland, which premiered at Sundance in January, looks at the stories of two men, Wade Robson and Jimmy Safechuck, who were invited to Jackson's Neverland Ranch and were allegedly abused repeatedly by the pop star starting at the ages of 7 and 10.

Leaving Neverland was picked up by HBO, which will air the documentary in two parts on March 3 and 4. Read more...

More about Movies, Hbo, Documentary, Michael Jackson, and Leaving Neverland

This piece is part of an ongoing series exploring what it means to be a woman on the internet. 

On Twitter, a place where a lot of bad things happen, there's a mostly harmless but decidedly annoying phenomenon. A lot of people, mostly women, have noticed that one or two men always, no matter what, reply to their tweets. 

These men are colloquially known as "reply guys." While no reply guy is the same — each reply guy is annoying in his own way — there are a few common qualities to watch out for. In general, reply guys tend to have few followers. Their responses are overly familiar, as if they know the person they're targeting, though they usually don't. They also tend to reply to only women; the most prolific reply guys fill the role for dozens of women trying to tweet in peace.  Read more...

More about Twitter, Feminism, Social Media, A Woman On The Internet, and Reply Guys

It's common knowledge that April 15 is D-Day for tax season, yet an estimated 20 to 25% of Americans will wait 'til the last two weeks before that deadline to start prepping their returns. (Y'all like to live on the edge, huh?)

Pro tip: Don't be like 20 to 25% of Americans. You can get your taxes out of the way fast with the help of TaxSlayer, an intuitive online tax prep service that's currently offering Mashable readers sweet deals on three of its plans. 

Save 29 percent on your choice of the following options: 

TaxSlayer Classic

Behind Door No. 1 is TaxSlayer Classic, a plan highly rated for best value and ease of use, which tracks down all the tax breaks you can get for kids, other dependents, home ownership, and retirement income with your Schedule A. It'll guide you through the process of successfully e-filing an individual federal tax return for all tax situations and with no form restrictions, guaranteeing 100% accurate calculations and a maximum refund. It also gives you the option of auto-filing your return using your W-2 or last year's info to save tons of time and comes with a year's worth of IRS notices. Read more...

More about Taxes, Mashable Shopping, Shopping List, Shopping Skimlinks, and Shopping Stackcommerce

It was the first-ever video game to fetch a six-figure mark for a vintage video game sale. Read more...

More about Mashable Video, Super Mario Bros, Video Game Auction Record, Auction Super Mario Bros, and Sealed Copy Super Mario Bros

The French Fencing Federation has decided to let Jedis shine, and is making the iconic Star Wars-themed battles subject to professional judging. These are the rules: Two fighters duel it out inside a circle marked in tape. A hit to the head or body is five points. Read more...

More about Mashable Video, France, Star Wars, Lightsaber Duels, and French Fencing Federation

Read more...More about Mashable Reels, Dating Shows, Entertainment, and Movies Tv Shows

Although doing your taxes is intimidating and tedious, it's something everyone has to complete before the April 15th deadline. 

However, H&R Block Tax Software Deluxe + State 2018 can walk you through the process and help you get the most out of your return to get the biggest refund possible. Luckily, the software is now on sale for just $18, or $26.99 off its list price on Amazon. This is the lowest price the online retailer has ever offered for this product.

SEE ALSO: Congress may be divided on taxes, but it's finally united in its war on faxes

Normally retailing for $44.99, H&R Block is a wonderful do-it-yourself and simple option to maximize your refund for 2018. Just import your W-2, 1099, or 1098 forms and H&R Block will go step-by-step to help you file your federal and state taxes on time.  Read more...

More about Taxes, H R Block, Mashable Shopping, Shopping Amazon, and Shopping Solo

Tab addicts, rejoice!

If you're a tab-loving Chrome power user, a simple extension can give you the power to speed up your computer instantaneously. The folks at BGR recently called our attention to the extension OneTab, and we had to spread the word. 

Having multiple tabs open eats up RAM and CPU resources, two components that contribute to the speed of your machine. Ever hear the fan start whirring as you open 17 more tabs with articles to read later? That's your computer getting overloaded with the multiple digital balls it has to juggle, causing it to slow down.

The extension OneTab essentially caters to your tabs habit, managing RAM and CPU resources, while assuring you that you won't lose the link to that 2,500 word think piece you swear you're going to read later.  Read more...

More about Google Chrome, Ram, Cpu, Tabs, and Mozilla Firefox

(Reuters Health) - Only a small fraction of cancer patients volunteer for clinical trials. The reason, a new study suggests, is not that they don't want to, but that the system makes it too hard.

Alphabet Inc's Google said on Tuesday it will buy data migration company Alooma, as part of efforts to catch up with bigger cloud service rivals Amazon.com Inc and Microsoft Corp.

All eyes are on Samsung once again.

Ten years after launching its first Android-powered Galaxy phone to challenge Apple's iPhone, the Korean electronics giant is expected to pull out all of the stops for the Galaxy S10 at its Unpacked event in San Francisco on Feb. 20.

SEE ALSO: Welp, we now know almost everything about Samsung's Galaxy S10 lineup

Mashable will be live on the ground covering everything Samsung announces at the event. Yan also watch Samsung's official livestream here when it starts at 2:00 p.m. ET/11 a.m. PT.

OK, now that we have all of the logistics out of the way, what are we realistically expecting from Samsung's big event? Read more...

More about Mobile, Android, Samsung, Unpacked, and Foldable Phone

Everyone hypes up high-end laptops, but here's the thing: Not everyone needs to drop $1,000 plus on one.

And while we love our MacBooks and Razers here, people who aren't doing massive work projects or graphics-heavy gaming could manage to save a lot by grabbing a Chromebook instead. And this well-reviewed one from Lenovo is $120 off today, making it just $179.

Image: lenovo

Lenovo has joined the ranks as one of the best laptop brands and frankly, deserves just as much credit as the Apples and Dells of the world. Their mega low prices don't look like it, but these affordable devices get more love than a lot of higher-priced competitors. The Lenovo Chromebook S330 (81JW0001US) is great for daily computing, watching Netflix, and other day-to-day laptop stuff, featuring a 1080p FHD display and 1.70 GHz processor. Read more...

More about Lenovo, Chromebooks, Mashable Shopping, Shopping Skimlinks, and Shopping Solo

An Ode to... is a weekly column where we share the stuff we're really into in hopes that you'll be really into it, too.

Twitter is the very definition of "too many cooks in the kitchen," but breaking the platform down into sections and focusing on your own specific interests makes it significantly more bearable.

People who are passionate about government issues, for example, can follow Politics Twitter. Those looking to promote their businesses in a cheesy fashion can engage with Brand Twitter. And rom-com obsessed hopeless romantics like myself, who aren't afraid to share their hearts on their timelines, have Crush Twitter.  Read more...

More about Twitter, Memes, Relationships, Web Culture, and Crush

The moment I started seriously worrying about credit card and debit card skimmers wasn't when my entire bank account was transferred to Turkey, or when I had to replace a credit card three times in two months because of fraudulent charges. It was when I learned that stealing a credit card number is as easy as plugging in a magnetic strip reader into a computer and opening a word processor. Every swipe spit out the credit card number, with no extra setup required. More advanced devices to steal your information are installed by criminals directly on to ATMs and credit card readers. These are called skimmers, and if you're careful you can keep from being victimized by these insidious devices. Read more...

More about How To, Cyber Security, Credit Card Skimmers, Tech, and Cybersecurity

Netflix Inc said on Tuesday it is creating a production hub with two studios in Toronto that is expected to create 1,850 jobs per year.