BUS 150 Study Guide - Final Guide: Microsoft Excel, List Of True Blood Characters, Delimiter

• School: University of Miami
• Department: Business
• Course: BUS 150
• Professor: Maryann Barber

Document Summary

Purpose: automate things for us make advanced tasks easy for novices. Take away the needs for human intervention (things we always do or rarely do) make things go faster, more efficiently without mistakes. Naming the macro: start with a letter + can only have letters, numbers, underscores, no spaces. Shortcut keystrokes: 1 letter, capital (ctrl + shift) and normal letters (ctrl) are different can conflict with a default shortcut key macro shortcut key takes precedent (only if the macro is in memory wb is opened) Personal macro workbook stores in the xlstart folder. Generic macro that is always available (opened) when working with any workbook. This workbook works specifically for that workbook (advanced filter, etc. ). Can be applied to any other workbook when it is in memory (wb is opened). When this workbook is not open (or in memory), macro will not be effective. Recording the macro: record the completion of the command not the execution (e. g.