company catalog schedule discounts register contact
Logo (415) 392-8024
sanfrancisco@academyx.com

SF Bay Area

Course Catalog

Class Schedule

Register:

Related Classes:

Excel 2007/2010 Intro

Excel 2007/2010 Intermediate

Excel 2007/2010 Advanced

Excel for Power-Users

Excel VBA

Nearby:

  • Berkeley
  • Oakland
  • Marin
  • Fremont
  • Sausalito
Price: $350 for one day (or two evenings)
Time: 9am - 4pm (or 6pm - 9pm)
Held at: 601 Montgomery St. #409
San Francisco, CA 94111 		checkmark Onsite training available
checkmark 1-on-1 training available
Call us for details

Excel 2007/2010 Advanced - San Francisco

With its powerful ability to perform complex calculations, generate charts and graphs from tables of data, and easily share information with others, Excel is the industry-standard spreadsheet application worldwide. AcademyX's Advanced Excel course in San Francisco will provide you with practical experience using Excel's most sophisticated features, whether you use Excel 2007 or Excel 2010. Our expert instructors will draw on extensive industry experience to help you develop an advanced level of expertise with this powerful program. After completing this Excel 2007/Excel 2010 training course, you will be able to:

  • Apply advanced functions, including logical, financial, statistical, and database functions
  • Use Data Tables to explore the effects of different input values on a formula
  • Find specific values or determine the cell address of a specific value with lookup functions
  • Find answers fast with Excel’s easy-to-use "what-if" tools, Goal Seek and Solver
  • Implement data validation to control which values are allowed in cells
  • Set up, use, and format PivotTables to analyze complex data sets
  • Present results to stakeholders graphically with PivotCharts, SmartArt graphics, and conditional data bars or icons
  • Use text files, XML files, Microsoft Queries, and Web Queries to import and export spreadsheet data
  • Set up Scenarios to compare options, for example, conservative vs. aggressive budget projections
  • and much more! See full outline for Advanced Excel course

Advanced Excel Class Reviews & Testimonials:


"[The teacher] was AWESOME! and very patient."
 - student, UCOP, San Francisco

"Class was great, learned a lot in a short time."
 - student, San Francisco PUC



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

Newsletter subscribers can win $100 credit!