Join Curt Frye for an in-depth discussion in this video What you should know, part of Learning Excel: Data-Analysis.
- [Instructor] Before I dive into the course, I'd like to give you an idea of what techniques you should be familiar with before you start. You should know how to gather and organize data effectively. Essentially, that means bringing data into Microsoft Excel so that you can analyze it. Next, you should know how to create formulas in Excel, and that should have a specific focus on using relative and absolute references. A lot of the techniques that you will use in analyzing data will require formulas to be copied. Copying formulas will save you a lot of work, but it's possible to create errors if you don't have your relative and absolute references, that is changing versus unchanging, correct.
Next, you should know how to create charts, specifically histograms and XY scatter charts. And finally, you should realize that your ribbon might look different based on your screen's resolution. If we look at a very high resolution screen, you'll see that the ribbon has almost all of the buttons with their full labels and also the styles gallery is fully expanded. At what I refer to as a medium resolution, you'll see that the styles gallery is down to a button, and that some of the groups have been rearranged, going from large buttons to small buttons.
At a smaller resolution, you will see the ribbon at its most compact, and that's where most of the labels are gone from the buttons, and also some of the galleries, which were previously larger buttons, are now smaller. So, while your screen might look a little different than mine, be assured that all of the commands are there.
- Calculating mean and median values
- Analyzing data using variance and standard deviation
- Working with sample data
- Minimizing errors
- Visualizing data with histograms, charts, and more
- Testing hypotheses
- Measuring covariance and correlation
- Performing Bayesian analysis