Microsoft Excel Advanced
Training Objectives
This Seminar will qualify the participants to use Excel professionally and as an effective tool. Participants will become familiar with the advanced math functions and statistical functions. Exercises will be used for large worksheets and how to evaluate them effectively. Learning professionally the association with graphic and charts and exchanging them with other Office applications.
Course Prerequisites
Basic Knowledge in Excel
Course Description
- Advanced References
- Mixed References with relative and absolute
- Using Name ranges
- Links to other spreadsheets and files
- Conditional Formatting for the cells
- Conditional Formatting with Formulas
- Calculating and using Excel Functions
- Calculating with Date and Time functions
- Text functions: RIGHT, SUBSTITUTE, LENGTH, TRIM
- Logical and Statistical functions: IF, VLOOKUP, SUMIF, COUNTIF
- Working with large worksheets
- Export/Importing lists (WORD/SAP/ACCESS)
- Text in Column, Transform Text into Numbers
- Usage of Text functions
- Using Filters and Subtotals
- Usage of Excel application window (VERSION 2007)
- Inserting Pivot tables
- Formatting Pivot tables
- Formulas within Pivot tables
- Grouping and Outlining worksheets
- Report Manager
Upcoming Classes and Price
Duration
2 days
Price per Student
378,00 € plus VAT
(Price incl. 19% VAT.: 449,82 €)
Dates
23. - 24.05.2012
28. - 29.06.2012
26. - 27.07.2012
30. - 31.08.2012
On site training
For your customized - on site training we tailor the course to your needs by adapting the schedule, meeting place and applications to fit with your particular agenda. For fast problem solving you can also schedule individual time with one of our instructors (training on the job).
You could not find the class you need? Please contact us directly. We are happy to further assist you.
Keywords for this seminar
Excel, Microsoft, Office, Office 2007, spreadsheet