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
Macros - automation tasks in sheets
- Registration macros
- Understanding and modifying the code macros (VBA items)
- Connecting the interface macros or workbook
- Create forms on screen or printed
Requirements
Knowledge of Windows and the basics of using Microsoft Excel.
Testimonials (8)
Interesting exercises
Kacper - LKQ Polska Sp. z o. o.
Course - Excel Advanced
Duża ilość ciekawych przykładów i ćwiczeń, nauka poprzez praktykę, zainteresowanie grupy przez trenerkę, duża umiejętność przekazanie wiedzy
Kasia - The Boston Consulting Group sp. z o.o.
Course - Excel Advanced
Przydatne triki i formuły ułatwiające codzienne używanie excela, wyjaścione w prosty sposób przez trenerkę
Alicja - The Boston Consulting Group sp. z o.o.
Course - Excel Advanced
Trainer's knowledge and attitude
Ewa - The Boston Consulting Group sp. z o.o.
Course - Excel Advanced
Pace was enough to every attendand needs
Szymon - The Boston Consulting Group sp. z o.o.
Course - Excel Advanced
I like the clear explanations provided by Marwan. His clarifications are very intuitive, and follow a very logical sequence. Marwan's interaction with us was very positive and re-assuring.
Marwan Hefnawy - GroupEAD Europe S.L.
Course - Excel Advanced
The content was presented in a very progressive way, from easier topics to more complicated, in a really good pace allowing us to follow without any problem. The availability of the instructor to answer questions, repeat or reinforce topics was fantastic.
Oscar Centeno - GroupEAD Europe S.L.
Course - Excel Advanced
Practical exercises