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
Configuring the Workspace
- Keyboard shortcuts and user interface features
- Customizing and creating toolbars
- Configuring Excel options (autosave, input settings, etc.)
- Utilizing Paste Special (including transpose functionality)
- Advanced formatting techniques (styles, Format Painter)
- Navigating efficiently using the Go To tool
Structuring Information
- Managing worksheets (naming, duplicating, visual identification)
- Defining and managing named ranges and cells
- Implementing protection for worksheets and workbooks
- Securing and encrypting files for data integrity
- Facilitating collaboration through change tracking and comments
- Conducting worksheet inspections for metadata and content
- Developing custom templates, charts, worksheets, and workbooks
Data Analytics and Modeling
- Logical constructs in formulas
- Core spreadsheet functions
- Advanced analytical functions
- Scenario analysis
- Conditional lookups and searches
- Using the Solver add-in for optimization
- Creating and managing charts
- Enhancing visuals with shadows, charts, and AutoShapes
Database Operations (Lists)
- Consolidating data from multiple sources
- Grouping and outlining data for summary views
- Sorting data across multiple columns
- Applying advanced filters for complex queries
- Utilizing specific database functions
- Generating subtotals and partial sums
- Working with Excel Tables and Pivot Charts
Integration with External Systems
- Importing external data (CSV, TXT formats)
- Object Linking and Embedding (OLE) – static and linked data
- Executing web queries
- Publishing worksheet data to websites (static and dynamic)
- Publishing PivotTables to external platforms
Workflow Automation
- Applying Conditional Formatting rules
- Creating and applying custom number and cell formats
- Implementing data validation checks
- Recording, editing, and debugging macros
Visual Basic for Applications (VBA)
- Developing custom user-defined functions
- Handling results and data types in VBA
- Designing and managing VBA user forms
Requirements
Essential proficiency in spreadsheet operations 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
