Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2007: Macros in Depth, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can’t be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario. Exercise files accompany the
Hi, I am Dennis Taylor. Welcome to Excel 2007 Macros. If you use Excel, you invariably encounter situations where you find yourself thinking or saying, "here I go again," as you repeat a familiar command sequence or a series of steps. If you like to automate some of those tasks, then you've come to the right course. I will be showing you the basics of how to create and use macros. You will see how easy it is to create simple programs for everyday tasks, such as reformatting text, changing text layouts, and converting a list into a database.
I will emphasize the recording of keystrokes to create macros, but I will also explain why you need to know some coding to create macros for more complex tasks such as accepting user input or using a macro to perform tasks for an unknown quantity of data. And I will show you how you can create either a keyboard shortcut or a toolbar shortcut to run your macros with ease. I use macros to save time, and avoid frustration all the time. I'm looking forward to sharing my knowledge and insights with you. Let's create some macros.
There are currently no FAQs about Excel 2007: Macros in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.