Hot Microsoft Office How-Tos
How To: Copy & paste a list of all names in an Excel workbook
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12.66th installment in his series of Excel name tricks, you'll learn how to paste a list of all names in the workbook, both the name and the formula that defines the name.
How To: Use dynamic range names in Excel 2007 tables
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.
How To: Apply names to formulas with Excel's Apply Name tool
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel name tricks, you'll learn apply names to formulas using Excel's built-in Apply Name Feature.
How To: Store lookup tables in memory in Microsoft Excel
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 10th installment in his series of Excel name tricks, you'll learn how to store lookup tables in memory using a named array.
How To: Name cell ranges with relative references in MS Excel
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.
How To: Use names and wildcards with Excel's COUNTIF function
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.
How To: Use Excel names with pivot tables & data validation
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel name tricks, you'll learn to use names with pivot tables, data validation & the VLOOKUP & COUNTIF functions and formulas.
How To: Create quick formulas with Excel names in MS Excel
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 4th installment in his series of Excel name tricks, you'll learn to use short Excel names to expedite the formula creation process. For detailed instructions, watch this free video Excel lesson.
How To: Use names in formulas and functions in Microsoft Excel
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.
How To: Find simple probabilities in Microsoft 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 51st installment in his "Excel Statistics" series of free video lessons, you'll learn how to understand, work with and find simple probabilities in Microsoft Office Excel.
How To: Work with probabilities in Microsoft Office 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 50th installment in his "Excel Statistics" series of free video lessons, you'll learn the basics of probability:
How To: Build confidence intervals & test hypotheses 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 47th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values. Compare building confidence int...
How To: Work with bell curves in Microsoft 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 47th installment in his "Excel Statistics" series of free video lessons, you'll learn about the basics of the empirical rule (the bell curve) and how to apply it in various ways.
How To: Find deviations and variance for a population 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 41st installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate deviations, variance and standard deviation for a sample and a population using Excel tables and the VAR, S...
How To: Find statistical critical & p values 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 89th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values.
How To: Find confidence intervals with a sigma value 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 80th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma is known known using the CONFIDENCE and NORMSINV functions.
How To: Find confidence intervals without the sigma 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 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...
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: Group quantitative data into classes 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 20th installment in his "Excel Statistics" series of free video lessons, you'll learn how to take raw quantitative (numerical) data and figure out how to group it into classes so that you can have categories an...
How To: Use NORMSINV with critical values in Microsoft 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 87th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use NORMSINV to test a hypothesis with population standard deviation (sigma) known and proportions.
How To: Test a hypothesis with Excel's TINV & TDIST functions
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 92nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the TINV and TDIST functions to test a hypothesis.
How To: Use the NORMSINV & NORMSDIST in Microsoft 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 93rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV and NORMSDIST functions to complete a hypothesis test about a population proportion.
How To: Build confidence intervals given the sigma 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 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...
How To: Construct confidence intervals with TINV 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 83rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) in NOT known using the TINV function.
How To: Construct confidence intervals with Excel's NORMSINV
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 85th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.
How To: Find the sample size for confidence intervals 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 87th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate sample size (n) for confidence intervals.
How To: Create quantitative data cross tabulation 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 29th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data cross tabulation using a pivot table (PivotTable).
How To: Create a stem & leaf chart with Excel's REPT & COUNTIF
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 28th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data stem & leaf charts using the REPT and COUNTIF functions.
How To: Plot data with Microsoft Excel's REPT & COUNTIF tools
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 27th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a quantitative data dot plot chart using the REPT and COUNTIF functions.
How To: Work with skew and histograms in Microsoft 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 23rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with skew in histograms for quantitative Data. Learn how to skew left (negative) and skew right (positive) with ...
How To: Group categories in an Excel frequency distribution
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 19th installment in his "Excel Statistics" series of free video lessons, you'll learn how to group categories in a frequency distribution with a formula (2 COUNTIF) and the pivot table (PivotTable) grouping fea...
How To: Cross tabulate categorical data with formulas 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 17th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using formulas rather than pivot tables.
How To: Chart a categorical frequency 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 13th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a column chart from a frequency distribution for categorical data.
How To: Create a relative frequency 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 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...
How To: Chart cross-sectional and time series 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 11th installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with, and create charts for, cross-sectional and time-series data.
How To: Install the Microsoft Excel Data Analysis add-in
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 13th installment in his "Excel Statistics" series of free video lessons, you'll learn how to install the Excel 2007 Data Analysis add-in.
How To: Use absolute and relative cell references 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 5th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use relative and absolute cell references to save time when writing formulas.
How To: Use Microsoft Excel's sort and pivot table tools
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 3rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Excel's sorting and pivot tables (PivotTables) data analysis tools.
How To: Automatically highlight negative numbers 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 4nd installment of his "YouTubers Love Excel 2007" or YTLE2k7 series of free video MS Excel lessons, you'll learn how to use conditional formatting to add red to negative numbers and green to positive numbers using a single True/False formula!
How To: Calculate weighted & geometric mean in Microsoft 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 35th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate weighted and geometric means and see how to use the GEOMEAN function.