Learn what you should already know about Microsoft Excel 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.
- Drawing process flow diagrams
- Calculating process capacity
- Identifying bottlenecks
- Determining cycle time and idle time
- Calculating labor
- Calculating utilization
- Analyzing batch processes
- Calculating optimal order quantities