Spreadsheet Basics (PDF)
• Screen elements
• Adding and renaming worksheets
• The standard toolbar - opening, closing, saving, and more.
• Menus
• Customize toolbars
• Recording a macro
• Running a macro
Modifying A Worksheet (PDF)
• Moving through cells
• Adding worksheets, rows, and columns
• Resizing rows and columns
• Selecting cells
• Moving and copying cells
• Freeze panes
Formatting Cells (PDF)
• Formatting toolbar
• Format Cells dialog box
• Dates and times
• Styles
• Style dialog box
• Create a new style
• Format Painter
• AutoFormat
Formulas and Functions (PDF)
• Formulas
• Linking worksheets
• Relative, absolute, and mixed referencing
• Basic functions
• Function Wizard
• Autosum |
|
Sorting and Filling (PDF)
• Basic ascending and descending sorts
• Complex sorts
• Autofill
• Alternating text and numbers with Autofill
• Autofilling functions
Graphics (PDF)
• Adding clip art
• Add an image from a file
• Editing a graphic
• AutoShapes
Charts (PDF)
• Chart Wizard
• Resizing a chart
• Moving a chart
• Chart formatting toolbar
Page Properties and Printing (PDF)
• Page breaks
• Page orientation
• Margins
• Headers, footers, and page numbers
• Print Preview
• Print
Keyboard Shortcuts (PDF) |