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

Sacramento Branch

Register:

Related Classes:

Serving:

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 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 Advanced Excel course in Sacramento 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 our advanced Excel course

Excel Advanced Course Reviews:




Rated 4.8/5 based on 242 student reviews.

"Wonderful, I continually highly recommend these courses."
- , Retail Pro International


"The instructor was very knowledgable and explained things clearly, even things that are somewhat confusing to ariculate. The instructor did well to go beyond the scope of the book and provided valuable extra shortcuts and insights."
- , Belami, Inc.


"Enlightening. Loads of information that I can take back to the office."
- , Caltrans


"It was very thorough while still being efficient. The instructor provided useful information while avoiding the less used tools."
- , Belami, Inc.



* Note: This class description is for advanced Excel courses in Sacramento. We also offer this Excel course in San Jose, San Francisco, Los Angeles, and San Diego.

Newsletter subscribers can win $100 credit! Social Media icons Twitter Facebook LinkedIn Google+ Youtube Image Map