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
Optimizing the Working Environment
- Master keyboard shortcuts and utilities
- Create and customize toolbars
- Configure Excel Options (autosave, input settings, etc.)
- Utilize Paste Special options (including transpose)
- Apply formatting techniques (styles, format painter)
- Use the Go To feature for navigation
Structuring Information
- Manage sheets (naming, copying, color-coding)
- Assign and manage cell and range names
- Implement protection for worksheets and workbooks
- Secure and encrypt files
- Facilitate collaboration via change tracking and comments
- Conduct sheet inspections
- Develop personalized templates, charts, worksheets, and workbooks
Data Analysis
- Apply logical reasoning
- Utilize basic functions
- Implement advanced functions
- Run scenarios
- Execute conditional searches
- Use the Solver tool
- Create charts
- Enhance visuals with graphics support (shadows, charts, AutoShapes)
Database Management (Lists)
- Consolidate data
- Group and outline data structures
- Sort data across multiple columns
- Apply advanced data filters
- Use database-specific functions
- Generate subtotals
- Build tables and Pivot Charts
Integration with Other Applications
- Import external data (CSV, TXT)
- Implement OLE (static and linked objects)
- Execute Web Queries
- Publish sheets to the web (static and dynamic)
- Publish PivotTables
Workflow Automation
- Apply Conditional Formatting
- Create custom formats
- Verify data accuracy
- Record and edit macros
Visual Basic for Applications
- Develop custom functions
- Manage return values in VBA
- Design VBA Forms
Requirements
Proficiency in spreadsheet operations and familiarity with the Windows operating system.
21 Hours
Testimonials (5)
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Visual Basic for Applications (VBA) w Excel - wstęp do programowania
Well structured. Good teaching techniques. Course well documented!
Sorin
Course - VBA For Access & Excel
What I liked most about the training was the trainer’s knowledge of Excel. I appreciated learning useful things like shortcuts and formulas that I can use every day.
Martin
Course - Visual Basic for Applications (VBA) for Analysts
Very practical
