Excel 2003: Part 2, Working with Functions and Multiple Sheets Course, Class Outline

(0.5 day)
Version 11.0

Prerequisites
Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. Ability to copy, move and delete values and formulas is required. Completion of Excel 2003: Part 1, Introduction is recommended.

Duration 0.5 day(s)

Working with Worksheets

Viewing, Renaming and Color-coding Worksheets
Editing a Group
Manipulating Worksheets

Protecting Workbooks and Worksheets

Working with Functions
Creating and Using Named Ranges
Creating a Relative Name
Using Custom Zoom
Using Functions
Working with Insert Function

Using Financial Functions

Using Date Functions
Working with Formatting and Data Validation
Using Conditional Formatting
Using Data Validation
Creating and Using Custom Formats
Working with Auditing and Error Checking Tools

View outline in Word

WEXB03

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If travel is inconvenient you may be able to participate from your office or home. If you have high-speed internet you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group either at your location or ours. Click the link to request more information.

Request our mailings

800-288-8221

Search for

SCHEDULE

Ready to Run
All Classes

OTHER INFO
RCI Login
Registration
Locations/Directions
Classroom Rentals
CEU/CPE Credits
Privacy Policy
About Us
Contact Us

ONLC TRAINING CENTERS

800-288-8221 (USA) / 302-225-4470 (Other)

www.onlc.com

ONLC Training Centers has grown to be the largest IT training company in the US with over 200 classroom training locations. Click the links below to learn why so many people are selecting us as their training provider.
Our Classes	For Companies	RCI™
•Course Schedule (all titles) •Ready to Run Schedule (confirmed dates) •Class Registration & Policies	•Savings Options & Plans •Microsoft Office Migration •Microsoft Software Assurance Vouchers	•RCI Defined •No Travel Option •RCI FAQs
Why Register with ONLC	For Individuals	About ONLC
•Fewest Class Cancellations •Training Company Comparison •Reasons to Register Now	•Certification Programs •Savings Plans •Money Back Guarantee	•About Us •Our Instructors •Employment Opportunities
Other Information	For Government
•Events & Offers •Payment Options •Evening Sessions call for info	•Federal, State & Local •GSA •DoD 8570.1

•Locations by State
Over 200 sites throughout North America. For site details see ONLC Locations

Alabama Birmingham, AL Huntsville, AL Mobile, AL Montgomery, AL Arizona Phoenix, AZ Scottsdale, AZ Tucson, AZ Arkansas Bentonville, AR Little Rock, AR California Carlsbad, CA Century City, CA El Segundo, CA Elk Grove, CA Folsom, CA Glendale, CA Irvine, CA Los Angeles, CA Pleasanton, CA Redwood City, CA Riverside, CA Rolling Hills, CA Sacramento, CA San Diego, CA San Francisco, CA San Rafael, CA Santa Clara, CA Walnut Creek, CA Colorado Boulder, CO Centennial, CO Colorado Springs, CO Denver, CO Grand Junction, CO Loveland, CO Connecticut Danbury, CT Hartford, CT Milford, CT Newington, CT Stamford, CT Wallingford / New Haven, CT Delaware Wilmington, DE District of Columbia Washington, DC	Florida Bradenton / Sarasota, FL Boca Raton, FL Ft. Lauderdale, FL Ft. Myers, FL Jacksonville, FL Kissimmee, FL Miami, FL Miramar Beach, FL Orlando, FL Palm Beach, FL Plantation, FL St. Petersburg, FL Tallahassee, FL Tampa, FL Georgia Alpharetta, GA Atlanta, GA Buckhead, GA Dunwoody, GA Duluth, GA Kennesaw, GA Savannah, GA Idaho Boise, ID Illinois Chicago, IL Joliet, IL Naperville, IL Northbrook, IL Oakbrook Terrace, IL Peoria, IL Rockford, IL Schaumburg, IL Warrenville, IL West Dundee, IL Indiana Indianapolis, IN South Bend, IN Iowa Bettendorf, IA Cedar Rapids, IA Des Moines, IA West Des Moines, IA Kansas Overland Park, KS Topeka, KS Wichita, KS Lenexa, KS Kentucky Erlanger, KY Lexington, KY Louisville, KY Louisiana Alexandria, LA Baton Rouge, LA Lafayette, LA Lake Charles, LA Mandeville, LA New Orleans, LA Ruston / Grambling, LA Shreveport, LA	Maine Portland, ME Maryland Annapolis, MD Baltimore, MD Bethesda, MD Columbia, MD Frederick, MD Greenbelt, MD Owings Mills, MD Rockville, MD Massachusetts Andover, MA Beverly, MA Boston, MA Braintree, MA Mansfield, MA Springfield, MA Waltham, MA Westborough, MA Woburn, MA Worcester, MA Michigan Detroit, MI Grand Rapids, MI Lansing, MI Kalamazoo / Portage, MI Novi, MI Troy, MI Minnesota Edina, MN Minneapolis, MN St. Paul, MN Woodbury, MN Mississippi Jackson, MS Missouri Columbia, MO Kansas City, MO St. Louis, MO Springfield, MO Nebraska Lincoln, NE Omaha, NE Nevada Henderson, NV Las Vegas, NV Reno, NV New Hampshire Bedford / Manchester, NH Londonderry, NH Nashua, NH Rochester, NH New Jersey Bridgewater, NJ Iselin, NJ Morristown, NJ Mt. Laurel, NJ Paramus, NJ Princeton, NJ Red Bank, NJ	New Mexico Albuquerque, NM New York Albany, NY Bohemia, NY Buffalo, NY Manhattan, NY New York City, NY Poughkeepsie, NY Rochester, NY Rye, NY Syracuse, NY Uniondale, NY North Carolina Charlotte, NC Fayetteville, NC Greensboro, NC Raleigh, NC Wilmington, NC Ohio Akron, OH Beachwood, OH Cincinnati, OH Cleveland, OH Columbus, OH Dayton, OH Independence, OH Toledo, OH Oklahoma Oklahoma City, OK Tulsa, OK Oregon Beaverton, OR Bend, OR Portland, OR Pennsylvania Allentown, PA Erie, PA Exton, PA Harrisburg, PA Lancaster, PA Mechanicsburg, PA Monroeville, PA Philadelphia, PA Pittsburgh, PA State College, PA Wayne, PA Wilkes-Barre, PA Rhode Island Warwick / Providence, RI South Carolina Charleston, SC Columbia, SC Greenville, SC South Dakota Sioux Falls, SD	Tennessee Johnson City, TN Knoxville, TN Memphis, TN Nashville, TN Texas Abilene, TX Addison, TX Amarillo, TX Austin, TX Bryan / College Station, TX Corpus Christi, TX Dallas, TX El Paso, TX Fort Worth, TX Houston, TX Irving, TX League City, TX Loveland, TX McAllen, TX Midland, TX Plano / Frisco, TX Round Rock, TX San Antonio, TX Spring / The Woodlands, TX Sugar Land, TX Wichita Falls, TX Utah Provo, UT Salt Lake City, UT Vermont Burlington/Shelburne, VT Virginia Alexandria, VA Fairfax, VA Fredericksburg, VA Glen Allen, VA Manassas, VA Newport News, VA Norfolk, VA Reston, VA Richmond, VA Roanoke, VA Virginia Beach, VA Washington Bellevue, WA Bellingham, WA Bothell / Redmond, WA Kennewick / Pasco, WA Mukilteo / Everett, WA Olympia / Lacey, WA Puyallup, WA Seattle, WA Tacoma / Federal Way, WA Spokane, WA West Virginia Martinsburg, WV Wisconsin Brookfield, WI Glendale, WI Madison, WI Milwaukee, WI Wyoming Casper, WY Cheyenne, WY

•Locations by City
Attend hands on, instructor-led computer classes at our more than 200 classroom locations in these cities...

Abilene, TX Addison, TX Albany, NY Albuquerque, NM Alexandria, LA Alexandria, VA Allentown, PA Alpharetta, GA Amarillo, TX Andover, MA Annapolis, MD Atlanta, GA Austin, TX Baltimore, MD Baton Rouge, LA Beachwood, OH Beaverton, OR Bend, OR Bedford, NH Bellevue, WA Bellingham, WA Bentonville, AR Bethesda, MD Bettendorf, IA Beverly, MA Birmingham, AL Boca Raton, FL Bohemia, NY Boise, ID Boston, MA Boulder, CO Bradenton / Sarasota, FL Braintree, MA Bridgewater, NJ Brookfield, WI Bryan / College Station, TX Buckhead, GA Buffalo, NY Carlsbad, CA Casper, WY Cedar Rapids, IA Century City, CA Charleston, SC Charlotte, NC Centennial, CO Cheyenne, WY Chicago, IL Cincinnati, OH Cleveland, OH Columbia, MD Columbia, MO Columbia, SC Columbus, OH Corpus Christi, TX	Dallas, TX Danbury, CT Dayton, OH Deerfield, IL Des Moines, IA District of Columbia Duluth, GA Dunwoody, GA Edina, MN El Paso, TX El Segundo, CA Elk Grove, CA Erie, PA Erlanger, KY Exton, PA Fairfax, VA Fayetteville, NC Folsom, CA Fort Worth, TX Fort Lauderdale, FL Fort Myers, FL Frederick, MD Fredericksburg, VA Frisco, TX Glendale, CA Glendale, WI Grand Junction Grand Rapids, MI Greenbelt, MD Greensboro, NC Greenville, SC Harrisburg, PA Hartford, CT Henderson, NV Houston, TX Huntsville, AL Independence, OH Indianapolis, IN Irvine, CA Irving, TX Iselin, NJ Jackson, MS Jacksonville, FL Johnson City, TN Joliet, IL Kalamazoo / Portage, MI Kansas City, MO Kennesaw, GA Kennewick, WA Kissimmee, FL Knoxville, TN	Lafayette, LA Lake Charles, LA Lancaster, PA Las Vegas, NV League City, TX Lenexa, KS Lexington, KY Lincoln, NE Little Rock, AR Londonderry, NH Los Angeles, CA Louisville, KY Loveland, CO Madison, WI Manchester, NH Mandeville, LA Manhattan, NY Mansfield, MA Martinsburg, WV McAllen, TX Memphis, TN Miami, FL Midland, TX Milford, CT Milwaukee, WI Minneapolis, MN Miramar Beach, FL Mobile, AL Montgomery, AL Monroeville, PA Morristown, NJ Mount Laurel, NJ Mukilteo, WA Naperville, IL Nashua, NH Nashville, TN New Orleans, LA New York City, NY Newington, CT Newport News, VA Norfolk, VA Novi, MI Oakbrook Terrace, IL Oklahoma City, OK Olympia / Lacey, WA Omaha, NE Orlando, FL Overland Park, KS Owings Mills, MD	Palm Beach, FL Paramus, NJ Peoria, IL Philadelphia, PA Phoenix, AZ Pittsburgh, PA Plano, TX Plantation, FL Pleasanton, CA Portland, ME Portland, OR Poughkeepsie, NY Princeton, NJ Provo, UT Puyallup, WA Quad Cities, IA IL Raleigh, NC Red Bank, NJ Redmond, WA Redwood City, CA Reno, NV Reston, VA Richmond, VA Riverside, CA Roanoke, VA Rochester, NH Rochester, NY Rockford, IL Rockville, MD Rolling Hills, CA Rosemont, IL Round Rock, TX Ruston /Grambling, LA Rye, NY	Sacramento, CA Salt Lake City, UT San Antonio, TX San Diego, CA San Francisco, CA San Rafael, CA Santa Clara, CA Sarasota / Bradenton, FL Savannah, GA Schaumburg, IL Scottsdale, AZ Seattle, WA Shelburne, VT Shelton, CT Shreveport, LA Sioux Falls, SD South Bend, IN South Burlington, VT St. Louis, MO St. Paul, MN St. Petersburg, FL Spokane, WA Spring / The Woodlands, TX Springfield, MA Springfield, MO Stamford, CT State College, PA Sugar Land, TX Syracuse, NY Tacoma / Federal Way, WA Tallahassee, FL Tampa, FL Toledo, OH Troy, MI Tucson, AZ Tulsa, OK Uniondale, NY Virginia Beach, VA Wallingford, CT Walnut Creek, CA Waltham, MA Warrenville, IL Warwick / Providence, RI Washington, DC Wayne, PA West Dundee Westborough, MA Wichita, KS Wichita Falls, TX Wilkes-Barre, PA Wilmington, DE Wilmington, NC Woburn, MA Worcester, MA

•Attend class from Your Location
In addition to our sites, you can attend class from your PC via RCI™ in these and other areas...

Alabama Tuscaloosa, AL Arizona Flagstaff, AZ Florida Panama City, FL	Kentucky Bowling Green, KY Montana Billings, MT	North Dakota Bismarck, ND Fargo, ND Oregon Eugene, OR	South Dakota Rapid City, SD Texas Lubbock, TX	West Virginia Charleston, WV Morgantown, WV
Discover how RCI allows us to deliver live instructor-led training to just about anywhere. Learn about RCI