Intermediate Microsoft Excel

This advanced Microsoft Excel class will teach time saving techniques to apply to multiple worksheets. Student will learn how the recording of repetitive keystrokes in a macro can add efficiency to their spreadsheet. Importing/Exporting files will also be covered.

Using Block Names

• Creating Block Names
• Using Names in Formulas
• Using Names to Move Around
• Paste List

Linking Files

• Linking Files
• Editing Links

Workspace

• Creating a Workspace
• Protecting Workbooks
• Hiding Columns

Working with Multiple Worksheets

• Moving Between Multiple Worksheets
• Naming Worksheets
• Grouping Sheets
• Moving/Copying From One Worksheet to Another

Macros

• Recording a Macro
• Stopping the Macro Recording
• Running the Macro

Importing/Exporting

• Importing and Exporting
• Working with Word