Forgot your password?

Excel 2007 Training Advanced

Title Banner
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 - - -
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo

© 2013 CustomGuide, Inc. All rights reserved.