Download - BASIC / ADVANCED TOPICS EMPLOYTEST WEB SITE JOHN KOVACEVICH [email protected] Microsoft Excel
![Page 2: BASIC / ADVANCED TOPICS EMPLOYTEST WEB SITE JOHN KOVACEVICH KOVACEVI@TAMUG.EDU Microsoft Excel](https://reader035.vdocuments.us/reader035/viewer/2022071806/56649d215503460f949f6084/html5/thumbnails/2.jpg)
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
![Page 3: BASIC / ADVANCED TOPICS EMPLOYTEST WEB SITE JOHN KOVACEVICH KOVACEVI@TAMUG.EDU Microsoft Excel](https://reader035.vdocuments.us/reader035/viewer/2022071806/56649d215503460f949f6084/html5/thumbnails/3.jpg)
Sorting Data
Video on Sorting Data
http://www.youtube.com/watch?v=_7U0aWzTkkY
![Page 4: BASIC / ADVANCED TOPICS EMPLOYTEST WEB SITE JOHN KOVACEVICH KOVACEVI@TAMUG.EDU Microsoft Excel](https://reader035.vdocuments.us/reader035/viewer/2022071806/56649d215503460f949f6084/html5/thumbnails/4.jpg)
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.
![Page 5: BASIC / ADVANCED TOPICS EMPLOYTEST WEB SITE JOHN KOVACEVICH KOVACEVI@TAMUG.EDU Microsoft Excel](https://reader035.vdocuments.us/reader035/viewer/2022071806/56649d215503460f949f6084/html5/thumbnails/5.jpg)
Employee Test Website
Login site for EmployTest-MS Office
http://employtest.howtomaster.com
Contact Information Services for your Username and Password
![Page 6: BASIC / ADVANCED TOPICS EMPLOYTEST WEB SITE JOHN KOVACEVICH KOVACEVI@TAMUG.EDU Microsoft Excel](https://reader035.vdocuments.us/reader035/viewer/2022071806/56649d215503460f949f6084/html5/thumbnails/6.jpg)
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