Excel training in San Jose

Microsoft Excel offers an array of capabilities which accelerate the process of organizing, managing, analyzing and presenting data. Building on the concepts learned in Excel Intermediate, AcademyX's Advanced Excel course in San Jose have been crafted to help you develop an advanced level of proficiency with both Excel 2007 and Excel 2010. Our instructors will guide you through hands-on exercises which will help you develop proficiency with the following tasks.

Find "what-if" answers using one-variable or two-variable data tables and other handy analysis tools like Goal Seek and Solver
Reduce data input errors by setting up data validation rules
Perform advanced calculations with math and statistical functions to conditionally summarize, count, average, or round data
Summarize data with database functions, according to criteria you specify
Analyze, interpret, and present your data with PivotTables, PivotCharts, and Views
Incorporate data from external databases or from the Web, for example, stock prices or currency rates
Run specific analysis tools from Excel's Analysis ToolPak, such as Correlation, Fourier Analysis, Anova, Sampling, and many more
Explore, save, and merge different projection or planning scenarios using the Scenario Manager
Record macros so that you can run a series of Excel tasks at the push of a button
Add the power of color to your spreadsheets with automatic cell formatting and easy-to-read data bars
and much more! See full outline for Advanced Excel course

Excel Course Reviews & Testimonials:

"The Advanced Excel training was excellent. Very insightful, approachable and exactly as advertised. Will definitely recommend."
- Clarence Simmons (San Jose, CA)

"Very informative, highly recommended."
- Jerren (Palo Alto, CA)

"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."
- Ellice (Sunnyvale, CA)

Excel 2007/2010 Advanced - San Jose