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 accessibility features
- Creating and customizing toolbars
- Configuring Excel Options (auto-save, input settings, etc.)
- Paste Special options (e.g., transpose)
- Formatting techniques (styles, format painter)
- Navigating with the 'Go To' tool
Organizing Information
- Managing worksheets (naming, copying, recoloring)
- Assigning and managing names for cells and ranges
- Protecting worksheets and workbooks
- Securing and encrypting files
- Collaboration features: tracking changes and adding comments
- Inspecting worksheets for errors or issues
- Creating custom templates, charts, worksheets, and workbooks
Data Analysis
- Logical functions
- Basic functions
- Advanced functions
- Scenario Manager
- Lookup and reference functions
- Solver add-in
- Creating charts
- Graphical elements (shadows, chart styles, AutoShapes)
Database Management (Lists)
- Data consolidation
- Grouping and outlining data
- Sorting data across multiple columns
- Advanced filtering
- Database functions
- Subtotals
- Tables and PivotCharts
Integration with Other Applications
- Importing external data (CSV, TXT)
- OLE (Object Linking and Embedding: static and linked)
- Web queries
- Publishing worksheets to websites (static and dynamic)
- Publishing PivotTables
Work Automation
- Conditional formatting
- Creating custom number formats
- Data validation to ensure correctness
- Recording and editing macros
Visual Basic for Applications (VBA)
- Developing custom functions
- Utilizing VBA for results and automation
- Designing VBA UserForms
Requirements
Proficiency in using spreadsheets and knowledge of 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
