1 / 32

Master Excel Skills with Rudy and Heather

Join Rudy Studd and Heather Townley for an exciting Excel workshop at OETC 2014! Get ready to be amazed as you learn basic formulas, charts, graphs, and more. Participate in interactive sessions where you can work on your computer alongside the presenters, ask questions, and play fun Excel game shows. Improve your Excel proficiency and efficiency with tips and tricks shared by the experts. Don't miss this opportunity to level up your Excel game!

zalika
Télécharger la présentation

Master Excel Skills with Rudy and Heather

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