253,792 views 146 on YTPak
972 31

Published on 07 Jun 2012 | over 4 years ago

Download workbook: people.highline.edu/mgirvin/ExcelIsFun.htm
See how to:
1. Enter Data On One Sheet and then click Button To Send Data To Table on Second Sheet
2. Recorded Macro: Move Record From Data Entry Sheet To Table On Second Sheet
3. Learn how to Show Developer Ribbon (Excel 2010 = Right-click Ribbon, Customize Ribbon, Checkbox for Developer Ribbon)
4. Keyboard: Alt + F8 = List of Macros
5. Keyboard: Alt + F11 = VBA Editor
6. Learn how to use Absolute and Relative References in Recorded Macro
7. Add Form Button To Sheet that can be clicked to execute recorded Macro.
8. Absolute References = Selecting Cells with Macro Recorder on means Absolute Movement
9. Relative References = Selecting Cells with Macro Recorder on means Relative Movement
10. View Code: Range function for Absolute References, OFFSET Function for Relative References

Loading related videos...