Excel 2007 Training Advanced
Expand All | Collapse All
| Chapters |
Courseware |
Online
Learning |
Skills Assessments |
13. Working with the Web and External Data
| Inserting a Hyperlink |
Demo |
Demo |
Demo |
| Creating a Web Page from a Workbook |
- |
- |
- |
| Importing Data from Access or Text Files |
- |
- |
- |
| Importing Data from the Web and Other Sources |
- |
- |
- |
| Working with Existing Data Connections |
- |
- |
- |
14. Working with Macros
| Recording a Macro |
Demo |
Demo |
Demo |
| Playing and Deleting a Macro |
- |
- |
- |
| Adding a Macro to the Quick Access Toolbar |
- |
- |
- |
| Editing a Macro’s Visual Basic Code |
- |
- |
- |
| Inserting Copied Code in a Macro |
- |
- |
- |
| Declaring Variables and Adding Remarks to VBA Code |
- |
- |
- |
| Prompting for User Input |
- |
- |
- |
| Using the If…Then…Else Statement |
- |
- |
- |
15. Working with Objects
| Inserting Clip Art |
Demo |
Demo |
Demo |
| Inserting Pictures and Graphics Files |
- |
- |
- |
| Formatting Pictures and Graphics |
- |
- |
- |
| Inserting Shapes |
- |
- |
- |
| Formatting Shapes |
- |
- |
- |
| Resize, Move, Copy and Delete Objects |
- |
- |
- |
| Applying Special Effects to Objects |
- |
- |
- |
| Grouping Objects |
- |
- |
- |
| Aligning Objects |
- |
- |
- |
| Flipping and Rotating Objects |
- |
- |
- |
| Layering Objects |
- |
- |
- |
| Inserting SmartArt |
- |
- |
- |
| Working with SmartArt Elements |
- |
- |
- |
| Formatting SmartArt |
- |
- |
- |
| Using WordArt |
- |
- |
- |
| Inserting an Embedded Object |
- |
- |
- |
| Inserting Symbols |
- |
- |
- |
16. Advanced Topics
| Customizing the Quick Access Toolbar |
Demo |
Demo |
Demo |
| Using and Customizing AutoCorrect |
- |
- |
- |
| Changing Excel’s Default Options |
- |
- |
- |
| Recovering Your Documents |
- |
- |
- |
| Using Microsoft Office Diagnostics |
- |
- |
- |
| Viewing Document Properties and Finding a File |
- |
- |
- |
| Saving a Document as PDF or XPS |
- |
- |
- |
| Adding a Digital Signature to a Workbook |
- |
- |
- |
| Preparing Documents for Publishing and Distribution |
- |
- |
- |
| Publishing a Workbook to a Document Workspace |
- |
- |
- |
| Creating a Custom AutoFill List |
- |
- |
- |
| Creating a Custom Number Format |
- |
- |
- |
17. Appendix of Common Functions
| Using Logical Functions (IF) |
Demo |
Demo |
Demo |
| Using Financial Functions (PMT) |
- |
- |
- |
| Using Database Functions (DSUM) |
- |
- |
- |
| Using Lookup Functions (VLOOKUP) |
- |
- |
- |
| Financial Functions |
- |
- |
- |
| Date & Time Functions |
- |
- |
- |
| Math & Trig Functions |
- |
- |
- |
| Statistical Functions |
- |
- |
- |
| Lookup & Reference Functions |
- |
- |
- |
| Database Functions |
- |
- |
- |
| Text Functions |
- |
- |
- |
| Logical Functions |
- |
- |
- |
