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