Highline Excel Class 52: Recorded Macro Basics

Learn about:
1.How to Record a Macro
2.Macro = VBA code
3.Macros are great for repetitive tasks
4.What file extension to use for Excel 2007: .xlsm
5.How to show Developer Ribbon in Excel 2007
6.Relative and Absolute References in Excel Macros
7.Paste Special Values Absolute Macro
8.Paste Special Values Relative Macro
9.Learn about VBA editor window
10.View code for a Recorded Macro
11.View List of Macros
12.See the difference between Range(A1) and OFFSET(0,2)
13.Create an Income Statement Template with a Macro
14.See how to edit a Macro when you make a mistake
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Category:

Education

Tags:

• Excel
• Recorded
• Macro
• Basics
• Relative
• Absolute
• References
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[sarahliu122]

Thank you so much for another great tutorial!

[ExcelIsFun]

@sarahliu122 , you are welcome!

[rapturousgautam]

Hi,

Thanks for sharing your knowledge with us. Just one question, if I were to do the paste special exercise, say, a 500 times, in a sheet. is there a shortcut to do the same in a matter of seconds rather than having to refer each cell & type the macro short cut key those many times? Thx.

[ExcelIsFun]

I am sure that there is but I do not know how to do it. Try posting to THE best Excel question site:

mrexcel[dot]com/forum

[cfa861]

how to download this video

[ExcelIsFun]

I do not know how to download the videos. To learn how to download the workbooks, search for this video title and watch;

excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks

[elecnautic227]

@cfa861 go to keepvid.com and paste the URL of the video you like.. follow the instructions and it will let you download any video from youtube..

cheers

[ExcelIsFun]

I do not know. I am not good with VBA code. Try this amazing Excel site:

mrexcel[dot]com/forum

[zlabros]

WHAT I MUST TYPE IF I WANT TO MACRO BE ENABLED ONLY IN THE A COLUMN AND WHEN I GO TO B COLUMN MACRO DO SOMETHING ELSE (LIKE CUT AND PASTE)

PLS HELP

[ExcelIsFun]

I have no idea about how to download these. You might Google it and see if there is a way.