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
Configuring the working environment
- Keyboard shortcuts and usability enhancements
- Creating and modifying toolbars
- Excel Options (autosave, input settings, etc.)
- Paste Special options (including transpose)
- Formatting (styles, format painter)
- Navigating with the Go To tool
Structuring information
- Managing sheets (naming, copying, changing colors)
- Defining and managing named cells and ranges
- Protecting worksheets and workbooks
- Securing and encrypting files
- Collaboration features: tracking changes and managing comments
- Inspecting sheets
- Creating custom templates, charts, worksheets, and workbooks
Data analysis
- Logical operations
- Basic functions
- Advanced functions
- Scenarios
- Search techniques
- Solver
- Charts
- Graphics support (shadows, charts, AutoShapes)
Database management (lists)
- Data consolidation
- Grouping and outlining data
- Sorting data (across more than 4 columns)
- Advanced data filtering
- Database Functions
- Subtotals (partial sums)
- Tables and Pivot Charts
Interoperability with other applications
- Importing External Data (CSV, TXT)
- OLE (static links and live links)
- Web Queries
- Web publication of sheets (static and dynamic)
- Web publication of PivotTables
Work automation
- Conditional Formatting
- Creating custom formats
- Validating data correctness
- Recording and editing macros
Visual Basic for Applications
- Developing custom functions
- Managing results in VBA
- VBA Forms
Requirements
Proficiency in using spreadsheets and a working knowledge of the Windows operating system.
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 3900 € + 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
