Viewers: in countries Watching now:
In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as 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 are included with the course.
If you found this course beneficial but if you want to know more about Visual Basic, the language of macros, check out Curt Frye's course on VBA In Depth. If you want to review of some of the new features in Excel 2010, you might want to check out Bob Flisser's course on Excel 2010 New Features. If you want to know more about power shortcuts, you might check out my course on Excel 2010 Power Shortcuts. Thank you for watching!
There are currently no FAQs about Excel 2010: 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.