Simple Tips Search Results

How To: Recover your voice

Singing too much? Had a bad fight? Your voice is trashed right? How do you get it back into tip top shape? This video will give you all of the hot tips and tricks on getting your body to heal more quickly and get you back into fighting shape!

How To: Make simple syrup with sugar and water

In this video tutorial, viewers learn how to make simple syrup. This task is very easy, fast and simple to do. Users will only need 1 cup of water and 1 cup of sugar. Simply pour the equal parts of sugar and water into a pot. Then boil the mixture until it bubbles for 3-4 minutes. This syrup is used to season different recipes. All the sugar should be dissolved in the mixture. This video will benefit those viewers who enjoy cooking and baking, and would like to learn how to make simple syrup ...

How To: Use VLOOKUP to add a column of categories 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 646th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to add a column of categories using the VLOOKUP, RIGHT, LEN and SEARCH functions.

How To: Improve the performance of an underperforming employee

One of the trickiest parts of being a boss is handling an employee who isn't performing up to their potential. This video features tips from a business consultant on how to handle these situations, focusing on having a conversation with the employee about their performance, handling the situation calmly and effectively. Hopefully, if you follow these tips, then you won't have to take the unwelcome step of firing the employee.

How To: Count with more than 1 criteria 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 and Mr. Excel, the 27th installment in their joint series of digital spreadsheet magic tricks, you'll see ten different methods counting with more than 1 criteria.

How To: Decrease values 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 and Mr. Excel, the 2nd installment in their joint series of digital spreadsheet magic tricks, you'll see two methods for subtracting 35% from a column of values.

How To: Extract items not having a given text value 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 and Mr. Excel, the 25th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract records from databases that do NOT contain a given text value.

How To: Control percentages with a scroll bar 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 and Mr. Excel, the 46th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create scroll bars that will control a percentage in a cell.

How To: Create a frequency distribution 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 and Mr. Excel, the 15th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use a pivot table with grouping and a count function to create a frequency distribution.

How To: Find a mean for data set while excluding 0s 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 and Mr. Excel, the 13th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set.

How To: Add the difference between 2 number columns 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 339th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function to add the difference between two columns of numbers based on two criteria.

How To: Count dates with an array formula 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 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT functions.

How To: Retrieve data from a different workbook 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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic, two-way IF function lookup formula for pulling data from a different Workbook.

How To: Fix poorly set up data 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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.

How To: Count with two criteria 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 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.

How To: Count whole and half workdays 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 535th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKDAYS, NETWORKDAYS.INTL, WEEKDAY, ROW, INDIRECT and SUMPRODUCT functions to count weekdays including half (1/2) workdays.

How To: Calculate commissions with Excel's IF & VLOOKUP

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 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF and VLOOKUP functions to make one of two types of commission calculations based on what is put in the referral column.

How To: Conditionally format a bar chart 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 566th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF functions and a bar chart to create a conditionally formatted chart for students scores that exceed a given hurdle.