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.
Duration 21 hours
Course Outline
Customizing the Workspace
- Keyboard shortcuts and key features
- Creating and modifying toolbars
- Excel Options (autosave, input settings, etc.)
- Paste Special options (including transpose)
- Formatting techniques (styles, Format Painter)
- Navigation using the Go To tool
Information Organization
- Managing sheets (naming, copying, changing colors)
- Assigning and managing names for cells and ranges
- Protecting worksheets and workbooks
- Securing and encrypting files
- Collaboration features, including tracking changes and comments
- Sheet inspection tools
- Creating custom templates, charts, worksheets, and workbooks
Data Analysis
- Logical operations
- Essential functions
- Advanced functions
- Scenario analysis
- Search and lookup techniques
- Solver tools
- Chart creation
- Graphic enhancements (shadows, charts, AutoShapes)
Database Management (Lists)
- Data consolidation
- Grouping and outlining data
- Sorting data across multiple columns
- Advanced data filtering
- Database functions
- Subtotals
- Tables and PivotCharts
Integration with Other Applications
- Importing external data (CSV, TXT)
- OLE integration (static and linked)
- Web queries
- Publishing sheets to sites (static and dynamic)
- Publishing PivotTables
Work Automation
- Conditional formatting
- Creating custom formats
- Data validation and correctness checks
- Recording and editing macros
Visual Basic for Applications (VBA)
- Developing custom functions
- Handling results in VBA
- Designing VBA forms
Requirements
Familiarity with spreadsheet operations and basic Windows knowledge are required.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
the trainer's patience,
Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany
well-prepared training, interesting topics
