From the course: Excel: Business Process Analysis
What you should know before taking this course
From the course: Excel: Business Process Analysis
What you should know before taking this course
- [Instructor] Thanks again for your interest in business process analysis. Before I move on to the main part of the course, I wanted to give you an overview of some things that you should know to get the most out of the course. First, you should be familiar with Excel, as well as the user interface. You can do everything that I am demonstrating in Excel 2007 and later, and almost all of it in Excel 2003, if you're still using that version. You should also be comfortable creating formulas, this is extremely important in this course, because we create some reasonably complex formulas that analyze different parts of data and combine them into our calculations. Specifically, you should be comfortable using relative and absolute references. Relative references will change when copied from one cell to another, whereas absolute references will not. And while I certainly cover the distinction and point out when I'm using one versus the other within the course, if you know more about that going in, the better you'll understand the material the first time through.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.