FREEZE PANES LESSON ITEM #13: When working with very large spreadsheets, headings located at the top and down the left REASON: side of the worksheet often disappear if you scroll too far down or to the right. Without the headings, it’s tough to keep track of which column or row or date you are working with. Action #1: Locate the button located in the of the tab “Freeze Panes” “Window” section “View” Action #2: Open the existing document file labeled located in the Intro to Excel “Freeze Panes Practice” folder stored on the C: drive in the folder labeled DO NOT “Training Class Files – REMOVE”. Select cell B3. Click on the Freeze Panes button from the View tab and choose “Freeze Panes” from the drop-down menu. Notice how the row of table headings and column of team member names stay in place as you scroll. Select from the Freeze Panes button to remove the setting. “Unfreeze Panes” SECTION III: COMPLETE! SECTION IV: FORMATTING A WORKSHEET SIMPLE FORMULAS LESSON ITEM #14: REASON: Microsoft Excel can be a powerful mathematical tool if you understand how to create and manipulate formulas within the spreadsheet DEFINITIONS: FORMULA A calculation or set of calculations that are performed within a Microsoft Excel – spreadsheet FORMULA BAR The area in which formulas are entered into a cell – Action #1: Locate the button located in the section of the tab “Autosum” “Editing” “Home” Action #2:
LESSON ITEM #13: FREEZE PANES REASON: When working with very large spreadsheets, headings located at the top and down the left side of the worksheet often disappear if you scroll too far down or to the right. Without the headings, it’s tough to keep track of which column or row or date you are working with. Action #1: Locate the “Freeze Panes” button located in the “Window” section of the “View” tab Action #2: Open the existing document file labeled “Freeze Panes Practice” located in the Intro to Excel folder stored on the C: drive in the folder labeled “Training Class Files – DO NOT REMOVE”. Select cell B3. Click on the Freeze Panes button from the View tab and choose “Freeze Panes” from the drop-down menu. Notice how the row of table headings and column of team member names stay in place as you scroll. Select “Unfreeze Panes” from the Freeze Panes button to remove the setting. SECTION III: COMPLETE! SECTION IV: FORMATTING A WORKSHEET LESSON ITEM #14: SIMPLE FORMULAS REASON: Microsoft Excel can be a powerful mathematical tool if you understand how to create and manipulate formulas within the spreadsheet DEFINITIONS: FORMULA – A calculation or set of calculations that are performed within a Microsoft Excel spreadsheet FORMULA BAR – The area in which formulas are entered into a cell Action #1: Locate the “Autosum” button located in the “Editing” section of the “Home” tab Action #2:
WFC424-0414-Introduction-to-Excel-2010-Workshop.docx