Course Outline
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
Requirements
Knowledge of Windows and the basics of using Microsoft Excel.
Testimonials (7)
Since I am not that advanced in Excel, it was sometimes hard to follow some examples.
- Samsung Electronics Austria GmbH
Course - Excel Advanced
The part when it was presented the Pivot table.
Olteanu - LEAR
Course - Excel Advanced
Multiple knowledge and the trainer's way of explaining.
Bianca - LEAR
Course - Excel Advanced
The manner in which the information was taught, and the fact that the teacher made sure the students were engaged throughout.
Miroiu - LEAR
Course - Excel Advanced
The explanation
Radu - LEAR
Course - Excel Advanced
Interesting exercises
Kacper - LKQ Polska Sp. z o. o.
Course - Excel Advanced
Trainer's knowledge and attitude