How to Find Mean in Excel

News : The HoloLens Lets You Watch TV in a Whole New Way

Are there any benefits to watching a movie in a holographic mixed reality headset, or should you just stick with your TV? It's not as cut and dried as you might think. While TVs have some advantages, so does the virtual screen of a Microsoft HoloLens. As augmented reality tec ...more

How To : Dominate the New York Times Crossword Puzzle

First off, don't be frustrated. YOU CAN DO IT! Contrary to the message in the image above, it's NOT over. It's just beginning. And when it comes to solving the New York Times crossword puzzle, the old cliche does apply: practice makes perfect. I've read quite a few books and ...more

How To : Find the secret palmistry meaning in the fingers

Just because it's called palm reading doesn't mean it's only "palm" reading. Palmistry involves more than mere palms — it looks at all parts of the grasping side of the hand, including the fingers. And in this two-part video from Jim Winter, a professional palmist, tarot reade ...more

How To : Write a simple Java program to average numbers

Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBostonian will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to build ...more

How To : Generate a dynamic list from a table in MS Excel

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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from ...more

How To : Use the timer setting on your Nikon digital SLR

If you're starting to use your digital SLR for the first time, it can be quite confusing to determine what all its functions mean as well as where to find them and how to use them. The timer setting on a digtal SLR camera is the same as the timer setting on all other cameras, ...more

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 Excel ...more

How To : Read Guitar Tab

Guitar Essentials My friends and I would secretly scribble tab in the darkly lit practice rooms in our university even though we were educated musicians. So, being able to read tablature, or tab, is essential for beginning guitarists. Tab is a curious way to write down music ...more

How To : Calculate a standard (z) score 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 Excel ...more

How To : Cross tabulate categorical data 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 Excel ...more

How To : Use the sparkline function in Microsoft Excel 2010

There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and ...more

How To : Evaluate vendors with array formulas 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 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find th ...more

How To : Create a Tangent Line with Excel

Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for S ...more

How To : Group quantitative data 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 Excel ...more

How To : Do basic statistical analysis in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel ...more

How To : Open Windows mail attachments on a Mac

When you're a Windows OS user it's very easy to send out attachments on emails as .doc documents, made in Microsoft Office or Excel. But just because you're a Windows user doesn't mean your friend or coworker is. Or say that you're a MAC user and your friend keeps loading you ...more

Change a Roadside Flat Tire : The Definitive Guide

Someday, maybe not today, maybe not tomorrow, but someday, you'll find yourself on the road in your car, maybe on the highway, and you'll hear something. With your air conditioning on full blast and your stereo so loud your ears feel like they are bleeding, you normally would ...more

How To : Make Money by Streaming Videos Online

Want to make money by streaming videos online? Here's three steps to success. Find Good Quality Websites to Submit Videos First and foremost, you need to do your research online and check out good quality streaming websites that have high traffic volumes each day, as well as ...more

How To : Repurpose last season's skirt into a cute tote bag

Vintage is in right now, but that doesn't mean everything you can dig up in your mother's closet is fashionable (we're thinking her neon '80s balloon pants here). If you happen to find a skirt in her collection that's dyed a nice color but cut entirely wrong to look good on an ...more

How To : Filter data using MS Excel 2010's PivotTable slicer

This video shows how to make a quick pivot table data filtering by using Excel 2010's ‘Slicer’ functionality. ‘Slicer’ delivers enhanced visual filtering method to allow you to get the data you need more quickly. When selecting a cell in the pivot table you will find ‘Slicer’ ...more

How To : Calculate standard deviation

Looking to find the standard deviation of your set of values? Standard deviation quantifies how diverse the values of your data set are, and is useful in determining how different your numbers are from each other. You Will Need: • Data • A calculator Step 1: Collect your d ...more

How To : Calculate total savings in Excel

This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches f ...more

How To : Use Microsoft Excel 2007 as a complete beginner

If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the ...more

How To : Use Excel formulas & functions

In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A general knowledge of Excel is helpful for navigating the menus in Excel, but if y ...more

How To : Make a mean cat like you

Got a nasty cat that you're trying to make nice with? Even though cats can be fickle, they can still be won over. This simple trick will help you win over the neighbor's, friend's or even your own pet cat. Watch this video tutorial and find out how to make a mean cat like you.

How To : Make a super-fast pie chart with Create a Graph

There are times when you need to make a super-quick pie chart (such as to insert in a blog post or quick printout) but find that doing it in Excel or OpenOffice takes a bit more effort than you’d like. Is there a faster way for quick’n'dirty pie charts? Yes. You can use Create ...more

How To : Find intervals with a TI-83 graphing calculator

Need to know how to use your Texas Instruments graphing calculator for your college math or statistics class? You're in luck... watch this video tutorial to see how to find intervals with a TI-83 graphing calculator. Confidence intervals for single population means: sigma unk ...more

How To : Use keyboard shortcuts in MS Excel

Do you want learn some quick ways to hide columns in Excel? Or to move within worksheets? In this video tutorial you will find 10 great keyboard shortcuts to speed up your Excel workflow.

How To : Pull text from Excel cells & separate into columns

Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT( ...more

How To : Use 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 Excel ...more

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 Excel ...more

How To : Deliver the sheet tab name to a cell 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 39th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the RIGHT, LEN, FIND & REPLACE ...more

How To : Read Guitar Tab

Guitar Essentials My friends and I would secretly scribble tab in the darkly lit practice rooms in our university even though we were educated musicians. So, being able to read tablature, or tab, is essential for beginning guitarists. Tab is a curious way to write down music ...more

  • Hot
  • Latest