Learn Tables, Formulas, and Spreadsheets in Excel 2010


show more Recording and using a simple macro provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Recording and using a simple macro

We're going to record a basic macro that take cells from one worksheet and deposits them at the bottom of this worksheet. Now because this is an Essential Training course we're only giving light coverage to macros. If you're interested in learning about macros in depth, check out some of the really great macro courses in the lynda.com library. But before we begin recording there is some housekeeping that we need to do first. To record macros we need to display the Developer tab on the Ribbon bar. Now on my computer here, you see there is no Developer tab. If you have the Developer tab on your computer you don't have to go through this step.

But I am going to go here to the File tab to go to Backstage View, and down over here let's click Options and we have all the Options categories here on the left and let's click over here where it says Customize Ribbon. Now on the right, we have a list of all the tabs that are visible, Home, Insert, Page Layout and so on, and ...

Recording and using a simple macro
Video duration: 11m 58s 6h 21m Beginner

Viewers:

Recording and using a simple macro provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...