Continuing where the 2007/2010 Excel Intermediate course leaves off, the Advanced 2007/2010 Excel training course will provide you with experience using Excel's powerful data analysis and presentation tools, advanced functions, conditional cell formatting, and macros to automate your work. Our Microsoft Excel classes have been crafted to help you develop skill with both Excel 2007 and Excel 2010, so that you will leave prepared to use the advanced features of either version of Excel. In this in-depth, hands-on Excel course you will learn to:

Employ Excel's advanced functions, such as logical (IF, AND, NOT, and more), math, statistical, and financial functions
Mine your data for information with Lookup and Data Tables
Reduce errors with data validation tools
Efficiently analyze and present large amounts of data using PivotTables and PivotCharts
Connect your data in Excel with other programs or the web by importing and exporting data
Cut short the time you need to do "what-if" analyses and get answers quickly with Excel's Goal Seek, Solver, Analysis ToolPak, and Scenario tools
Save time, reduce errors, (and impress your boss) by creating Excel macros to automate your routine tasks
Let your data speak visually by adding automated, conditional cell coloring, data bars, SmartArt graphics, and more
and many more topics... See full outline for Advanced 2007/2010 Excel course

Excel Course Reviews:

"I found it to be very informative and useful. The combination of the workbook, live screen that the instructor was using and step by step instructions as we practiced using the techniques Excel was great. Jerry was an excellent instructor and was extremely helpful and knowledgeable."
- student, Advanced Excel course

"The training was great! I want to come back for more Excel training and Adobe training."
- Natane Rogers-Engle, Stacy and Witbeck, Inc.

"Very helpful! Fantastic instructor and very clear instructions."
- Henry, Advanced Excel

"Well prepared, good overall coverage of commonly used and valuable excel functions."
- Amelia, Advanced Excel course

* Note: This class description is for advanced Excel 2007/2010 courses in Los Angeles. We also offer Excel course in San Jose, Sacramento, and Excel course in San Francisco. Interested in Excel 2007/2010? See our Excel 2003 course in Los Angeles.

Newsletter subscribers can win $100 credit!