|  Register|  Log In

Event Detail

Details
Name: Excel Expert Techniques
Date: 11/16/2017, 1 day(s)
Time: 9am-4pm
Place: San Francisco, 601 Montgomery
Price: Member - $316
Non-Member - $395


Your ability to analyze business data and develop effective solutions to complex problems is critical to your success professionally, and to the overall health of your organization. Microsoft Excel incorporates a powerful set of analytic tools which can be applied to the challenges faced by your business. But using Excel's most powerful features effectively requires a solid proficiency with the application's advanced features, as well as a level of mastery over a core set of data analysis techniques. Participating in VMA's Excel for Power Users training in San Francisco will distinguish you from your competitors—and your colleagues—in terms of your ability to use Excel to develop powerful data-driven solutions. Upon completing this training, you will be prepared to:


  • Derive meaningful, actionable results from advanced statistical, financial and information formulas.
  • Accomplish more faster with array formulas, which perform calculations on a series of values simultaneously.
  • Manipulate PivotTable data with greater precision using custom grouping and custom calculations.
  • Design user-customizable dashboards to powerfully present the most relevant data at a glance.
  • Build custom controls to engage and empower consumers of your spreadsheet data.
  • Master powerful techniques to build robust, flexible VBA macros.
  • Write system logic into macro code, to enable macros to respond intelligently to user behavior.
  • And many more topics! See full outline for Excel for Power-Users.


DateDurationMember(Non)Location 
12/151 day$316 ($395)601 MontgomeryRegister >
12/151 day$316 ($395)2350 Mission CollegeRegister >
12/291 day$316 ($395)2350 Mission CollegeRegister >
12/291 day$316 ($395)601 MontgomeryRegister >
Date Duration Member/
Non-Member
Location
11/16 1 day(s) $316/ $395 San Francisco, 601 Montgomery Register >
VMA Sponsors
VMA Partners