Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for finding the largest improvement in sales from one year to the next.
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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and COUNTIFS functions to count how many sales you made for a given product over the last 7 days.
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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.
In this video tutorial, viewers learn how to avoid a bad finish to cure a golf push shot. Usually, when players make a swing for the ball, their arm separates from their body. This will take the club to the right of the target and as a result, pushes the shot. To correct this, connect your left arm to your left side as you make a swing. This will allow the club to stay with your turn and go down the target line. This video will benefit those viewers who enjoy playing golf and would like to le...
This is a very useful instructional video on keeping the conversation going when a man wants to talk with a woman. It is indeed an art to talk to women. It is not easy for many men to keep the conversation going. They don't know how to avoid conversation killers. They are at a loss for words when they meet a woman. If you ever find it difficult to keep the conversation going when you talk to women, this video teaches you how to avoid the biggest conversation killer. It helps you to keep the c...
With divorce rates set to hit a record high this year, 'betterdatethannever' explains how to avoid arguing with your partner. Most people experiencing marital difficulties blame financial reasons for their fights. The easiest way to avoid conflict with your partner is to make sure you communicate and share your problems. Holding things deep inside makes them get worse and worse till they explode into one huge argument. Allow your partner to speak their mind and express things they do not like...
There's nothing worse than stalker, or someone who you just want to avoid. Fortunately, there are ways of dealing with it! This video shows you some of them.
There's nothing to fear about a trip to the mall—as long as you plan ahead and shop smart. This video demonstrates the best way to budget your money, make the most of your time at the mall, and shop smart, budget conscious. Good instructional video for your upcoming Christmas shopping & holiday sales.
Setting up a haunted house for Halloween doesn't have to be expensive. This how-to video offers some tips for adding spooky touches to your haunted house. Instead of buying everything from a Halloween store, thrift stores and tag sales are a great place to pick up decorations to modify yourself. Watch this video tutorial and learn how to get props ready for a Halloween haunted house.
Take a look at this instructional video and learn how to customize progress meters, icons, color coding, and other graphical elements to emphasize sales trends, product performance, critical deadlines, or whatever information is contained in the data behind your diagram.
Before you hang the "for sale" sign in your yard, find out how to make the exterior of your home attractive to potential buyers.
Today's word is "chicanery". This is a noun which means trickery or the act of deceiving someone.
Today's word is "pertinent". This is an adjective which means relevant or appropriate.
Every now and then you may need to use HTML tags outside of your HTML editor. Posting things for sale on eBay is a perfect example. In this video tutorial you'll see how you can use GoLive CS2 to generate all the HTML to make your descriptions pop.
Maintaining a clean living space is important, but it shouldn't have to be a hassle. The KAPSULE™ UV Sanitizing Wand 2.0 is designed to keep surfaces pathogen-free. This powerful wand emits 254nm UV-C light and makes quick work of pathogens. In a laboratory test, KAPSULE even eliminated more than 99% of E-coli!
Working from home is going to be a reality for more people than ever. With Twitter CEO Jack Dorsey announcing that his employees will be working remotely for an extended period of time (and even permanently, in some cases), the workforce is rapidly changing. More companies are certain to follow suit.
Last week, we told you about Microsoft's Alex Kipman and his nomination for the annual European Inventor Award, presented by the European Patent Office (EPO). And while that's big news in and of itself, it turns out we overlooked a very important detail buried in the EPO's video presentation. What was it? Only one of the most sought-after data points related to the HoloLens since its launch: how many have been sold.
Who likes to buy apps? The answer is no one, of course. Unfortunately, as in life, the best apps and games don't come free. That's why it makes sense to wait until those apps go on sale before handing over your hard-earned cash. And what better day to find discounts in the iOS App Store than Cyber Monday?
This week in Market Reality, we see two companies capitalizing on technologies that contribute to augmented reality platforms. In addition, industry mainstays Vuzix and DAQRI have business news of their own to report.
Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...
Nick Campbell shows us how to avoid the wobbly keyframe in After Effects. When you are animating logos and want them to come onto the screen, stop for a few seconds, and then continue off the screen. To fix it, highlight your key frames and then right click on "keyframe interpolation". Now, where it says "temporal interpolation" click to make it say "linear" next to it. Save this change and now the wobbly effect should have gone away. This can come up in a number of different moves, no matter...
Do you have an old furnace that just won't stay lit? Are you constantly relighting your pilot light? Then this tutorial is here to help you. In this three part video series, learn how to diagnose the problem with your appliance and either fix it or ditch it.
Airports are expensive places these days, aren't they? Remember the good old days when you didn't have to pay to check your luggage? Well, in these crazy economic times airlines, just like everybody else, are trying to get extra cash anywhere they can.
For an easy, but tasty, chicken dinner Chef John shows us his recipe for barbeque chicken that helps you avoid the burned skin. With the raw chicken, cut some deep slashes that will allow the BBQ sauce and marinade to permeate the chicken. Also, make a gash on the wing to make the grilling easier. In a bowl, combine crushed garlic, one quarter cup of rice vinegar, and a couple tablespoons of BBQ sauce. Dip the chicken into this marinade. Let the chicken sit in the marinade for an hour. After ...
With all the documents ready, we need to fill our wallet with money for the travel. This video discusses various ways of filling the pocket. That is how to prepare the money for international travel. Over the years credit cards have been widely used by many travelers, which is safer than carrying cash. In this case we need to contact the credit card provider well in advance and notify them about the travel. Also we need to learn about the various fees applicable to international purchases. Th...
There are many functions in Microsoft Excel. One function that people rarely use is the Repeat function or REPT. In this video, an example used is a chart of people and their sales of a certain item. Just looking at the numbers, it is hard to compare the different sales easily, but a more visual approach may work better. Next to one of the cells, type in "=REPT(" which is the repeat function. A popup should say "=REPT(text, numbertimes)". For "text", type in *** or anything, really. For "numb...
Not selling that much online these days? Maybe it's because your headlines just are reaching out to people the way they should. Good marketing means good writing in the web industry.
The rumors have been circulating for months, but now there's a source attached to the notion that Magic Leap is looking to sell itself off after a rough couple of years following the launch of its Magic Leap 1 augmented reality device.
Second-generation AirPods just went on sale with the best prices since Black Friday's deals. So if you missed your shot at snagging a set of AirPods with the Charging Case or Wireless Charging Case, you've got another chance. But you'll need to act quickly to take advantage.
After entering the UK's version of bankruptcy last month, Blippar's assets are up for sale, and bidding ended today.
Many Americans will celebrate the start of the summer this Memorial Day weekend with backyard cookouts, and two brands hope to solidify their invites to those parties through augmented reality experiences in Snapchat.
We knew it was coming, it was just a matter of when. Apple has just announced iOS 11.3, a new update for iPad, iPhone, and iPod touch, and it will include a brand-new set of Animoji for the iPhone X.
If you're trying to get somewhere fast, taking a toll road or two can definitely help you do that, but at a cost. When you're not in any rush, that would-be toll money will work much better in your gas tank, especially if it's only minutes that are being shaved from your trip. With this in mind, Apple Maps has a simple way of avoiding tolls to save you money while navigating on your iPhone.
Apple has billed ARKit as a means to turn millions of iPhones and iPads into augmented reality devices. The refrain is similar for Kaon Interactive, a developer of product catalog apps for businesses.
Update 6/16: This number is now way higher. In just the first two days of this sale, over 350,000 people have pre-registered for the phone.
Savor this moment: we've got a confirmed number of sales for the Google smartphone. We say this because unlike most hardware manufacturers, Google refuses to share official sales numbers for their phone. Instead, during earning reports they simply bundle the product under Alphabet's "Other Revenues", leaving us in the dark about how successful the product is.
In a move that confirms previous speculation, Apple has placed a large OLED display order from Samsung for its next iPhone. At 70 million display units, the order is a large one to be sure, but when stacked against previous iPhone sales, it's no wonder the rumors say there won't be enough 2017 iPhones to meet demand.
For a long time, Apple has kept the upper hand on Android as far as app revenue is concerned. However, this tradition looks likely to change this year, as Android's app sales are expected to surpass Apple's.
All across the country, retailers like Best Buy, Target, and Walmart are gearing up for their Black Friday sales. Brick and mortar stores are already packed to the brim with inventory in anticipation of the craziness that will strike as soon as the doors open the day after Thanksgiving.
With over 2 million uploaded videos and over 28 million people who had talked about it online by the end of August, the ALS Ice Bucket Challenge was the most viral social media event of 2014. Its popularity provided the ALS Association with $115 million in donations to date, with everyone from students to veterans to celebrities contributing.