company catalog schedule discounts register contact
Logo (916) 333-5710
sacramento@academyx.com

Sacramento Branch

Register:

Related Classes:

Nearby:

Price: $350 for one day
Time: 9am - 4pm
Held at: 180 Promenade Circle #110
Sacramento, CA 95834
checkmark Onsite training available
checkmark 1-on-1 training available
Call us for details

Excel 2007/2010 Advanced - Sacramento

Proficiency with Excel's most powerful features can enable you to accomplish otherwise lengthy data analysis tasks with speed and accuracy. Our Microsoft Excel classes have been designed to help you develop skill with both Excel 2007 and Excel 2010, so our Advanced Excel 2007/2010 training in Sacramento will help you develop skill with the advanced features of either version of Excel. In the course of this targeted Excel training, you will master advanced data analysis techniques as well as the newest tools for data presentation. This training will teach you how to:

  • Apply advanced Excel functions, for example, logical functions, which return a specific result based on whether conditions you specify are met
  • Use VLOOKUP, HLOOKUP, MATCH, and INDEX functions to search for specific values in a list
  • Manage your spreadsheet data like a database with data validation for entering data and database functions for querying data
  • Understand when and how to use PivotTables to analyze data efficiently
  • Import and export data via text files and XML format
  • Perform reliable data analysis with Excel's built-in data analysis tools, including Goal Seek and Solver, as well as the Analysis ToolPak and the Scenario Manager
  • Automate your work with conditional formatting and macros
  • Add pizzazz to your spreadsheets with communicative visuals like PivotCharts, automatic data bars, and SmartArt graphics
  • and many more topics... See full outline for Excel 2007/2010 training - Advanced

Advanced Excel Class Reviews:


"Good Job. Thorough and interesting. I felt like he really knows the content we covered in class. Very knowledgeable and helpful. Made himself accessible via email and stayed after class to help us out with questions we had."
- student, Advanced Excel Sacramento

"It was perfect for my needs"
- student, Oracle, Rocklin

"The instructor did a great job making what could be a boring class a lot of fun. I learned a lot of new features of Excel and now have to go home and practice. A very worthwhile class for those who want a high-level overview only."
- student, Advanced Excel



* Note: This class description is for Excel 2007/2010 training in Sacramento (advanced). We also offer Excel 2007/2010 training in San Jose, San Francisco, and Excel training in Los Angeles. Go to advanced 2003 Excel training Sacramento.

Newsletter subscribers can win $100 credit!