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) |