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 251st 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 reps using a series of standard formulas in tandem with a few array formulas.
In this Microsoft Excel 2007 for Dummies video the instructor shows how to record a Macro. Macros let you create a shortcut to perform a sequence of commands all at once. For example you can create a macro to quickly build a sales report template that you frequently use. When ever you run that macro the Word will automatically build the template for you based on the recorded commands. To write macros you need to have the developer tab enabled. To enable it click on the office button and at th...
Don't throw away that old keyboard! You can make a sweet wallet with the circuit sheets inside! Inspired by this Instructables project. Hack together your own cool wallet with this mod video.
Are your shoes a little too tight? Don't toss them away, there's hope for them yet, and it involves one of the most basic elements on Earth— water. By packing your high-heeled shoes with plastic ziplock bags filled with water, then storing your shoes in the freezer, you'll have newly revived footwear that will accommodate your large feet— just kidding. Sometimes you just can't pass up a good shoe sale, and if they don't have your size, this is your fix.
We never thought this would happen. A cherry pie AND cupcake in one? We have officially died and gone to foodie heaven. Make sure you take a closer inspection of these cherry pie/cupcake hybrids, however: These are actually cupcakes decorated to resemble cherry pies using frosting.
In this tutorial, we learn how to fit a backpack for long distance hiking. For scouts, look for a backpack with an adjustable torso so the pack can grow with you. After this, have the sales staff help you adjust your pack correctly, and measure how long the pack is on your back. You want the pack to fit you perfectly so you don't have back problems later. Try the pack on both on the hip section and shoulder to see how it feels on you. Tighten any adjustments to make it more secure, then you w...
The best wines will set you back almost as much as a pair of Blahniks on sale, so why not cut expenses and just make your own wine? Watch this beer brewing tutorial to see how to brew hard apple cider which has a wine-like taste.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.
In this video tutorial, viewers learn how to create a web 2.0 style badge using Adobe Illustrator. Adobe Illustrator is a vector graphics editor. Viewers will learn how to manipulate the Star Tool in Adobe Illustrator, how to apply a custom radial gradient to that shape and how you can create, save, and open custom swatches. This video will benefit those viewers who design websites. These web badges can be used on a website to promote a product, announce a sale, or simply draw attention.
This video shows you how to make a sweet no bake coconut dessert bar. This dessert has a very high sugar count so you wouldn't want to do this very often, but it's a nice thing for kid's birthday parties or a bake sale. David "The one pot chef" shows the viewer how to prepare a simple and easy treat. The recipe includes sweetened condensed milk and coconut and as he puts in all the ingredients it becomes a very thick paste which he presses into a pan then pops the pan into the fridge to let i...
See how to make some cool gift / party favor bags for any occasion. They are made with envelopes. You can make them from nearly any size and type. The ones in the video are made with some surplus greeting card envelopes. Sometimes you can purchase "leftovers" from an office supply or drug store (any store that sells greeting cards). "Left-overs" mean that the cards get damaged or lost but the envelope is left. Just ask the manager if you can purchase them.
Augmented reality sells, but who's buying? Over the past week, two companies made executive hires to capitalize on the growth of augmented reality as a service to sell to other businesses. Meanwhile, two companies joined forces to offer augmented reality tools to headset makers and content providers.
Updated 5/2/17: CultofMac reports analysts at Deutsche Bank are confirming the delays. The analysts believe the delays are due to "component shortages and technical challenges." This would corroborate the rumors listed below. We here at Gadget Hacks will bring you more on this story as it develops.
Nokia, the Finnish telecommunications company, is about to shake things up a bit after its networks sales in the final quarter of last year declined 14% compared to sales in 2015.
David Epstein provides tips and shows garlic lovers how to plant garlic in their very own garden. It is best to grow garlic in the fall season from the months of September to November when the temperatures are cooler. Some people grow garlic in the spring, but it’s been found that growing garlic in the fall time will give a better crop. To begin, gather some plantable garlic bulbs making sure that you find ones that are either organic or from a seed catalog. At all cost, avoid conventional ...
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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
Ilyce Glink discusses the way to make your house more marketable by improving the look of your bathroom through furnishings and potentially coordinating this with your bedroom. She also proclaims that this can be done with small purchases! She discusses how the bathroom can be an easy sale to a potential buyer but purchases like small decorative soaps or matching towels can go a long way. Matching items like your floor rug and shower curtain can catch an eye. As for your bedroom, adding lamps...
In this video tutorial, viewers learn how to save money on beauty products. In-store cards and frequent buyer programs can save a lot of money. When you scan the CVS Extra Care card at checkout or in-store kiosk, coupons based on your purchase will be printed automatically. It will give good discounts. Web only offers are becoming popular. Private sale sites have also become popular. You simply sign up on the site and take offers that the site has. This video will benefit those viewers who ar...
Want to get more from the raw data you're entering into your Excel worksheets? Now you can create two distinct pivot tables in Excel comparing, for example, monthly and quarterly sales data. Not familiar with the pivot table? Pivot tables summarize spreadsheet input by counting, sorting and totaling data within a list and providing at-a-glance computations within the same sheet. Become an expert on the subject within 5 minutes and 24 seconds by following easy to understand instructions narrat...
This video shows you a delicious recipe and how to make quick and easy brownies, with an Australian twist. This is an old fashioned favorite, perfect for a school bake sale, or just something sweet to impress the family. Also a great way to bound with the family by getting them involved.
Imagine this: You're stuck in Poland and the airline lost your baggage. All you want to do is get into comfortable clothes and go to sleep at the hotel. How are you going to ask a sales girl for what you're looking for? Learn how to say "pajamas" with help from this video to help you in your struggle.
This is a very informative video on creating multiple layers and short cuts on how to edit the already made layers to match your preferences.
This video is about the use of PhotoKey. It is surely an excellent sales pitch. The video clearly depicts the benefits and advantages of PhotoKey. The easy and short ways to edit background, delete objects and also adjust light to make the photo look more real. PhotoKey is very user friendly and does magic to the project for which it is used. The video by itself makes the viewer feel that this is the best and easiest tool available to edit pictures to their own needs. It also gives informatio...
C For Chemistry delves into the chemistry of science experiments. This chemist knows what he's talking about. These chemistry experiments are not only fun, but very educational for all of those interested in scientific chemical reactions and properties.
Michelle Phan presents this tutorial on how to take a tomato and turn it into an invigorating scrub.
Watch this science video tutorial from Nurd Rage on how to get lithium metal from an Energizer battery. They show you how to get Lithium Metal from an Energizer Ultimate Lithium battery.
Find out how everything in a chemistry lab works, from pipettes to burners to recrystallization to storage. You'll get precise instructions on how to work and perform certain scientific duties in the chem lab, whether it's chemical or just ordinary high school science.
Are you in real estate? Take a look at this instructional video and learn how to run your excel spreadsheet over a regression analysis module. An appraiser who's appraising a house decides to run a multiple regression analysis as an addition to the direct sales comparison approach. The spreadsheet used in this tutorial was written in excel, but could be rewritten in another format. The spreadsheet was exported from an MLS. Once the excel sheet is downloaded, the appraiser will open up the reg...
Keeping the books in order is one of the great challenges every business owner faces. Having a great product or service is one thing, but managing the minutia of invoicing can trip up a lot of small- and medium-sized businesses.
Every state has begun reopening in some capacity. While there are important steps for everyone to get back to work and begin socializing, precautions will be in place for some time, especially with an expected second wave coming this fall. The virus is not over.
It's no secret that the vast majority of Null Byte readers range from beginner to seasoned coding pros and developers. Regardless of whether you're interested primarily in building websites or creating best-selling apps and games, working with a wide variety of programming languages remains one of the best ways to make serious money in an increasingly app-driven world.
Tax season is always stressful, especially for entrepreneurs and small business owners. Rather than wait until March to get your finances in order every year, learning how to keep track of your expenses is a valuable skill that saves you and your business time, money, and plenty of anxiety.
After North cut the base price of its Focals smartglasses, Vuzix is now testing the waters of a lower price point for its Blade smartglasses.
While the story of augmented reality headset maker Osterhout Design Group has come to an end, the epilogue of its demise continues.
The Magic Leap One: Creator Edition has been teased for months now, and while we still don't know exactly when the sales will begin, it can't be long now because we've discovered a couple of new hints that the device's launch is imminent, hiding in plain sight on the company's website.
The Essential Phone was undoubtedly one of the most underrated phones of 2018. It launched with buggy software and camera problems, but the company worked diligently to push out updates. Many Android enthusiasts were anxiously waiting for the Essential 2 release later this summer. Unfortunately, news today from Bloomberg indicates that Essential will not release a phone in 2018.
Huawei recently announced the Honor 7X, a mid-tier smartphone aimed at budget-conscious consumers. Spearheaded by the Kirin 659 SoC, it offers great performance at a price point where speed is normally an afterthought. Today, Huawei is making this $199 phone even more attractive by announcing a new limited edition color.
Apple is no stranger to lawsuits. They were in a decade-long battle with Samsung that finally came to an end last month, and they've been duking it out in the courtroom with Qualcomm since last year. The more recent case has seen both companies file suits and counter-suits, but now, Qualcomm is claiming that Apple's new iPhone X infringes on patents from a long-deceased mobile operating system.
Augmented reality headset and software maker Meta Company announced today board member Joe Mikhail will serve as the company's chief revenue officer.
While iPhone sales are expected to dip for the first year ever, Apple is reportedly planning to release a souped-up, 4-inch iPhone 5 in hopes of boosting sales for users who prefer a smaller handset.
