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

SF Bay Area

Register:

Related Classes:

Nearby:

Price: $350 for one day
Time: 9am - 4pm
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 Advanced - San Francisco

Many people in the job market today are familiar with Excel as a productivity tool, but very few can say with confidence that they know everything this application has to offer and how to use it.

Set yourself apart from the competition in just one day with our instructor-led Advanced Excel course, which will guide you through Microsoft Excel’s advanced features - automation tools like macros, analysis tools like the Analysis ToolPak, presentation tools like PivotCharts and Views, and much more.

In our advanced Excel course, will learn how 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 training in San Francisco. We also offer Excel 2007 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!