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.
Course Outline
Customizing the Workspace
- Keyboard shortcuts and efficiency tips
- Creating and modifying toolbars
- Configuring Excel Options (auto-recovery, input settings, etc.)
- Paste Special options (including transpose)
- Formatting techniques (styles, Format Painter)
- Navigating using the 'Go To' tool
Organizing Information
- Managing worksheets (renaming, duplicating, customizing colors)
- Defining and managing cell and range names
- Protecting worksheets and workbooks
- Securing and encrypting files
- Facilitating collaboration through tracked changes and comments
- Inspecting documents
- Creating custom templates, charts, worksheets, and workbooks
Data Analysis
- Logical functions
- Essential functions
- Advanced functions
- Scenario analysis
- Lookup functions
- Solver tool
- Chart creation
- Visual elements support (shadows, charts, AutoShapes)
Database Management (Lists)
- Data consolidation
- Grouping and outlining data
- Sorting data across more than four columns
- Advanced data filtering
- Database-specific functions
- Subtotals
- Tables and PivotCharts
Integration with Other Applications
- Importing external data (CSV, TXT)
- OLE (static objects and links)
- Web Queries
- Publishing worksheets to websites (static and dynamic)
- Publishing PivotTables
Work Automation
- Conditional Formatting
- Creating custom number formats
- Data validation
- Recording and editing macros
Visual Basic for Applications (VBA)
- Creating custom functions
- Understanding VBA results and outputs
- Developing VBA UserForms
Requirements
Proficiency in working with spreadsheets and a foundational knowledge of the Windows operating system.
21 Hours
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
