|  Register|  Log In

Event Detail

Details
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.


DateDurationMember(Non)Location 
4/241 day$200 ($250)601 MontgomeryRegister >
4/241 day$200 ($250)2350 Mission CollegeRegister >
4/252 evenings$200 ($250)601 MontgomeryRegister >
4/252 evenings$200 ($250)2350 Mission CollegeRegister >
5/11 day$200 ($250)601 MontgomeryRegister >
5/31 day$200 ($250)180 Prominade CircleRegister >
5/81 day$200 ($250)601 MontgomeryRegister >
5/81 day$200 ($250)2350 Mission CollegeRegister >
5/92 evenings$200 ($250)2350 Mission CollegeRegister >
5/92 evenings$200 ($250)601 MontgomeryRegister >
5/171 day$200 ($250)601 MontgomeryRegister >
5/221 day$200 ($250)601 MontgomeryRegister >
5/221 day$200 ($250)180 Prominade CircleRegister >
5/221 day$200 ($250)2350 Mission CollegeRegister >
5/232 evenings$200 ($250)2350 Mission CollegeRegister >
5/232 evenings$200 ($250)601 MontgomeryRegister >
5/301 day$200 ($250)601 MontgomeryRegister >
6/51 day$200 ($250)601 MontgomeryRegister >
6/51 day$200 ($250)2350 Mission CollegeRegister >
6/62 evenings$200 ($250)2350 Mission CollegeRegister >
6/62 evenings$200 ($250)601 MontgomeryRegister >
6/131 day$200 ($250)180 Prominade CircleRegister >
6/141 day$200 ($250)601 MontgomeryRegister >
6/191 day$200 ($250)601 MontgomeryRegister >
6/191 day$200 ($250)2350 Mission CollegeRegister >
6/202 evenings$200 ($250)601 MontgomeryRegister >
6/202 evenings$200 ($250)2350 Mission CollegeRegister >
6/261 day$200 ($250)601 MontgomeryRegister >
Date Duration Member/
Non-Member
Location
02/14 2 day(s) $200/ $250 San Jose, 2350 Mission College Register >
VMA Sponsors
VMA Partners