Hot Microsoft Office How-Tos
How To: Rank numbers ten different ways 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 337th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank numbers in Excel using 10 different methods:
How To: Create a quantitative freq. distribution in MS Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 24th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data frequency distributions with pivot tables. See how to create the correct unambiguous labels ...
How To: Create percent & relative freq. distributions in Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 25th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data percent & relative frequency distributions with pivot tables. Also see how to create a histo...
How To: Make distributions, ogive charts & histograms in Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 22nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a percent (%) cumulative frequency distribution with formulas, a histogram and an ogive chart. See how to add ...
How To: Create frequency distributions with Excel pivot tables
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 15th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use create a frequency distribution, relative frequency distribution, percent frequency distribution and pie chart wi...
How To: Create a distribution for categorical data in MS Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...
How To: Make calculations in Excel with formulas & references
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
How To: Work with nominal, ordinal & interval scale in Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 10th installment in his "Excel Statistics" series of free video lessons, you'll learn how about data sets and the nominal, ordinal, interval and ration scales/levels of measurement and see two Pivot Tables that...
How To: Use Microsoft Excel 2007 for statistics
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.
How To: Use VLOOKUP queries inside of an MS Excel IF function
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 588th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine whether an employee is exempt from a tax using a VLOOKUP in an IF function, and if not use a second VLOOKUP lookup query to look in tax tables to look up and calculate the tax
How To: Make an Excel formula for a decimal stem & leaf chart
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 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula for a stem and leaf chart for decimal numbers using the IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW and TEXT functions.
How To: Count rows that meet three 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 586th installment in their series of digital spreadsheet magic tricks, you'll learn how to enumerate rows that meet 3 using the SEARCH function.
How To: Return many items for a single lookup 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, the 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
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: Work around the 1-rule data validation limit in Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 144th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to work around data validation's one-rule limit by creating a second shrinking list that looses values as they are used in the data validation area.
How To: Remove table rows containing blanks in Microsoft Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 88th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to remove rows of a table where the row has a blank in column A using a macro.
How To: Generate a series of dates in Excel with TODAY & ROW
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 141st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to generate a series of dates with the TODAY and ROW function that will always show today plus the next 10 days.
How To: Use Microsoft Excel's Goal Seek tool to modify inputs
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.
How To: Use the number e in a Microsoft Excel spreadsheet
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 99th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create and use the mathematical constant e in Excel. Also learn about the EXP function.
How To: Isolate unique records with Excel's OR function
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 85th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to isolate unique records with the OR function.
How To: Base one data validation list on another in MS Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 75th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use name, the INDIRECT function and data validation drop-down lists to create DV lists based on DV lists.
How To: Fix bad data in Excel with the CLEAN & TRIM functions
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 74th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to fix bad data with the CLEAN & TRIM functions.
How To: Increment column numbers for an Excel lookup table
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 335th installment in their series of digital spreadsheet magic tricks, you'll learn how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).
How To: Count between two numbers with Excel's DSUM & DCOUNT
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 use the DSUM and DCOUNT functions to sum or count between an upper and lower limit.
How To: Use the ADDRESS function in Microsoft Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 98th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the ADDRESS function to make labels in templates easier for users to understand.
How To: Apply conditional formatting to a chart in MS Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 81st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to a chart by creating a new column of data with a formula.
How To: Turn off auto column & row formatting in MS Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 72nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to turn off auto formatting so that column and row formatting or formulas are not automatically created.
How To: Use conditional & custom number formatting in MS Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 101st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use conditional formatting AND custom number formatting to add styling to a cell.
How To: Do advanced time & math calculation in Microsoft Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 107th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use DATE and TIME in the same cell to solve a common time math problem.
How To: Use MS Excel's Go-To tool to remove rows with blanks
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 87th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to quickly remove rows of a table where the row has a blank in column A.
How To: Create an average with multiple criteria in MS Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Use the UPPER & EXACT functions in Microsoft Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.
How To: Create custom formulas for data validation in Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 84th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use custom true/false formulas for data validation and also see how to add an error message.
How To: Change a function in a Microsoft Excel pivot table
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 86th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a TRUE/FALSE formula to change the function of pivot table as well as how to filter one.
How To: Embed Windows Media Player in PowerPoint
If you are looking to get your point across even better, why not add video to your Powerpoint presentation?
How To: Embed a video into PowerPoint on a Mac
One of the best ways to get your point across during a PowerPoint presentation is to use video. This way, you can not only tell your classmates, students or coworkers about your subject with words and images, but you can actually show them with real footage.
How To: Create an Excel inventory template with running totals
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Create random basic math problems in Microsoft Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 71st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create random math problems for your kids with the CHOOSE, RANDBETWEEN, DOLLAR and TEXT functions. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Count unique values greater than a hurdle in MS Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Extract records with an advanced filter in Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.