BASIC / ADVANCED TOPICS

EMPLOYTEST WEB SITE

JOHN KOVACEVICH KOVACEVI@TAMUG.EDU

Microsoft Excel

AGENDA

Sorting Data

Sub Totals

Basic Formulas

Formatting and Sequential numbers

Freeze/Split – Rows and Columns

Log into Employee Test Website

Do lesson on Formulas/Sorting

Pivot Table and Chart

Any time left pick your own lessons

Sorting Data

Video on Sorting Data

http://www.youtube.com/watch?v=_7U0aWzTkkY

Working With Data

Sample Data on www.tamug.edu/computing/class

Filter – Date, Numeric and Text Wild cards *, ? Between operator, And, Or

Writing Formulas

The AVERAGE and SUM functions are nested within the IF function.

Create a formula by using cell references and names.

Employee Test Website

Login site for EmployTest-MS Office

http://employtest.howtomaster.com

Contact Information Services for your Username and Password

Pivot Table/Chart

Videos on Pivot Table

http://www.youtube.com/watch?v=lEPmBuyeIxs

http://www.youtube.com/watch?v=y4z6GEnAp3E

http://www.bing.com/videos/search?q=excel+2010+pivot+table+tutorial&qpvt=excel+2010+pivot+table+tutorial&FORM=VDRE#view=detail&mid=F5066303B2A741A2A27DF5066303B2A741A2A27D

Questions and Lessons

Questions

Lessons on your own

Thank You John Kovacevich

kovacevi@tamug.edu