This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizontal lines. Now go back to the data set, click on a cell and click ctrl+shift+L and that will add the auto filter. ctrl+shift+L is for Excel 07. For earlier versions, see the commands listed in the video. This is a toggle...
Learn how to make a Swarovski crystal pendants that can be used to make your own necklaces by following the tips in this tutorial. You will need a pair of needlenose pliers, a chain, Swarovski beads, and bails (a pinch bail). You can get the beads from ArtBeads or FusionBeads, which offer shipping promotions and low prices. Once you have these items it is simple to put the pendant together. Simply take the bail and open it with the pliers. Slip the bail through the hole of whatever bead you b...
Want to fulfill your dream of becoming an ice cream truck driver? If the idea of rolling around in the sunshine selling ice cream sounds good to you, here's what you need to do.
A little planning is all it takes to decorate your dorm with style! You Will Need
Watching wrestling was always fun as a kid, but playing wrestling video games is always fun, no matter what the age. One game in particular is WWE SmackDown vs. Raw 2009 for the PlayStation 2. Check out this tutorial on how to get Hornswoggle out of the ring in WWE SvR 2009.
Got 3D glasses leftover from the Superbowl? Time to break them out! You will need cheap 3D glasses from television promotions or you can grab them off eBay for this demonstration. Or you can simply make your own 3D glasses red and blue or yellow and blue cellophane.
Baby, it's cold outside, but, with some help from Snapchat augmented reality, Gucci is thawing our wintery hearths with a virtual trip to the tropics.
After leaning on augmented reality for its outdoor advertising, HBO has called on augmented reality again via Snapchat to promote its Watchmen series.
The promotions around last week's release of Stranger Things 3 have been numerous, with Netflix at one point even taking over an entire baseball field via augmented reality.
Hollywood loves to use New York City's Times Square as a setting for major scenes in a blockbuster movie, so it's only right to use the area for a choice bit of virtual apocalypse in augmented reality.
Hollywood loves sequels so much that studios and their marketing teams are not too proud to release a sequel of an augmented reality promotion.
Although all signs points to Microsoft releasing a new HoloLens in the coming days, the company is nevertheless looking to distribute its augmented reality apps to other operating systems.
A spokesperson from the Nissan and Renault Alliance told Driverless the group is testing self-driving electric "robo-vehicles" for future mobility services and is "not ruling out anything" for future services the group might offer, as the alliance widens its driverless business model to include both fleets and private sales.
Driverless partnerships continue to appear as Continental AG, leading German automotive manufacturing company, has signed a strategic cooperation agreement with global electric startup, NIO. The goal of this partnership is to research, share, and develop autonomous technology, among other developments.
Universal Studios and Cinemark Theaters have enlisted mobile augmented reality game Seek to promote The Mummy, a reboot of the action-adventure film franchise starring summer movie mainstay Tom Cruise.
The Google Play Store is known for some pretty random promotions and offers, most of the time it's a free book or a discounted movie. But this time, an entire season for Game of Thrones is up for grabs. Yes, that's right, all of Season 5 of Game of Thrones is free to download, watch, or just stash in your library for later.
If you tend to go over your data allotment each month, or are constantly afraid you will, Verizon Wireless is giving you chance to relax a little bit with up to 2 GB free data for two months.
HTC is one of the few OEMs that make it easy to unlock the bootloader on their devices. And while they do warn you that doing so voids your warranty, they don't tell you that it also prevents you from collecting promotions that come with their devices.
'Tis the season... for cheap (and free!) video games. THQ's Humble Bundle lets you get 7 games for any price you want, and now they're making it even better by offering fans a free Steam copy of Metro 2033 just for liking Metro on Facebook, which is gearing up for the latest Metro: Last Night release.
Apple is notoriously cryptic when it comes to the reveals of its new products, and as usual, they've kept us guessing about the release of the iPhone 5 (or "New iPhone?"). It's expected to be officially revealed on September 12, and rumor has it that sales will begin on the 21st. Though the whole world seems to be anxiously awaiting the announcement, there has also been some controversy surrounding the iPhone 5's production. With the high number of suicides and poor working conditions at Foxc...
This six minute video shows you how to sell your car on craigslist. First, go to craigslist.com and click on the nearest city (or country). Follow the links to list an ad for a car for sale. You will want to put the kind of car in the posting title because that is used in sorting search results. In the posting description it is important to be as specific as possible - again describing the car, giving some history of the car like if it has ever been in an accident and if you have had any work...
Chances are that if you've attended any amount of Victoria's Secret's semi-annual sales, you've probably got enough bras to start your own lingerie store. But because you don't have an entire showroom to store those babies, your bras are probably just lying around wherever they fit.
In this clip, Sandra Lee shows you how to do what she does best and make a delicious recipe for very little money. Sandra shows you how to combine homemade ingredients with store bought items so that it tastes like it was made from scratch. Enjoy these sinfully decadent breakfast pastries for your guests, a bake sale or as a treat for yourself! Enjoy!
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).
Watch this science video tutorial from Nurd Rage on how to find chemicals for science experiments with Dr. Lithium.
You bought a whole bunch of strawberries on sale, but you don't want them to go bad. CHOW contributor Daniel Duane shares his trick for keeping farmers’ market strawberries fresh and making them last longer. Just follow this cooking how to video for great tips on keep fresh fruit longer.
Some people get confused about a couple of aspects to solving the Rubik's Cube. Hopefully this video will clear things up. If not, then just don't watch anymore videos. Just put the cube in your closet, or in your yard sale, or smash it against the wall. Just give up.
In this episode shows you how to use the modal words such as should, might, and would; as well as learn words used in market reports and sales figures in the English language. This video is great for advanced, intermediate, and beginner learning to speak the English as a second language (ESL).
Bernard Smalls explains how to make big bucks in sales. If you hate what you are doing, you will not make big bucks. You have to remember that the point of sales to make money.
I go back and forth between two home screen apps: Nova Launcher and Action Launcher. While I prefer the aesthetics of Nova, I like Action's Quickpage feature since it puts some of my favorite apps just a swipe away. But now, I've found a way to replicate this feature on Nova (or any other launcher), and it works even better.
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 Fourth of July, stock up on hot dogs, ice cream, and smartphones. Yep, this Independence Day is a surprisingly good time to get your hands on the iPhone SE. If you're interested, head to your nearest Best Buy to check out this major deal. (Or wait for the iPhone 8 to come out ...whenever that will be.)
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.
Still using those boring plastic coasters that you got at a sale at Ralph's? Add some personal style to the mix the next time you serve your friends some soda by making your own coasters!
360 degree panoramic viewers are a staple of all kinds of websites from real estate to auto sales. This video will teach you how to create a a 360 degree view that will display on your website using Flash CS3 and Actionscript 3. Don't restrict your users to just one photo, let them see all of whatever you're showing them with the tools your learn in this video.
Project 5 from Popular Science's 5 minute Projects with Craftsmen Tool is 'Integrated Circuit Cufflinks'.
A side effect of the COVID-19 pandemic is that small businesses are suffering from forced closures and social distancing, but game developer Niantic has a solution.
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.
