Learn how to analyze your data further using Excel® add-ins.
In today’s busy world, we are overwhelmed with tons of data. More and more, our employers are asking for many different ways to interpret that data. The normal Excel® spreadsheet has many tools that can be very useful to help with your data needs. But they can only go so far. When you learn how to install and use some readily available Excel® add-ins, you will be able to do more analysis with your data including exciting new charts, statistical analysis, maps, and much more.
Learning Objectives
- You will be able to describe how to install and use Excel® add-ins.
- You will be able to identify data to be used with Power Map.
- You will be able to recognize when Excel® add-ins may help you analyze your data.
- You will be able to review your data in many new ways using the Excel® add-ins.
Agenda
Add-Ins on the Insert Menu
- How to Use Geographic Data to Create a Bing® Map
- How to Use Data to Create People Charts
- Other Add-Ins That Are Available
Excel® Add-Ins
- How to Use the Solver
- How to Use the Data Analysis Tools
Common Add-Ins
- Power Pivot
- Power Maps
Speakers
Tom Fragale,
The PC Guy, Inc.- Computer professional with over 30 years of professional experience
- Microsoft® Certified Trainer, Microsoft® Certified Office Master, Microsoft® Certified Expert in Word® and Excel®, and a Microsoft® Certified Specialist in Access®, Outlook®, and PowerPoint®
- Trained over 30,000 business people in online webinars, public seminars, and onsite training
- Clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, and retail
- 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
- A published author, having written a book on Microsoft® Access®
- B.A. degree in computer science, LaSalle University
Who Should Attend
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers, and accountants.