1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a cell in Region and goto Data select A to Z. 4. Second method to sort: Select a cell in Region and Right click and select Sort A to Z 5. Then click a cell in Region and select Data->OutLine->SubTotal 6. In the SubTotal Window select 1.Each Change in: Region 2.Use function:Sum 3.Add subTotal to:Sales...
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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.
Create a table with sales data with this video.
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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).
This video is about staging a home for sale. Bridget Kiene, a real estate broker, describes home staging and its significance. Bridget starts with defining home staging and mentions that 92 percent of people advertise their house for sale on the internet. This video also has some tips on home staging, such as, always stage an empty house, create a neutral color palette, eliminate clutter and modernize your decorations. Bridget clearly explains the basic steps we need to follow to sell a house...
In this video, Derrick Schommer, sales engineer, podcaster and host of Common Man Cocktails shows viewers how to mix up a Blue Mediterranean. This classy gin cocktail is based on Bombay Sapphire gin, teamed with lemon-and-lime Sprite and Blue Curacao for a sophisticated, slightly sweet drink. The Blue Curacao and gin are placed in a high-ball glass with ice, then the drink is topped off with Sprite and a squeeze of fresh lemon juice.
With PivotTable reports in Microsoft Office Excel 2007, your sales report will sparkle with power, flair, and functionality. Take a look at this instructional video to learn how to show the big picture, show all the details, or show anything in between. Easily create multiple worksheets to switch back and forth between the various versions of your report. Sort, filter, and summarize your data any way you like. Show the details of any summary value in your report.
Take a look at this instructional video and learn how to analyze how a process or other area is actually performing by connecting data to the shapes in your diagram with Microsoft Visio 2007. You can also add different visual effects based on the data values. For example, you can link sales data from an Excel workbook to the shapes it relates to. When a phase of the sales process takes longer than guidelines recommend, the shape for that phase changes color or shows an icon that alerts you to...
Create a Star Trek-themed Facebook application! This tutorial shows you how to make a simple Flash application with a Klingon theme. You're walked through all the steps using Flash Builder in Adobe Flash CS5 to create the Hello World application for Klingon Facebook users.
What You See Is What You Get, or WYSIWYG, is a useful type of web builder which allows new users or beginning coders create their own websites by using a type of plug and play interface. This tutorial shows you how to build an entire website using a WYSIWYG Flash-based editor.
The standing barbell press is one of the most often seen in movies and in TV shows. The classic chunkhead screaming out reps as he struggles, red-faced, to push that 100-pound dumbbell a few more inches into the air and into the finishing line.
Nutrition and cardiovascular exercises are necessary to reduce the size of your belly. Ab exercise won't reduce girth. They will strengthen your core, but you will need to lose excess body weight.
In this tutorial, we learn how to do ultra wide pushups for a big chest. A basic pushup can be way too easy if you are an experienced body builder, but you can do different variations to strengthen your body further. First, get down on the ground and place your arms much wider outside of your body than they normally would be. This will make you push harder up while your hands are pushing outward. This will make you work hard and squeeze at the same time, and your range of motion will be limit...
You're probably under the (false) impression that building wads of Hulkish muscle also requires wads of cash, because most muscle builders have complete gyms filled to the brim with weights and tabatas.
In this video, viewers learn how to create augmented reality applications, using Papervision 3D version 2.0. Augmented reality is a term for a live direct or indirect view of a physical real-world environment whose elements are merged with virtual computer-generated imagery - creating a mixed reality. To create augmented reality applications, users require the following programs and software: Adobe Flex Builder 3, TortoiseSVN and FLARToolkit. This video tutorial is not recommended for beginne...
Before you grout a floor, take the time to be sure that you really know what you're doing. Mistakes you make now can come back to haunt you later. A lot of people try to use wall grout, for instance, which doesn't work well and eventually cracks. What you really want top use is sanded grout. In this 4-part tutorial series, Tim Carter, of Ask the Builder, demonstrates how to mix up and use sanded grout when you're putting down a tile floor.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast.
Mike Lively of Northern Kentucky University shows you how to build an interactive Molecule Viewer in Papervision3D and Flex 3. This is a fun application building project for anyone learning Adobe Flex Builder 3 and a great resource for molecule viewer for students, educators, and researchers in chemistry and biochemistry.
Toologics editor Jude Herr hosts this kitchen remodel series! Jude and her Father, from American Builders, outline the project.
A handful of retailers have put the newest Nexus smartphones on sale again, so you're in luck if you missed out on picking one up during the discount period last month. Actually, you might be better off since some retailers are giving away freebies with some models, too.
Make a Spark frame ripper
This programmer's guide provides an introduction to Xcode, Interface Builder and the iPhone simulator. Specifically, you'll learn how to write, build and test a simple "Hello World" application. For more information, including a complete overview of the process, take a look.
How do you know if you are making progress when you put yourself on a strict diet and exercise regimen? Many people wonder whether the numbers going down on the scale means they're losing fat, and if the numbers are going up, whether they're gaining muscle. This is a question that many body builders and those trying to lose weight (while gaining muscle) try to understand on the way to their goal weight.
In this video, Paul Louis, a professional puppeteer and puppet builder discusses the difference between puppets intended for theater and television and how they are different both in appearance and operation. For a puppet on stage, stitching is acceptable to be seen on the outside of the puppet and large, exaggerated movements for the puppet are acceptable and encouraged for easier viewing by your audience. For a puppet which is shown on a television shown, the puppet should be cleaner and th...
In this Fitness video tutorial you will learn how to do hip pushups. This one is for advanced body builders and not for beginners. You can use push up stands or use towel to cushion your fists while doing hip push ups. This is not to be done with palms open. Keep your elbows on your sides and you will be pushing from your hips. Stretch your body with the weight on the fists and toes. Keep your torso straight, abs flexed tight, then go down slow and come up slow. The body should be straight. D...
This tutorial demonstrates how to create what is called a complete client-server web application which consist of a Web Application, PHP, and MySQL. The tutorial shows how to automatically generate the PHP necessary to talk to a MySQL database using Adobe Flex Builder 3.
Mike Lively of Northern Kentucky University demonstrates how to create a 3D plotting program for the sinc math function. Part 1 shows how to convert a Flash Package into a Flex application. Part 2 shows how to get the sinc function running and add different textures. Create a cool interactive 3D plotter in thie Adobe Flex Builder 3 and Papervision3D tutorial.
Work out the pelvis with pelvic tilts. Learn about exercises for strength and flexibility in this training video. Take action: keep your back flat, this is a high repetition exercise, and keep feet flat on floor. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys training aspiring female ...
Increase muscle strength with barbell exercises done while lying down. Learn about muscle training, fitness, and growth in this fitness video. Take action: do not rock arms and keep core tight. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys training aspiring female body builders as sh...
Exercise the quadriceps muscle with quad extensions. Learn about increasing leg strength in this training video. Take action: keep core tight, squeeze legs at top of movement, but only legs will move. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys training aspiring female body builder...
Working out the arms with standing dumbbell curls. Learn to increase muscle strength in the arms with dumbbells and curl exercises. Take action: start with feet shoulder-width apart, palms face forward, keep elbows at sides, and do not rock. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enj...
Gain muscle strength and flexibility with diagonal lunges. Learn about dumbbell exercises to promote fitness in this weightlifting video. Take action: maintain balance, keep back leg straight, and increase difficulty by adding dumbbells. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys ...
Sumo squats will help to strengthen the legs. Learn how to properly do squats in this workout video. Take Action: hold in squat position to increase difficulty, feet wider then normal squat, and keep chest and head high. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys training aspiring...
Increase flexibility and prevent injury by stretching the triceps. Learn how to do stretches and arm exercises in this video. Take action: hold stretch for 20-30 seconds, stretch when muscles are warm, and hold stretch at point of mild discomfort. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and s...
Increase muscle strength and flexibility with dumbbell rear lunges. Learn about dumbbell weight training and exercises in this video. Take action: keep chest high, shoulders back, core tight, raise knee to increase difficulty, make sure back step is big, and add hop to increase difficulty. Michelle is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting ...
Increase muscle strength with dead lift exercises. Learn tips and techniques for proper weightlifting in this fitness video. Take action: keep bar close to legs, don't round the back and use proper form. Michelle is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys training aspiring female body builders as she is one herself. She focuse...
Working out with bent knee hip extensions requires attention to form. These knee extensions are also called Romanian Dead Lifts. Learn about hip extension exercises in this dumbbell fitness video.
Let's face it, iPhones are expensive. With the latest iPhone XS Max reaching as high as $1,449, our wallets could all use a little support. That's where Black Friday comes in, supplying us with deals and discounts on iPhones of all kinds. If you're looking for a new iPhone this holiday season without having to break the bank, you've come to the right place.
Aura, a highly rated app for mindfulness and mental health, just became available on Android and is currently on sale.
Ron the Builder demonstrates how to plaster a wall. Mix the sealant with water to achieve the right proportions and spread evenly over the wall with a paint roller. Once the sealant is dry, you may begin plastering. Combine half a bag of plaster with the appropriate amount of water in a large bucket with an industrial mixer. Mix until the plaster is smooth. Pour the plaster onto a flat board. Using a trowel, scrape some plaster onto your hawk. Then, using a flick of the wrist, quickly scoop s...
