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 utilities
- Creating and modifying toolbars
- Configuring Excel Options (auto-save, input settings, etc.)
- Using Paste Special options (including transpose)
- Formatting techniques (styles, Format Painter)
- Navigation tools and 'Go To' features
Organizing Information
- Managing worksheets (naming, copying, changing tab colors)
- Defining and managing named cells and ranges
- Protecting worksheets and workbooks
- Securing and encrypting files
- Facilitating collaboration, tracking changes, and adding comments
- Inspecting worksheets for errors or inconsistencies
- Creating custom templates, charts, worksheets, and workbooks
Data Analysis
- Logical functions
- Essential functions
- Advanced functions
- Scenario Manager
- Lookup functions
- Solver add-in
- Charting techniques
- Graphic elements (shadows, charts, AutoShapes)
Database Management (Lists)
- Data consolidation
- Grouping and outlining data
- Sorting data across more than four columns
- Advanced filtering techniques
- Database-specific functions
- Using Subtotals
- Working with Tables and PivotCharts
Integration with Other Applications
- Importing external data (CSV, TXT files)
- OLE integration (static embedding and linking)
- Web queries
- Publishing worksheets online (static and dynamic web pages)
- Publishing PivotTables
Workflow Automation
- Applying Conditional Formatting
- Creating custom number formats
- Implementing data validation checks
- Recording and editing macros
Visual Basic for Applications (VBA)
- Developing custom functions
- Understanding VBA results and outputs
- Designing VBA user forms
Requirements
Proficiency in using spreadsheets and familiarity with the Windows operating system.
21 Hours
Testimonials (4)
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
