|
SF Bay Area
Register:
Related Classes:
Nearby:
- Berkeley
- Oakland
- Marin
- Fremont
- Sausalito
|
Price: $350 for one day
Time: 9am - 4pm
Held at: 601 Montgomery St. #409
San Francisco, CA 94111
|
Onsite training available
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.
|