Instructor Led Advanced Excel Training in United States
Advanced Excel Training Provider? - Tell us about your Training!
Please select the location nearest to you:
Kansas
Connecticut
Ohio
New York
Illinois
North Carolina
Maryland
From Maverick Enterprises
Dive Into Microsoft Excel Spreadsheets and Workbooks




Keeping track of sales figures, statistics or mortgage payments has never been easier, or more difficult. Microsoft Excel gives you the power to develop formulas using built-in functions, Use charts and graphs to predict trends and understand relationships, Consolidate data from several worksheets into one, Find and organize information by filtering, sorting, and grouping, Summarize and analyze
more...
From Technical Training Solutions
Excel - Forms Macros VBA





Course Summary:
Students will become familiar with what a macro is and how to create them. From there, students will use macros to automate routine Excel tasks. Students will learn to customize the Excel environment by altering the toolbars, menus and keyboard shortcuts to suit their needs. Students will get a thorough introduction to the VBA development environment that is based on Visual Basic.
more...
From INT Information Systems, Inc.
Advanced Microsoft Excel


...Advanced Excel devotes most of its attention to the construction of more powerful formulas. At the end of class, students will understand how formulas can be nested inside one another to create calculations that would be impossible using single formulas. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with actual
more...
From New York Interactive Media
Advanced Excel 2003 for Business
Class Type:
* Can retake the class, for free, up to 3 months.
* Free forum support for 1 year after class
* Hands on, goal based
* Small Classes of 4 to 9 people
* Fast computers
* Comfortable chairs, convenient location
* Patient, Fun, Experienced Trainer
When you are finished with this class you will be able to:
* Extract data from large databases
more...
From Learn Excel Class
Advanced Excel Class
Advanced Microsoft Excel Training covers advanced formulas and functions (Vlookup, If/ Then, Index/ Match, DSum, arrays, formula auditing techniques), what-if data-analysis techniques (pivot tables, scenarios, forecasting), database features (validations, extract unique values), advanced macros (with light VBA programming) and collaboration techniques.
Advanced Excel Training Objectives:
*
more...
From American Academy of Computer Training & Technology, Inc.
Microsoft Excel - Part III




Work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and database functions such as DSUM. Work with PivotTables and PivotCharts, import and export data, and query external databases. Learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
more...
From Knowledge Source Inc
Microsoft Excel 2007 Formulas Functions PivotTables for the Advanced Excel User
Take this course if you want to learn useful tools, tricks and tips for utilizing functions and formulas available in Microsoft Excel 2007. Learn which are best suited from over 300 available built-in functions. If you need to analyze large amounts of data quickly and easily, this class covers PivotTables - Excel's best resource for doing so.
more...
From Training-2-Go
Excel 2007 - Advanced
Advanced functions
Lookups and data tables
Advanced list management
PivotTables and PivotCharts
Exporting and importing
Analytical options
Macros and custom functions
Conditional formatting and SmartArt
more...
From New Horizons Charlotte
Spreadsheets
You will learn both basic and advanced Excel techniques including templates, charts, graphics and formulas. In these college courses you will learn all about how to work with Excel. You will learn how to apply this knowledge to business situation in order to summarize and analyze large amounts of data.
more...
From New Horizons Albany - Tech Valley
Spreadsheets
You will learn both basic and advanced Excel techniques including templates, charts, graphics and formulas. In these college courses you will learn all about how to work with Excel. You will learn how to apply this knowledge to business situation in order to summarize and analyze large amounts of data.
more...
