|  Register|  Log In

Event Detail

Name: Excel Intermediate
Date: 02/14/2018, 2 day(s)
Time: 6pm-9pm
Place: San Jose, 2350 Mission College
Price: Member - $200
Non-Member - $250

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to send the right amount of data to the right people at the right time can give your company a powerful competitive advantage.

In Excel Intro, you learned how to perform simple calculations and build spreadsheets from scratch. You learned how to make them easier to read, interpret, and present to colleagues. However, as more data becomes available and created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging. Workbooks become much larger and data can even spread across multiple workbooks.

VMA's Excel Intermediate class seeks to address this concern. Building on the foundations established in Excel Intro, Excel Intermediate will help you analyze massive amounts of data, extract actionable information, and present that information to managers and decision makers concisely. You will:

  • Link multiple workbooks to manage large, interconnected sets of data
  • Categorize rows and columns of data into outlines which can be easily collapsed and expanded
  • Organize data into a table for clear, organized, and accessible information
  • Make formulas more intelligible and flexible to growing data with named ranges
  • Sort, filter, select, move, transfer, and delete data efficiently
  • Restrict users from accidentally typing over formulas instead of entering data into data-entry cells
  • Utilize cell validation rules to force users to enter only specific text into cells, like email addresses, dates, or phone numbers
  • Analyze, interpret and present your data with Pivot Tables, Pivot Charts, and Views
  • And many more topics! See full outline for the Intermediate Excel class.

12/191 day$200 ($250)180 Promenade CircleRegister >
Date Duration Member/
02/14 2 day(s) $200/ $250 San Jose, 2350 Mission College Register >
VMA Sponsors
VMA Partners