|  Register|  Log In

Event Detail

Details
Name: Excel Expert Techniques
Date: 02/12/2019, 1 day(s)
Time: 9am-4pm
Place: Sacramento, 180 Promenade Circle
Price: Member - $237
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 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!


Sorry! There are no events scheduled for this week. Click here to see all upcoming events.
Date Duration Member/
Non-Member
Location
02/12 1 day(s) $237/ $395 Sacramento, 180 Promenade Circle Register >
VMA Sponsors
VMA Partners