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 Working Environment
- Keyboard shortcuts and accessibility features
- Creating and customizing toolbars
- Configuring Excel Options (including auto-recovery and input settings)
- Paste Special options (such as transposing)
- Formatting techniques (styles and Format Painter)
- Using the 'Go To' feature
Organizing Information
- Sheet management (naming, copying, and changing colors)
- Defining and managing names for cells and ranges
- Protecting worksheets and workbooks
- Securing and encrypting files
- Collaboration features: tracking changes and adding comments
- Using the Document Inspector
- Creating custom templates, charts, worksheets, and workbooks
Data Analysis
- Logical functions
- Essential functions
- Advanced functions
- Scenario Manager
- Lookup functions
- Solver add-in
- Charting
- Visual enhancements (shadows, chart styles, and AutoShapes)
Database Management (Lists)
- Data consolidation
- Grouping and outlining data
- Sorting data across multiple columns
- Advanced filtering techniques
- Database-specific functions
- Subtotals
- PivotTables and PivotCharts
Integration with Other Applications
- Importing external data (CSV, TXT)
- OLE (Object Linking and Embedding) – static and linked objects
- 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)
- Developing custom functions
- Implementing results via VBA
- Creating VBA UserForms
Requirements
Proficiency in working with spreadsheets 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
