Pharmiweb ChannelsAll | PharmaCo | Clinical Research | R&D/BioTech | Sales/Mktg | Healthcare | Recruitment | Pharmacy | Medical Comms

Pharmiweb.com RSS Feed Pharmiweb.com RSS Feeds

Advertising

Event Details

Filter
WorldConference

Microsoft Excel: Detailed Data Analysis with Pivot Tables


Add this event to your calendar: iCal   Google Calendar

Details

OVERVIEW

Microsoft Excel Pivot Tables are one of the most powerful and easy-to-use features in Excel, but most people are intimidated by them. These tables allow users to take a large set of data – rows of data about things like customers, products, sales, locations, employees, anything at all – and build reports to make real business decisions. But how exactly do you make a powerful Pivot Table?

In this session, we’ll review everything from the fundamentals of using Pivot Tables to techniques that allow them to be used for dashboards and other visualizations. Neil will help you analyze and visualize essentially any kind of data in Microsoft Excel. He will share how Pivot Tables can immediately give you an insight into any part of your business. With just a couple of clicks, you can build a report and charts around your employees, your sales, your tasks – anything that’s relevant to you.

WHY SHOULD YOU ATTEND

Unlike many webinars, Neil’s sessions are 100% hands-on real-world examples of the skills he’s presenting. After this session, you’ll have a screenshot-laden step-by-step guide to performing the techniques we cover. You’ll be able to apply these skills directly to your work with almost no adjustment, and with a very short learning curve.

AREAS COVERED

  • Data Layout Best Practices
  • Formatting Data as a Table
  • How to create Pivot Table in Excel 
  • Calculating sums, averages, counts, and more
  • Filtering by date, region, or other relevant factors
  • Creating charts to illustrate your insights
  • Drill into your data for detailed analysis
  • Format and create a presentation
  • Linking multiple tables through relationships

LEARNING OBJECTIVES

In business, the data we base our decisions on is kept in databases and spreadsheets in list form. The list by itself is essential, but useless without summaries, reports, and visualizations. A Pivot Table is an incredibly dynamic and easy-to-use tool for this kind of reporting and data visualization. It is a must-use tool in Excel for any job role.

WHO WILL BENEFIT

  • Business owners
  • Executives
  • Managers
  • Business analysts
  • Financial professionals
  • Support representatives
  • Information workers of all kinds

For more detail please click on this below link:

http://bit.ly/2K0Z9tR

Email: support@trainingdoyens.com

Toll Free: +1-888-300-8494

Tel: +1-720-996-1616

Fax: +1-888-909-1882

 

Prices

Live Session for one participant $159 Corporate Live Session Group – Max 10 Participants from one location. $449 Recorded Session Get unlimited access to the link for six months. $199 Training DVD or USB Flash Drive MP3 files, PDF presentation and reference manual will be delivered on a CD $379 Super Combo Offer 1 Live and Recorded webinar $289 Super Combo Offer 2 Live and Training CD $429

Contact

Training Doyens
support@trainingdoyens.com

Advertising
Site Map | Privacy & Security | Cookies | Terms and Conditions

PharmiWeb.com is Europe's leading industry-sponsored portal for the Pharmaceutical sector, providing the latest jobs, news, features and events listings.
The information provided on PharmiWeb.com is designed to support, not replace, the relationship that exists between a patient/site visitor and his/her physician.