Analyzing Data using Microsoft Excel Pivot Tables
Duration : 90 Minutes
Cathy Horwitz,
Cathy teaches classes on the Microsoft suite of application software including Excel, PowerPoint, Word, Access and Outlook. Cathy has over 30 years of experience in classroom and virtual training and has been an instructor of Microsoft Office since 1989.
Cathy Horwitz believes that when your employees know th Read more
If your job requires you to sift through mounds of data, do yourself a favor and join us for this user-friendly, one-hour Webinar, How to Use Microsoft® Excel® PivotTables to Easily Summarize and Analyze Data. You will be able to create summaries of your data quickly and easily without having to use advanced formulas. PivotTables are not unique to any one industry and will help with any questions you have
Course Objectives:
• PivotTables can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to your specific needs.
• In just one fast-paced and informative training session, you’ll learn how to use PivotTables better to sort your data more efficiently ... create multiple customized reports in a few easy steps ... and gain a powerful new tool to help you make better business decisions.
• In addition, you’ll get tips on the easiest way to group your data. Most importantly, when you use the power of PivotTables, you’ll be saving time and making your job easier.
Course Outline:
• Why PivotTables are the hidden gems of Excel.
• How to analyze large data sets from different business perspectives.
• Create a PivotTable to summarize data.
• Make understanding the data easier for others.
• Use PivotTables to answer questions about the data.
• Analyze patterns in the data.
• Customize the summary by grouping data
• Format PivotTables for easy viewing.
• Use a chart to view the summary visually.
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
You should attend this training if you need to use Excel to quickly build reports and summaries or if you simply want to learn how to create Pivot Tables to improve your knowledge of Excel.
• Accountants
• CPAs
• CFOs
• Financial Consultants
• Controllers
• Banking
• Finance
• Insurance
• Education
• Telecom
• IT
• Marketing
• Sales
• Investments
• Pharmaceutical
• Medical Devices
• FDA
• Aviation
• Energy
• Retail
• Human Resource
• Logistics & Supply Chain
• Accounts
• Audit
Please reach us at 1-888-844-8963 for any further assistance or if you wish to register
100% MONEY BACK GUARANTEED
Refund / Cancellation policyGet In Touch
Similar Trainings
Shortcuts for Managing Excel Lists and Databases
LIVE : Scheduled on
22-April-2024 :01:00 PM EDT
|
Mastering Excel’s Top 10 Functions
LIVE : Scheduled on
25-April-2024 :01:00 PM EDT
|
Microsoft Excel - Essentials for the Absolute Beginner
LIVE : Scheduled on
29-April-2024 :01:00 PM EDT
|
Powerful Business Writing – Writing Skills for Email, Proposals, and More!
LIVE : Scheduled on
03-May-2024 :01:00 PM EDT
|