Home
About Jeanina
References
On Site Classes
Adult Education Classes
Technology Training Center

Intermediate Microsoft Excel

Jeanina Sargent (717) 586-1878

jeanina@sargentsoftware.com

 

This advanced 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