1 / 32

Excellent Excel OETC 2014 # wedontunderstandtwitter

Excellent Excel OETC 2014 # wedontunderstandtwitter. Prepare to be Amazed! Presenters: Rudy Studd Heather Townley. Feel Free To…. Work on your computer and try what we’re doing as we’re instructing  We run a “we-show” & “you-try” session

zalika
Download Presentation

Excellent Excel OETC 2014 # wedontunderstandtwitter

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. Excellent ExcelOETC 2014#wedontunderstandtwitter Prepare to be Amazed! Presenters: Rudy Studd Heather Townley

  2. Feel Free To… • Work on your computer and try what we’re doing as we’re instructing • We run a “we-show” & “you-try” session • Ask questions as they come up – one of us will be walking around to help

  3. Game Show! On which tab do you find Freeze Panes?

  4. Game Show! How would you insert a comment in a cell?

  5. Game Show! • How can you add date and/or time to the cells or comments? Ctrl + colon = date Ctrl + shift + colon = time

  6. What We’ll Discuss Today… • Basic Formulas • Charts and graphs • Average, count, sum • Find and Replace • Filtering • Conditional Formatting • Text to Columns and Concatenating

  7. Basic Formulas • Use basic formulas for quick and easy tasks!

  8. Charts and Graphs

  9. Average, Count, Sum • Right click bottom bar and choose what you want to have available all the time

  10. Average, Count, Sum

  11. Find and Replace

  12. Filtering

  13. Conditional Formatting

  14. Text to Columns

  15. Concatenating

  16. Push Pin

  17. Questions?

More Related