Knowing Tips Search Results

How To: Autohighlight the highest value in a row in Excel

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 268th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply a conditional format that will highlight the maximum value in a row using a true/false formula.

How To: Find & count the longest or shortest word in MS Excel

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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to find and count the longest and shortest words/strings with the MAX, MIN and LEN functions in an array formula.

How To: Create a weighted gradebook in Microsoft Excel

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 197th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a specified total score with weights assigned to different categories.

How To: Count data without an upper limit in Microsoft Excel

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 198th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for counting quantitative data in categories that include a lower limit but not an upper limit.

How To: Analyze a CM statement with a data table in MS Excel

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 254th installment in their series of digital spreadsheet magic tricks, you'll learn how to do contribution margin income statement analysis across various units using a one-variable data table.

How To: Create a sudoku puzzle in Excel with array formulas

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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.

How To: Create a checkbook-balancing formula in Excel

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.

How To: Do a two-variable lookup given duplicates in MS Excel

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 225th installment in their series of digital spreadsheet magic tricks, you'll learn how to do a two-variable lookup when there are duplicates using the INDEX, IF, ROW and MAX functions.

How To: Randomly select an employee name from an Excel sheet

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 169th installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly select an employee from a list using the INDEX and RAND and INT functions (also RANDBETWEEN).

How To: Use VLOOKUP with TRIM in Microsoft Excel

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 155th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the TRIM function to get rid of extra spaces when a VLOOKUP function should work but doesn't.

How To: Create a personal budget based on past data in Excel

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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.

How To: Use a MODE IF function in Microsoft Excel

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 145.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to a formula that will calculate the mode when you have more than 1 criterion.

How To: Use sheet cell references in Microsoft Excel formulas

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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.

How To: Name a Microsoft Excel cell after its content

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 138th installment in their series of digital spreadsheet magic tricks, you'll learn how to name individual cells after their cell content (i.e., the name of the cell is in the cell).

How To: Apply conditional formatting to a calendar in Excel

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 98th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period.

How To: Create a form from linked Access data in MS Excel

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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to import data from Microsoft Access as well as how to use the VLOOKUP function to populate data into a printable form.

How To: Find the average time between orders in an Excel sheet

New to 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 Excel tutorial from ExcelIsFun, the 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.

How To: Improve your golf swing for consistency

This video tutorial is going to show you how to improve your golf swing for consistency. Here you will get three swing tips for driving the ball to make you more consistent. The 1st tip is on the takeaway. The takeaway should be one smooth piece. You should not take the club up too early. The 2nd tip is to keep the head steady. Quite often golfers take their head too far away from the ball. Don’t move the head away from the ball as you swing your club back. The 3rd tip is to hold the swing on...

How To: Clean up under your eyes with Brooke Burke

Brooke Burke shares a personal mini tip. According to her under eye cleansing is important because usage of different shadows cause some spillage. She used a cotton bud to apply cleansing cream in her under eyes area. She applied little cream on her hand and then with the help of cotton bud, she applied it on her under eye. She shared with her viewers that during a busy working day, she always keep eye buds and eye cream in her purse and clean her under eyes. This ensures to keep wrinkles hid...

How To: Make laundry day more environmentally friendly

In this video, Eric Rochow from Real World Green gives us a simple green tip to make doing your laundry more environmentally friendly. The tip is: Don't wash your clothes! Well, actually, don't wash them until they are actually dirty. If you're wearing clothes and they're still clean, you don't need to automatically throw them in the laundry bin. It's something to think about. Also, if you wash your clothes too often, it wears out your clothes. So, next time you're wearing some clothes just t...

How To: Backside nosepick on a skateboard

First, the landing will be explained and demonstrated. A good tip learned from this video is that practicing landing a trick (in this case starting propped up in the position you would be doing a backside nose pick in) is important, as you can perfect the most difficult and intimidating part of the trick before learning it in its entirety. You will learn tips and tricks on ways to practice this trick, as well as insights of the presenter's own experiences in learning it. At the end of the vid...

How To: Make a toilet paper wedding dress

The video gives tips to participate in a toilet paper wedding dress making contest. It gives the participant tips on how to make a winner's dress. Contestants are asked to begin with some inspiration by looking at previous winner's dresses, going through real dresses or by using their own imagination. Their next step is to gather the required materials. Participants must take good photos of their dresses in multiple angles and they can even shoot a video of their dress making. Some points on ...

How To: Tell if a girl likes you

This video gives tips and signs on what to look out for to tell if a girl/woman likes you. Here are some tips and signs to look for to check if a woman is interested/attracted to you: - asking you a lot of questions - ignores her friends and keeps talking to you - playfully touches you / initiates contact - while telling a story and then you suddenly stop, she will be eager for you to continue it - if she unconsciously mirrors your actions - lead her to someplace then take her hand, squeeze i...

How To: Pressure or power wash home siding with Lowe's

Back again with another in their great informational series for do it yourselves at home, Lowe's presents this video hosted by Mike Kraft demonstrating how to pressure wash your home's exterior siding. Mike describes in detail the tools, supplies, and steps you will need to take to remove dirt, mildew and mold from your home's exterior. Experienced do it yourselves and beginners alike will appreciate the detail and tips provided in this video, as well as some useful safety tips on using your ...

How To: Repair a bike tire

The video starts out by showing how a bike rack is helpful in repairing your flat tire. Next it takes you through all of the steps, along with tips and instructions on what you need to do. don't forget to heed the "notes‚" throughout as they are important tips to enable you successfully repair your flat tire. In no time at all you will have fixed your bike's flat tire and once again be ready to hit the road.

How To: Dress for a job interview

Monster.co.uk, a job site, and Color Me Beautiful bring you these tips to dress for a job interview. An important part of landing a job is how you present your self in an interview, so after you practice some interview questions and get your resume ready, you need to start thinking about what to wear.