Intermediate Excel

USING EXCEL FUNCTIONS
    What is a Function?
    Using the SUM Function
    Using the AVERAGE Function
    Using the MAX and MIN Functions
    Using the Paste Function Button
    Using AutoCalculate

CREATING A CUSTOM TABLE

USING ABSOLUTE CELL REFERENCES
    Entering an Absolute Column and/or Absolute Row Reference into a Formula

CREATING A CHART
    What is a Chart?
    Plotting a Basic Chart
    Modifying and Enhancing a Basic Chart
    Plotting Non-Contiguous Data Ranges
    Plotting a Pie Chart
    Adding New Data to a Chart

WORKING WITH A DATABASE
    What is a Database?
    Sorting Database Records
    Sorting Records by Entries in One Field
    Sorting Records by Entries in Multiple Fields
    Totaling Database Entries
    Filtering Database Records
    Specifying a Criteria Range in a Filter Operation
    Specifying Date Criteria in a Filter Operation
    Using a Data Form to Enter Database Records

CONTROLLING THE WORKSHEET DISPLAY
    Splitting the Workbook Window into Panes
    Freezing Window Panes
    Modifying the Screen Size of a Worksheet

USING EXCEL INTERNET FEATURES
    Accessing the World Wide Web from Excel
    Linking an Excel Worksheet to a Web Page
    Saving an Excel Worksheet as an HTML Document

Back to UT Training Classes





	Copyright ©2003 The University of Tennessee · Knoxville Tennessee 37996 · Telephone 901-737-6180 Voice/TDD