Mastering Big Data with PowerPivot, the Free Excel Add-In
Duration: 60 minutes
Speaker: Melissa Esquibel
Bonus for Each Registrant:The webinar speaker will answer one written question that you may submit by email within one week after the webinar.
Webinar Description
Have you seen PowerPivot on your tabs in Excel or on the list of potential Excel add-ins and wondered what it is and what it does? Maybe you’ve been told that the answer to your seemingly impossible pivot table challenge is the free Excel add-in PowerPivot, but don’t know exactly how to make it happen. If you use Pivot Tables you will want to learn how to use PowerPivot. In this 60-minute interactive webinar, you’ll be introduced to the fundamentals of PowerPivot and how to put it to work analyzing your business data in ways you never thought possible.
PowerPivot solves two very real limitations in working with big data in Excel.
-
The 1,048,576 row limit in worksheets
-
The limited capability to analyze multiple related datasets
PowerPivot solves both these issues. If you have Office 2010 or 2013, you will want to put PowerPivot to work for you, and you can do it in minutes.
Agenda
Lorem ispusm delore desuite canalores estes equi markus decaisius canna quid In this introductory session you will learn:
-
How to activate PowerPivot in Excel
-
How to create a query from two related sets of data
-
Differences between regular Pivot Tables and PowerPivot Tables
-
What DAX expressions are and why you should know what they are and how to use them
This session is relevant to users of Excel 2010 and 2013 and those considering upgrading from earlier versions. A fundamental knowledge of Pivot Tables is suggested to get the most out of this program.
CONTINUING EDUCATION
Continuing HRCI Credit Information
This program has been pre-approved for 1.5 hours of General recertification credit hours through the HR Certification Institute. Use of the seal is not an endorsement by the HR Certification Institute of the quality of the program. It means that this program has met the HR Certification Institute's criteria to be pre-approved for recertification credit.
Continuing Legal Education Credit Information
This webinar has been approved in the following states for continuing legal education credit by The Marino Legal Academy:
California: 1.5 credit hours
The Marino Institute for Continuing Legal Education is a State Bar of California approved MCLE sponsor and this course qualifies for 1.5 credit hours of participatory CLE credit.
New Jersey: 1.5 credit hours
This webinar has been approved by the Board on Continuing Legal Education of the Supreme Court of New Jersey for 1.5 CLE credit hours.
New York: 1.5 areas of professional practice credit hours
This course has been approved in accordance with the requirements of the New York Continuing Legal Education Board for veteran attorneys for 1.5 credit hours, of which 1.50 credit hours may be applied toward the Areas of Professional Practice.
Pennsylvania: 1.5 credit hours
This Distance Learning program has been approved by the Pennsylvania Continuing Legal Education Board for 1.5 hours of substantive law, practice and procedure CLE credit.
To receive CLE credit for this webinar in those states, please request such credit by writing toinfo@parkavenuepresentations.com. Your request will be forwarded to The Marino Legal Academy for processing.
CLE credit for this webinar may also be awarded in a number of other jurisdictions. For more information, please contact a Marino Legal Academy legal education consultant at (212) 249-3779,x104.
Logistics
- 90 minutes (Travel Free) delivered over the Internet.
Unlimited listeners per connection - bring the entire department.
Q&A session with the expert.
Special Feature: If you register for this webinar and cannot attend, you will be able to access a one-time instant replay without charge for up to 90 days after the date of the webinar.
This event will be presented live with a PowerPoint presentation to be viewed on your computer. You may listen to the audio of the webinar by telephone or through your computer. The PowerPoint slides will be provided shortly before the event. Once you register, you will receive an email which is your receipt and which includes your instructions for dialing in and logging on. You will also receive an email reminder 24 hours before the webinar.