Accelerate Data Base Analysis with Excel's Pivot Tables
Instructor:
Miles Hutchinson
Product ID: 706047
Training Level: Basic to Intermediate
- Duration: 90 Min
Why Should You Attend:
So, you found the data you need for your analysis. Now what? How do you sort and sift it to mine key intel and make the right decision? Microsoft Excel holds the key. Pivot Tables are designed to help you quickly summarize mountains of data, identify key trends, organize it into meaningful reports and filter the reports for specific users and needs, it also helps you with blazing fast drill downs on key events, activities and transactions.
Stop staring at that database. Dive in and explore it with Pivot Tables. Identify the key trends in your data and be confident you have reached the right conclusions to support your recommendations. In this course you’ll learn how to get your data to tell you the whole story.
Seasoned financial analyst, Miles Hutchinson, in this power-packed training will provide you the practical knowhow to Accelerate Data Base Analysis with Excel’s Pivot Tables.
Areas Covered in the Webinar:
- Wrangle your database and prepare it for Pivoting
- Setting up your Pivot Table from your data base
- Navigating the Pivot Table Options Menu
- Filtering and sorting your Pivot Table
- Formatting Your Pivot Table
- Reporting Options, including the Slicer Tool
- Drilling down on your Pivot Table
- Charting your Pivot Table Results
Who Will Benefit:
- CFOs
- Controllers
- Compliance Managers
- Compliance Officers
- Accounting Managers
- Information Reporting Officers
- Tax Managers
- Bank Managers
- Risk Managers
- Human Resource Managers
- Internal Auditors
Miles Hutchinson
President, Sales Tax Advisors Inc
Miles Hutchinson is a CGMA and experienced businessman. He has been an auditor with PriceWaterhouseCoopers and the chief financial officer of a $1 billion real estate development company. Mr. Hutchinson is a professional speaker and consultant who has presented over 2,000 seminars and training sessions on myriad business and financial topics, like financial analysis and modeling, accounting, strategic planning, and compliance with the Sarbanes-Oxley Act. He is recognized as an expert in payroll, and sales and use tax as well as financial modeling and analysis, business strategy and communications.
He is the author of several useful accounting and tax tools. His clients include Abbott Labs, Bank of America, Boston Scientific, Citicorp, Corning, the FBI, the FDA, the Federal Reserve, GE, Pfizer, Siemens, US Marine Corps, and the US Army.
More Training By Experts
- TIN Matching to Reduce Your B-Notices and Eliminate Proposed Penalties
- Sales and Use Tax Issues with Internet Sales
- Forecasting with Excel's Powerful Sensitivity Tools - Scroll Bars, Goal Seek, Data Tables, Solver and Scenario Manager
- 1099 & W-9 Update - Complying with IRS Information Reporting Guidelines
- FATCA - The Foreign Accounts Tax Compliance Act
Refund Policy
Our refund policy is governed by individual products and services refund policy mentioned against each of offerings. However in absence of specific refund policy of an offering below refund policy will be effective.
Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange. Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time. On-Demand Recording purchases will not be refunded as it is available for immediate streaming. However if you are not able to view the webinar or you have any concern about the content of the webinar please contact us at below email or by call mentioning your feedback for resolution of the matter. We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email [email protected] call +1-888-717-2436 (Toll Free).
