Welcome to your ebay Shop Talk Information Page
Shop Talk – Microsoft Excel – with Tom Vorves
My name is Tom Vorves and I will be your Shop Talk guru on September 3rd
Below you will find:
- Topic List
- Exercise File(s)
- Links to useful Resources
I look forward to seeing all of you in this Excel Shop Talk session.
Bring your brains!!!
Microsoft Excel Shop Talk Topics
- Tips for managing large spreadsheets
- Keyboard shortcuts
- On-Screen tools for navigation
- Hide and show columns, tables, values
- Custom views
- Freeze panes
- Handy features
- Scenario Manager
- Open 2 different spreadsheets
- Sort and filter data
- Conditional formatting
- Cell references
- Useful Formulas
- Smart plots
- Power charts
- Pivot Tables
- Pivot Charts
These downloadable files will be used by Tom during the session. If you would like to have the files for review and reference before and after our session, feel free to download them by simply clicking the supplied links.
Resources for you from Tom
Here are some useful resources you might enjoy:
Tom Vorves – Technology Simplified Blog
Tom’s blog is filled with shortcuts and fun facts about technology. Visit Tom’s blog and sign up for his monthly newsletter and receive great tips and tricks about technology and productivity software. You will also have links to Tom’s monthly How-To videos.
What Tom can do for you
Tom has been an instructor for many years, teaching profession people how to use software and the skills required to apply what they have learned in their business world. Tom has the skill and knowledge to make your training day a success from beginning to end.
Along with training, Tom offers consulting on a wide range of subjects including SharePoint implementation strategies. Tom can guide you to a successful SharePoint rollout that benefits your employees and your business.
If you need to automate your Microsoft Office workflow, Tom is prepared to guide you down the path of productivity through automation and collaboration.
Microsoft Excel Complete List of Keyboard Shortcuts
This link will take you to Microsoft’s web page which lists all of Excel’s keyboard shortcuts
Excel 2013 Quick Reference Guide for Beginners
This is a short document with basic how-to steps to get started with the most commonly used Excel features