Microsoft Excel 2007 - Macros
Macros are advanced features that can speed up editing or formatting you may perform often in an Excel worksheet. They record sequences of menu selections that you choose so that a series of actions can be completed in one step.Recording a MacroTo record a Macro:Click the View tab on the RibbonClick MacrosClick Record MacroEnter a name (without spaces)Enter a Shortcut KeyEnter a DescriptionPerform the MacroClick MacrosClick Stop RecordingRunning a MacroTo run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the Macro. Or you can view all macros and run by:Click MacrosClick View MacrosChoose the Macro and click Run
Description
Microsoft Excel 2007 has a completely redesigned user interface. The standard menus along the top have been removed and replaced with a series of toolbars Microsoft calls “The Ribbon.” These tool bars are changed using tabs at the top and try to automatically adjust themselves to the content you are working with. If you select an image it will automatically switch to the picture tools. The new layout seems to offer easier access to most of the features of Excel allowing for more complex documents to be created quicker.
Presentation Transcript
Your Facebook Friends on WizIQ