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
- Utilizing keyboard shortcuts and built-in features
- Creating and customizing toolbars
- Configuring Excel Options (such as autosave and input settings)
- Using Paste Special options (including transpose)
- Applying formatting (styles and the Format Painter)
- Using the Go To tool
Structuring Information
- Managing worksheets (naming, copying, and color coding)
- Assigning and managing names for cells and ranges
- Protecting worksheets and entire workbooks
- Securing and encrypting files
- Facilitating collaboration through change tracking and comments
- Inspecting sheets for issues
- Developing custom templates, charts, worksheets, and workbooks
Data Analysis Techniques
- Understanding logical operations
- Applying basic functions
- Utilizing advanced functions
- Working with scenarios
- Using Search by functionality
- Employing the Solver tool
- Creating and analyzing charts
- Adding graphical elements (shadows, charts, and AutoShapes)
Database Management (Lists)
- Consolidating data
- Grouping and outlining datasets
- Sorting data across multiple columns
- Applying advanced data filters
- Using Database Functions
- Calculating subtotals
- Creating Tables and Pivot Charts
Integration with Other Applications
- Importing external data (CSV, TXT)
- Using OLE (static and linked objects)
- Executing Web Queries
- Publishing sheets to sites (static and dynamic)
- Publishing PivotTables
Workflow Automation
- Applying Conditional Formatting
- Creating custom number formats
- Validating data correctness
- Recording and editing macros
Visual Basic for Applications (VBA)
- Developing custom functions
- Handling results within VBA
- Building VBA Forms
Requirements
Prerequisites include proficiency in using spreadsheet software and a solid understanding 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
