Practice Document - Excel Workshop workbook.
Excel Tutorials and Resources
A useful resource is Atomic Learning, an electronic help desk with thousands of short tutorial movies covering many common software applications such as Word, Excel, FrontPage, MovieMaker, Photo Story, Powerpoint (from Microsoft); Acrobat, Dreamweaver, InDesign, Photoshop (from Adobe); netTrekker, Picasa, Geometer's Sketchpad, Inspiration/Kidspiration, and KidPix. This database is provided by Iowa AEA Online.
Check out the following Atomic Learning tutorial videos. (You'll need to enter your school's login/password. See your librarian.)
A. Basics
- Using the new Excel 2007 interface
- Using and minimizing the ribbon
- Using the Quick Access toolbar
- Customizing the Quick Access toolbar
- Understanding a worksheet and entering information into a cell
- Changing the default worksheets and cell movement
- Using a template
- Using save and save as
- Using compatibility mode
- Opening Excel 2007 files in earlier versions of Excel
- Moving with the keyboard pt. 1
- Moving with the keyboard pt. 2
- Using keytips
- Creating a PDF
B. Working with Cells
- Using AutoComplete
- Editing a cell
- Using spell check
- Selecting cell ranges pt. 1
- Selecting cell ranges pt. 2
- Entering values in a cell range
- Using AutoFill
- Using cut, copy and paste
- Using Paste options
- Using the paste list and paste special
- Using the clipboard
- Using drag and drop editing
- Using undo and redo
- Using the Clear command
C. Formulas and Functions
- Using autocalculate
- Using auto sum
- Creating formulas
- Using functions and the function wizard pt. 1
- Using functions and the function wizard pt. 2
- Editing formulas
- Checking formulas for errors
- Using relative cell referencing
- Understanding absolute cell references
- Creating an absolute cell reference
D. Formatting Cells
- Formatting numbers using the ribbon
- Formatting text using the ribbon
- Using the Alignment and Indentation commands
- Rotating information in a cell
- Wrapping text in a cell
- Using the Merge and Center command
- Using the Borders command
- Drawing cell borders
- Formatting information using the format cells dialog box
- Using the Format Painter command
E. Working with Columns and Rows
- Selecting columns and rows pt. 1
- Selecting columns and rows pt. 2
- Changing column width
- Changing row height
- Hiding and unhiding columns and rows
- Inserting columns
- Inserting rows
- Deleting columns and rows
- Inserting and deleting cells
F. Styles, Themes, and Tables
- Using cell styles
- Creating a custom cell style by example
- Creating a custom cell style
- Deleting a custom cell style
- Modifying a custom cell style
- Merging custom cell styles
- Using themes
- Customizing themes
- Formatting as a table pt. 1
- Formatting as a table pt. 2
- Creating a custom table style pt.1
- Creating a custom table style pt. 2
- Deleting a custom table style
G. Workbook Views and Page Setup
- Using Normal view
- Using Page Layout view
- Using Page Break preview
- Using the Page Layout command tab
- Changing the margins
- Changing the page orientation and paper size
- Setting manual page breaks
- Setting print titles
- Creating headers and footers
- Using the Page Setup dialog box
H. Printing
- Using print preview
- Printing
- Printing selected ranges
- Setting, adding to, and removing print areas pt. 1
- Setting, adding to, and removing print areas pt. 2
I. Help
Excel Tip.com - Tips, Training and Consulting - http://www.exceltip.com/exceltips.php?view=excelversion&ID=1
This page was last updated on February 10, 2011.