List Public Search Results

How To: Eject devices from the use of the terminal for a Mac

In this tutorial, we learn how to eject devices from the use of the terminal for Mac. First, go to the terminal of your computer where you will see a notepad sort of page. Next, type in "df" and then press return. You will now see a list displaying processes on your computer. On the bottom will be your public zoning device, which is your USB device. Next, type in "hdiutil eject -force (the code under "mounted on)- volumes-publiczone". This is not case sensitive, but don't forget or add in any...

How To: Perform the "flying" card trick

As far as your audience is concerned, there are few things less magical than a card trick seen a dozen or more times. As such, as a magician, it's important that you build a strong repertory of tricks to maintain your public's interest. And what better place to start than the "flying" card trick outlined in this free video magic lesson.

How To: Make a shrinking data validation list in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.

How To: Use Yelp Collections to Find New Places & Keep Your Bookmarked Locations More Organized

In the past, if you stumbled upon a Yelp listing you liked, you could bookmark it and check it out later on your profile. You can still take advantage of this feature in the mobile apps, but it's more refined now than it ever was thanks to Collections, a feature Yelp first added back in May 2018. You get more power over organizing, accessing, sharing, and discovering favorite businesses.

How To: Follow Businesses on Google Maps to Stay Updated on Events & News for Your Favorite Spots

When you need to know how to get somewhere, Google Maps is the app to beat, but the king of navigation doesn't want to stop there. Google aims to make its navigation app for more than just directions, as made clear by its recent feature that lets you follow businesses in the app. Combining timely news and events posted by local businesses with real-time transit seems like the perfect match.

How To: View a hidden friends list on MySpace

MySpace gives users the ability to hide their friends list. This video walks you step by step through being able to view this list. First, go to the desired profile. You'll see the hidden friends list. Now, click on "Edit with notepad" and code will pop up on your notepad. Because the list is on the page, editing the source code will make the list appear on the page. Next, type the command >table border=0 cellspacing=0 align="center">. Now you'll be instructed on how to delete the source code...

News: Apple Just Released iOS 12.3 Public Beta 2 for iPhone, Features Small Updates to Wallet & Date/Time

Apple just released the second public beta for iOS 12.3 today, Tuesday, April 9, one day after the release of the iOS 12.3 developer beta 2. This update introduces new Japanese "Date & Time" updates as well as changes to Wallet transactions. Overall, iOS 12.3 includes Apple TV Channels, premium monthly subscriptions with content available directly in the TV app across the Apple ecosystem.

How To: The Easy Way to Use PGP for Encrypting Emails on Windows, Mac & Linux

In order to increase the security and harden the integrity of an email account and its content, you'll want to use PGP on your Windows, macOS, or Linux computer. This is usually the first thing security analysts do to protect communications with encryption, and everyone else should consider it too, especially since there's an easy way to incorporate PGP that anyone can follow.

How To: Create your favorites list on an iPhone

In this video, we learn how to create a favorites list on an iPhone. Doing this will make it easier and quicker to speed dial! First, just tap on the "favorites" button. Then, click on the "+" button to add a new favorite from your contacts. You can then click "edit" to rearrange or remove favorites from your list. Click on the blue arrow next to a name to see the full contact details for that person. As soon as you add or remove someone from your favorites it's saved. That's all you need to ...

How To: Sort Excel data in custom order

This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...

How To: Merge two list tables and delete duplicates in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 381st installment in their series of digital spreadsheet magic tricks, you'll learn how to merge two lists into one list while keeping unique items from list 1 and list 2 and removing duplicates.

How To: Check whether quantities are equal in two lists in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.

How To: Create Custom Netflix Watch Lists for Categories & Genres, Then Say Goodbye to Your Overcrowded 'My List'

One of the biggest bummers about Netflix is the inability to create different lists for your favorite movies and TV shows. Instead, you're only able to lump titles into the single default "My List," and that can be impossible to browse. It doesn't separate titles into categories or genres, and titles are arranged for you automatically, so there's not much room for customization.

How To: Track Your Lost iPhone, iPad, or Mac Even When Its Offline — As Long as This Feature Is Enabled

Apple's latest updates to its operating systems add another security feature to its Find My service, so you have an even better chance at locating your lost iPhone, iPad, or Mac should it ever happen. As long as you have the option enabled, you can leverage other Apple users' devices to find yours on the map.

News: Apple Releases iOS 12 Public Beta 10 for iPhone, Fixes Bug Constantly Telling You to Update

If you've been getting that "Please update from the iOS 12 beta" alert continuously in iOS 12 public beta 9, Apple just issued a fix for it Friday, Aug. 31, with iOS 12 public beta 10 — just in time for Labor Day weekend. This marks the second update this week as dev beta 11 and public beta 9 were released on Monday. It's also just one day after Apple announced its Sept. 12 event.

Digital Tinfoil Hat: How to Block the Government & Other Privacy Invaders from Connecting to Your Nexus 7 Tablet

The NSA's massive internet spying efforts will continue. In President Obama's latest press conference, he went public to (in so many words) say that the NSA's spying efforts will continue uninterrupted. This, coming just weeks after the Amash Amendment which would have defunded the program, was narrowly defeated in the House (you can check if your congressmen voted against it here).

How To: Create a nested unique list via a pivot table in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 250th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales representatives using a pivot table (PivotTable).

How To: Create a list of hyperlinks in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.

How To: Storyboard, make a shot list, line your script, and schedule a film production

Measure twice cut once applies to filmmaking as well as construction or any other complex process really, and that's why preproduction is they key to actually finishing your film on time and budget. This video will help you with several preproduction tasks, including storyboarding, making a shot list, lining / timing your script, and scheduling the actual production of the film.