Join Curt Frye for an in-depth discussion in this video What you should know before watching this course, part of Learning Excel Cluster Analysis.
Before I describe cluster analysis in detail and show you how to build the workbooks to perform it, I'd like to give you an idea of what you should know to succeed in this course. First, you should have some experience with Microsoft Excel, especially creating formulas and charts. Some of the formulas that we'll build have multiple steps, so experience using Excel is helpful, but certainly not necessary. Next, it helps if you are familiar with Excel macros and have a bit of knowledge about Visual Basic for Applications. You can certainly perform cluster analysis as I describe it in this course without using macros or VBA, but it makes it a lot easier.
Rather than copying and pasting values from one place to another, you can use macros to facilitate the process. And finally, unlike in most other lynda.com training classes, you should be willing to work through the course's movies in order. We build the cluster analysis workbook up step by step. So, even though you can jump in and use a sample file for a later movie, it'll help your understanding if you work through the course's movies in order. With all that in place, let's get going.
- What is clustering?
- Setting up your Excel table
- Creating a list of centroids
- Identifying the closest centroid
- Updating centroids using averages
- Automating updates with macros
- Analyzing your data in Excel
- Visualizing data in a chart