INSTITUTE OF AGRICULTURAL AND ENVIRONMENTAL RESEARCH

TENNESSEE STATE UNIVERSITY

 

Click text to select

Home
Click text to select

A Message From The Dean
Click text to select

About CARP
Click text to select

Administration
Click text to select Calendar
Click text to select

Directory
Click text to select

Employment
Click text to select

Forms
Click text to select

Links
Click text to select

News
Click text to select

Nursery Research Center
Click text to select

Organization And
Plan Of Work
Click text to select

Research Teams
Click text to select

Search
Click text to select

Seminar Series
Click text to select

Site Map
Click text to select

Standing Committees
Click text to select

Training
Click text to select

USDA At TSU

Tennessee logo

Computer Skills Development
In Agriculture

USDA Logo

A USDA/CSREES/HEP 1890 Institution
Capacity Building Grants Project

TSU Logo

Blue divider bar, triple

 

Microsoft Excel (Level 2) Microsoft Excel (Level 2)

 

Bullet 1 Course Format:
 
Bullet 1a Workshop
Bullet 3 Availability:
 
Bullet 3a Course availability will be posted at a later date.
Bullet 4 Course Contents:
 
Bullet 4a

Basic and custom formatting
Bullet 4a1 Styles and autoformats
Bullet 4a2 Templates
Bullet 4a3 Conditional formatting
Bullet 4a4 Functions
Bullet 4b

Finding information within a worksheet
Bullet 4b1 Single and multi-level sorting of data
Bullet 4b2 Creating and running queries
Bullet 4b3 Extracting data
Bullet 4b4 Filters
Bullet 4b5 Outlines
Bullet 4c Analyzing data
Bullet 4c1 Auditing worksheets
Bullet 4c2 Data validation
Bullet 4c3 Statistical analysis of data
Bullet 4c4 What-if analysis of data
Bullet 4c5 PivotTables
Bullet 4d Lists
Bullet 4d1 Creating, editing, and managing lists
Bullet 4d2 Data forms
Bullet 4d3 Sorting lists
Bullet 4d4 List sharing
Bullet 4e Graphics
Bullet 4e1 Creating, formatting, and editing charts
Bullet 4e2 Creating, formatting, and editing PivotCharts
Bullet 4e3 Creating, formatting, and editing maps
Bullet 4e4 Using images
Bullet 4f Advanced tools
Bullet 4f1 Importing and exporting data
Bullet 4f2 Copying data from web pages
Bullet 4f3 Using multiple workbooks
Bullet 4f4 Tracking changes to worksheets
Bullet 4f5 Resolving worksheet conflicts
Bullet 4f6 Merging workbooks
Bullet 4f7 Advanced previewing and printing techniques
Bullet 4g Customizing Microsoft Excel
Bullet 4g1 Add-ins
Bullet 4g2 Macros
Bullet 4g3 Scripts
 
Return to List of Courses

Return to
List of Courses

Microsoft, PivotChart, PivotTable, and Windows are registered trademarks of Microsoft Corporation.
 

Institute of Agricultural and Environmental Research, Tennessee State University

Building Partnerships to Pursue New Frontiers in Agricultural and Environmental Research