This webinar will show you exactly how to organize the data with sorts and filters, how to generate quick, powerful summary reports with the surprisingly easy-to-use subtotals feature, and then really allow you to take your data to the next level with pivot tables. There will be many time-saving tips and tricks. These techniques will work cross-industry, with any type of data. You will find it to be clear and concise and right to the point, and you will be able to apply these techniques to your own data immediately after the session.
In this information age, there is an overwhelming amount of data out there. You and your company may be literally swamped with thousands or even tens of thousands of lines of transactions. How do you make sense of this huge amount of data? How do you manage it? How can this raw data be used to help you analyze and gauge your business, and help you make meaningful, impactful decisions?
Areas covered in this webinar
- Sorting your data by one more columns
- Displaying just the data you want to see with the powerful filter feature
- Making exceptional data stand with conditional formatting
- Generating a quick summary reports with the built-in subtotals feature
- How to use Pivot Tables to generate unlimited reports from your data
Who will benefit from this webinar
- Managers of all levels
- Operations personnel
- Quality assurance managers
- Lean Six Sigma Champions
- Business owners
- CEO’s / CFO’s / CTO’s
- Anybody who has to manage and summarize large amounts of data in Excel
Presenter – Tom Fragale
Tom Fragale, a computer professional with over 30 years of professional experience, has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.