Course Outline
Lesson 1: Macros
This lesson explains how to create and run macros.
- Introducing Macros
- Creating and Modifying Macros
- Running Macros When a Button Is Clicked
- Running Macros When a Workbook Is Opened
Lab : Macros
- Examine, step through, and run a macro
- Record, save, and run a macro
- Run macros from the Quick Access Toolbar and by clicking a workbook shape
- Run a macro when someone opens a workbook
Lesson 2: Office Document Recycling
This lesson explains how to use Office documents in Excel workbooks and how to use Excel data in other Office programs.
- Including Office Documents in Worksheets
- Storing Workbooks as Parts of Other Office Documents
- Creating Hyperlinks
- Pasting Charts into Other Documents
Lab : Office Document Recycling
- Link a presentation to a workbook, and edit the presentation
- Embed a workbook in a presentation, and change the formatting of the workbook
- Create two hyperlinks to different locations
- Copy and paste a chart into a presentation.
Lesson 3: Collaboration
This lesson explains how to collaborate on Excel files by sharing files, managing comments and changes, password-protect workbooks and worksheets, use digital signatures, save and publish Excel data.
- Sharing Data Lists
- Managing Comments
- Tracking and Managing Colleagues’ Changes
- Protecting Workbooks and Worksheets
- Authenticating Workbooks
- Saving Workbooks for the Web
Lab : Collaboration
- Turn on workbook sharing, and send the workbook as an e-mail attachment.
- Add, highlight, review, and delete comments.
- Track, accept, and reject changes; and create a History worksheet.
- Create passwords, and hide the formula.
- Digitally sign a workbook.
- Convert a workbook to a Web page, and publish a PivotTable to the Web
For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.