Excel Power Analyst Bootcamp Omaha

Omaha, Nebraska
Tuesday, May 22, 2012


 

Day 1 Day 2
7:30 - 8:00 7:30 - 8:00
Breakfast served on location Breakfast served on location
8:00 - 12:00 8:00 - 12:00
Powerful Analysis Techniques
Mike Alexander
Advanced Reporting Techniques
Mike Alexander
▪ Power Formulas ▪ Building Better Table-Based Reports
▪ Data Management Tricks and Tips ▪ Excel Data Visualization Techniques
▪ Speadsheet Auditing tricks ▪ Data Modeling Best Practices
▪ Advanced PivotTable Customizations ▪ Creating Interactive Reports
▪ Powerful PivotTable Tips and Tricks  
▪ Leveraging Pivot Charts  
▪ Adding Calculations in Pivot Tables  
12:00 - 1:00 12:00 - 1:00
Lunch Buffet served on location  Lunch Buffet served on location 
1:00 – 5:00 1:00 – 5:00
Integrating with External Data
Dick Kusleika
Enhance Reporting with VBA
Dick Kusleika
▪ Integrating Excel and Access ▪ Using Excel Macros to learn VBA
▪ Connecting to SQL Server Data ▪ VBA & The Office Object Model
▪ Introduction to PowerPivot ▪ Common Excel VBA Actions
▪ Integrating Excel and SharePoint ▪ Creating Automated Reporting
▪ Advanced MS Query Techniques  
5:00 – 6:30 5:00 – 6:30
Free Form Q&A Free Form Q&A
▪ Catch up on Class Projects ▪ Catch up on Class Projects
▪ Get Help on Specific Projects ▪ Get Help on Specific Projects
▪ General Q & A ▪ General Q & A
 

Contact Information

  • Phone: 214-578-2141
    Email: mha105@yahoo.com

Payment Instructions

  • Register with Credit Card
    Click the Register Now button above

    Invoice or PO
    If your organization requires an invoice or purchase order,
    contact us
    . 
    Be sure to include your contact information.

    Register with Check
    To Register with Check or Money Order, make payable to DataPig Technologies.

    Mail to:
    DataPig Technologies
    7548 Preston Rd #141-136
    Frisco, TX  75034

    *Be sure to include your email address so that we may contact you with registration information

© 2019
Quick, easy and affordable online event registration and event management software for all event sizes.