Advanced Filter in Excel

How To : Format dates with the WEEKDAY function in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEE ...more

How To : Create dynamic sub tables in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub ...more

How To : Alphabetize in Excel

Need to sort a ton of data in Excel? Why waste time cutting and copying cells? In this tutorial, learn how make Microsoft Excel automatically sort columns or rows alphabetically. You Will Need: • Microsoft Excel • Data to be alphabetized Step 1: Select a row or column Click ...more

How To : Make Firefox faster on your Mac or PC

This video shows how to change the advanced settings to make Firefox faster on Mac and PC. Firefox with it's default settings is a bit slower while accessing web pages and loading them. To make it faster, there is a way which is shown in this video. To do this open your Firefo ...more

How To : Use the New Features in Windows Live Hotmail 2011

Hotmail just isn't the same anymore— it's better! In the just-released Windows Live Essentials 2011 from Microsoft, Windows Live Hotmail 2011 is jam-packed full of new features. The new Hotmail makes emailing easier than ever before, allowing you to cut through the inbox clut ...more

How To : Distribute one cell across multiple cells in Excel

Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as country/region or city. However, if you break up the address into its parts — street address ...more

How To : Create Bokeh Images on Your iPhone

In light of this week's Giveaway Tuesdays Photo Challenge, we've posted a thorough guide to experimenting with bokeh photography. Most of the resources require a DSLR camera, and an intermediate understanding of some of the more technical components of photography. If you don ...more

Camera Plus Pro : The iPhone Camera App That Does it All

Even with Apple's forthcoming iOS 5 updates to its default camera application, those upcoming features can't match what already exists in Global Delight's Camera Plus Pro. For $1.99, Camera Plus Pro provides users with over 100 tools for every part of the picture taking proces ...more

How To : Make Excel Work for You with This Training Bundle

Microsoft Excel is one of the most widely used tools in the professional sphere. It's also one that's difficult to master beyond a superficial understanding of how to input data. The All-In-One Microsoft Excel Certification Training Bundle can teach you how to make this multif ...more

How To : Master Excel with This Certification Bundle

Microsoft Excel is one of the most useful tools you can bring into your professional life. However, as useful as Excel is, it can also be difficult to learn on your own. The All-In-One Microsoft Excel Certification Training Bundle is an incredible tool that will take you from ...more

How To : Hack Your Business Skills with These Excel Courses

For over three decades, Microsoft's landmark program, Excel, has helped businesses accomplish tasks and problem solve quickly and efficiently. Whether you're a budding entrepreneur or navigating a remote career, Excel can help you apply your business skills at a higher level. ...more

How To : Filter Potential Matches on Bumble

Despite Tinder's tremendous popularity, Bumble has carved out a billion-dollar business by focusing on women (they message first), simplicity (ice breakers less wordy than OkCupid), and relationships past romance (friends and prospective jobs). Now they're diving into customiz ...more

How To : Beat LFI Restrictions with Advanced Techniques

One of the most common web application vulnerabilities is LFI, which allows unauthorized access to sensitive files on the server. Such a common weakness is often safeguarded against, and low-hanging fruit can be defended quite easily. But there are always creative ways to get ...more

How To : Master Linux, Python & Math with This $40 Bundle

IT is a competitive field, and finding success requires more than knowledge of a couple of coding languages or knowing how to google really well. To stand out among your peers and competitors, you should learn everything you can and get as much diverse experience as is availab ...more

News : Everything You Need to Know About the iPhone XS

Apple's successor to the iPhone X is a beautifully made smartphone with much of the same characteristics, including a 5.8-inch OLED screen, two storage choices, and Face ID. But many features set the iPhone XS apart from its predecessor, as well as the other 2018 lineup of iPh ...more

How To : Find & extract duplicate records from a data set

This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or ...more

How To : All the Apps You Need to Make That Perfect Story

Stories are everywhere in social media today, but that wasn't always the case. In 2013, Snapchat introduced the world to these temporary windows into our daily lives. Since then, stories have infiltrated other popular apps. However, to stand out, you can't solely rely on the a ...more

How To : The Best Video Chat Apps to Use with Your Infant

You know your infant is advanced. Maybe you want to give her or him a head start at learning things like writing code to develop the next big Fortnite game. Or maybe you just want to play Fortnite with your infant. But the American Academy of Pediatrics discourages screen time ...more

News : The 5 Best Free Twitter Clients for iPhone

Twitter's official iOS app is adequate if you're not much of a tweeter, but if you are, there's a lot of useful features that are missing. Luckily, there are plenty of free Twitter clients available that you can use on your iPhone. These third-party apps have features such as ...more

How To : The Best Video Recording Apps for Your iPhone

If you have a modern iPhone, you have an excellent video recorder at your disposal. Every iPhone since the 6S has the ability to shoot in 4K resolution, and each new iteration has brought new capabilities to the table. But even the best mobile shooter can use a little extra he ...more

How To : Watch the 2011 Super Bowl Commercials Online

It's that time of year again when pizza boxes line the room and buffalo wings stain the couch. When cases of beer sit in the cooler and the big screen TVs are fired up and properly calibrated. When two of the best football teams vie for the championship title and the Vince Lom ...more

How To : Create glitch type drum effects in Reason 3.0

This music production software tutorial shows you how to create Glitch-type effects for use with your drum patterns in Reason 3.0. It is an advanced tutorial only because of the speed at which he has to cover the material. In this example Ace Pincter will be adding glitch effe ...more

How To : Unblock YouTube in 2 easy ways

If you are stuck using a computer in a place with safety filters, you can use this tutorial to bypass those controls and get to your YouTube account. So, whether you are in a school, library or your parents have parental controls activated, just follow along and you will be ab ...more

How To : Simulate a ray of light in Photoshop

Photoshop Universe shows you how to add a simulated ray of light to your photos. They give you advice on how to use levels, the radial blur filter, and the lighten color blend mode. You can give your pictures a nice added touch by learning this simple and easy to understand te ...more

How To : Replace the fuel filter in a Saturn S-Series car

One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple ...more

How To : Dominate the New York Times Crossword Puzzle

First off, don't be frustrated. YOU CAN DO IT! Contrary to the message in the image above, it's NOT over. It's just beginning. And when it comes to solving the New York Times crossword puzzle, the old cliche does apply: practice makes perfect. I've read quite a few books and ...more

  • Hot
  • Latest