Since getting our hands on the Magic Leap One last week, we've been methodically delving into each feature and reporting our findings step-by-step. Earlier this week, we took a look at the Screens app (a video viewer) and the Helio app (an AR web browser). This time around, we'll be digging into the Create app, the experience that allows you to fill the real world with objects that transform the nature of your local reality.
The long, long, loooong wait finally ended this week for the augmented reality community as the Magic Leap One was finally released. The Florida-based company has loomed over the industry for years promising something big, and now the AR cat is finally out of the bag. Now we get to see if it will live up to expectations, but early reviews are a bit skeptical.
The arrival of Magic Leap One is tantalizingly close and, although the company has been saving the last details for launch day, a few of the more important details were found this week hiding deep in the code on Magic Leap's website.
Magic Leap has earned a reputation for overt secrecy, but as it nears the highly-anticipated launch of the Magic Leap One, the company is spilling some of the beans. This week, we get a heaping helping of information on the Lumin OS, as well as a couple of great demos.
If you're not impressed with the current crop of AR content, and you're worried this may put a damper on the industry's growth, these stories should give you cause for some optimism.
All those early prototype images Magic Leap is so fond of showing off are great, but they rank a far second when compared to a new set of images just revealed by Microsoft in relation to the HoloLens.
As the week of the Game Developer's Conference hits the mid-point, we've already had some major announcements hit the AR space. The specific timing of these announcements are thanks in part to a conference within a conference called VRDC, aimed at VR, AR, and MR developers. And while the week is hardly over, the announcement that is still having a big effect on the developer population is the reveal of the Creator Portal for the long-awaited Magic Leap One device.
Noted poet T.S. Elliot once wrote that "April is the cruelest month." But Magic Leap might argue that March is the most miserable, as the Ides of March brought more legal woes to augmented reality startup. Elsewhere, its closely-held branding secrets have been spilled by way of the US Patent and Trademark Office (USPTO).
Getting an insider view of the goings-on at Magic Leap is hard to come by, but occasionally, the company lets one of its leaders offer a peek at what's happening at the famously secretive augmented reality startup. One of those opportunities came up a few days ago when Magic Leap's chief futurist and science fiction novelist, Neal Stephenson, sat for an extended interview at the MIT Media Lab.
While everyone was marveling at the latest drama over at Magic Leap involving employees last week, a major rumor listed in one of the reports, related to the company's flagship device, was mostly overlooked.
On Tuesday, NBA Commissioner Adam Silver joined Magic Leap CEO Rony Abovitz on stage to unveil a partnership between the two companies.
Among the revelations uncovered during the December unveiling of the Magic Leap One: Creator Edition was the fact that the Lightwear augmented reality headset would be tethered to a wearable computer called the Lightpack.
Last week, Magic Leap CEO Rony Abovitz teased his Twitter followers with some "fun and cool stuff" to share in the coming days. On Monday, he made good on that promise, sort of.
When you run an augmented reality company worth billions of dollars, backed by some of the biggest names in tech, and you haven't even released a product yet, even late night tweetstorms rank as worthy of dissection. Such is the case with Rony Abovitz, CEO of Magic Leap, who decided to spend a little time on Twitter on Wednesday to outline his vision of the future of immersive computing.
At the eMerge Americas investors conference in Miami, Florida, Magic Leap founder and CEO Rony Abovitz previewed details of the launch of their highly-anticipated device.
LG is set to launch its G5 handset on February 21st at the Mobile World Congress in Barcelona. This shouldn't be too much of a surprise, but images of the G5 have now been leaked ahead of the event by Evan Blass (@evleaks). This image shows that the handset will indeed have two lenses on its rear-facing camera so that you can shoot wide-angle 135º photos.
With the brand new SMS-based ordering service called Magic, anyone with a mobile phone can order whatever they want—really, anything—by sending causal text messages. Who says magic isn't real?
The number 9. When applied to magic, it's more than just a simple number. The number has a special property that allows others to be deceived, if they don't know any better. And this magic trick will make your victims think you're using mind control on them using your psychic skills. But little do they know that all roads lead to nine.. and Denmark.
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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.
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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.
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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates.
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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.
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 674th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for counting OR criteria 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...
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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).
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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.
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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.
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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.
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 680th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a scenario button to a tToolbar or Ribbon in 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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.
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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.
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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.
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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...
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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...
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 650th installment in their series of digital spreadsheet magic tricks, you'll learn see how to take all records from a data set and place them into one column using the INDEX, INT, ROWS and MOD functions.
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 652nd installment in their series of digital spreadsheet magic tricks, you'll learn see how to create Boolean Logic formulas for AND and OR Logical Formulas. See Logical Truth Tables for AND and OR. Also see how to create array formulas in two different ways: the SUMPRODUCT function (DON'T have to use Ctrl + Shift + ...
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 655th installment in their series of digital spreadsheet magic tricks, you'll learn see how to create a statistical frequency polygon using a line chart. Also see how Excel mistakenly interprets number category label data as Number Series data.
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 657th installment in their series of digital spreadsheet magic tricks, you'll learn see howto calculate Invoice Due Dates & Financial Statement Dates using the EOMONTH function including end of the month and beginning and ending dates for each quarter.
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 658th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the COUNT & COUNTA functions correctly. COUNT counts numbers. COUNTA counts non-empty cells.