1 / 0

Microsoft Excel

Microsoft Excel. basic / advanced topics Employtest web site John Kovacevich kovacevi@tamug.edu. 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

matteo
Download Presentation

Microsoft Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Excel

    basic / advanced topics Employtest web site John Kovacevichkovacevi@tamug.edu
  2. 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
  3. Sorting Data Video on Sorting Data http://www.youtube.com/watch?v=_7U0aWzTkkY
  4. 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.
  5. Employee Test Website Login site for EmployTest-MS Office http://employtest.howtomaster.com Contact Information Services for your Username and Password
  6. 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
  7. Questions and Lessons Questions Lessons on your own Thank You John Kovacevichkovacevi@tamug.edu
More Related