| |
|
| |
Microsoft Excel 2007 Advanced Training Class
Course ID: 21477
|
|
| |
|
|
| |
|
|
| |
Microsoft Excel 2007 Advanced Training Seminar
Geared for those that are already comfortable writing different types of formulas, formatting spreadsheets and text and working across multiple worksheets.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Access a list of all Excel functions, Text functions (IF Conditional, Nesting IF statements, Concatenate Functions, IF Concatenate text functions, IS functions), arrays, label formulas, Add ins, look up values, transposing data, PivotTables, PivotTable charts, multiple series charts, adding pictures to charts, moving average charts, validations, custom views, adding custom views to the toolbar, grouping columns, AutoFilters, custom lists, embedding, linking, linking as icon, locking cells, protecting worksheets and workbooks. |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
understanding of Excel fundamentals including formatting, navigation, basic formulas, Autosum and other basic functions, basic charts.
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Microsoft Excel 2007 Advanced Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 21477
| Course Duration: 4 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|