BUS 340 Lecture Notes - Lecture 2: Average Selling Price, The Space Bar, Pivot Table
Document Summary
All processes can be documented (otherwise it"s just random people doing random things) All processes can be measured for effectiveness and efficiency (otherwise, why are you even bothering to do it?) For a procedure, you can only have one exit out of it (cannot break, only come together) You can have as many entrances as you want. Must have more than 1 exit (must break in 2 decisions) Exits must be exhaustive must have every possible answer as an arrow coming out. Solid lines cannot touch a data object only data lines (dotted) can touch a data object. Use cross-functional if more than one (shared) You must always have a way to exit a loop*** Averageif: (where to look, what to look for, where to find number to average) Formula paint avg vol then add tuesday-friday. For tuesday lock cell reference to k column (, ) ***avoid the space bar adding spaces messes up end result.