How To : Find outliers using the Z-score method

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 : Making a Gantt Chart with Excel

This tutorial shows you how to use an Excel to create a project management Gantt chart. There is no default for this, but you can customize a stacked bar chart to do the job.

How To : Use repeat (REPT) function in Excel

There are many functions in Microsoft Excel. One function that people rarely use is the Repeat function or REPT. In this video, an example used is a chart of people and their sales of a certain item. Just looking at the numbers, it is hard to compare the different sales easily ...more

How To : Add scatter & bar data series to an Excel 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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a m ...more

Next Page
Prev Page
  • Hot
  • Latest