Join Curt Frye for an in-depth discussion in this video What you should know, part of Learning Excel Data-Analysis.
- Before I dive into the meat of the course, I would like to give you an overview of some of the skills that you should have to succeed at Data Analysis Fundamentals with Excel. First, you should know how to gather and organize data effectively. Businesses generate a lot of data, and it's your job to bring that data into Excel so you can work with it. Next, you should be comfortable creating formulas in Excel. Pretty much all of the analysis that you do at least in the context of this course will involve Excel formulas.
So the better you are at creating them and getting help on anything you don't understand from within the program, the better off you'll be. Specifically, you should be comfortable creating relative and absolute references. Relative references change when a formula is copied from one cell to another and absolute references do not change. Many of the formulas that we create in this course will mix those two types of references so the better you are at working with them, the better off you'll be.
And finally, you should have a working knowledge of creating and modifying charts in Excel. Charts summarize your data visually, and they often allow you to gain insights with a quick look at the chart that you wouldn't have gotten from looking at the details of your data. So with those skills in mind, we can go ahead and start with Data Analysis Fundamentals with Excel.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Calculating mean and median values
- Analyzing data using variance and standard deviation
- Minimizing errors
- Visualizing data with histograms, charts, and more
- Testing hypotheses
- Measuring covariance and correlation
- Performing Bayesian analysis