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 Working Environment
- Keyboard shortcuts and available features
- Creating and modifying toolbars
- Configuring Excel Options (autosave, input settings, etc.)
- Paste Special options (including transpose)
- Formatting (styles, format painter)
- Using the Go To tool
Information Organization
- Sheet management (naming, copying, color coding)
- Assigning and managing names for cells and ranges
- Protecting worksheets and workbooks
- Securing and encrypting files
- Collaboration features, including tracking changes and comments
- Inspecting sheets
- Creating custom templates, charts, worksheets, and workbooks
Data Analysis
- Logical operations
- Basic functions
- Advanced functions
- Scenario analysis
- Search capabilities
- Solver
- Charts
- Graphic support (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 Pivot Charts
Integration with Other Applications
- Importing External Data (CSV, TXT)
- OLE (static objects and links)
- Web Queries
- Publishing sheets to websites (static and dynamic)
- Publishing PivotTables
Work Automation
- Conditional Formatting
- Creating custom formats
- Data validation
- Recording and editing macros
Visual Basic for Applications
- Developing custom functions
- Handling results in VBA
- VBA Forms
Requirements
Proficiency in using spreadsheets and familiarity with the Windows operating system.
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
