Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
コース概要
Adjustment of the working environment
- Hotkeys, facilities
- Create and modify toolbars
- Options excel (autosave, input, etc.).
- Options paste special (transpose)
- Formatting (style, format painter)
- Tool - go to
Organization of information
- Management sheets (naming, copying, color change)
- Assign and manage the names of cells and ranges
- Protect worksheet and workbook
- Secure and encrypt files
- Collaboration and track changes, comments
- Inspection sheet
- Create your own templates (charts, worksheets, workbooks)
Data analysis
- Logic
- Basic Features
- Advanced Features
- Creation of complex / multiple formulas
- Scenarios
- Search result
- Solver
- Charts
- Graphics support (shadows, charts, AutoShapes)
Database management (list)
- Data consolidation
- Grouping and outlining data
- Sorting data (over 4 columns)
- Advanced data filtering
- Database Functions
- Subtotal (partial)
- Tables and Pivot Charts
Cooperation with other applications
- Get External Data (CSV, TXT)
- OLE (static and link)
- Web Queries
- Publication sheets on site (static and dynamic)
- Publication PivotTables
Automation of work
- Conditional Formatting
- Create your own formats
- Check the validation
要求
Knowledge of Windows and the basics of using Microsoft Excel.
14 時間
お客様の声 (7)
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
コース - Microsoft Office Excel - poziom zaawansowany
Great pace
Kacper - Instytut Energetyki- Panstwowy Instytut Badawczy
コース - Microsoft Office Excel - poziom zaawansowany
presentation method
Nitu Nicolae - Pirelli
コース - Excel Advanced
the approach of the trainer
MARINELA - Pirelli
コース - Excel Advanced
Since I am not that advanced in Excel, it was sometimes hard to follow some examples.
- Samsung Electronics Austria GmbH
コース - Excel Advanced
The part when it was presented the Pivot table.
Olteanu - LEAR
コース - Excel Advanced
Multiple knowledge and the trainer's way of explaining.