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.
Duration 21 hours
Course Outline
Customizing the Work Environment
- Utilizing keyboard shortcuts and available features
- Creating and modifying toolbars
- Configuring Excel Options (including autosave and input settings)
- Using Paste Special for tasks like transposing
- Applying formatting styles and using the Format Painter
- Using the Go To tool for navigation
Structuring Information
- Managing sheets via naming, copying, and color coding
- Assigning and managing named cells and ranges
- Protecting worksheets and workbooks
- Securing and encrypting files
- Managing collaboration, tracking changes, and comments
- Inspecting sheets for issues
- Creating custom templates, charts, worksheets, and workbooks
Data Analysis
- Logic principles
- Essential functions
- Advanced formula techniques
- Scenario management
- Look-up functions
- Using the Solver add-in
- Chart creation and analysis
- Enhancing visuals with shadows, charts, and AutoShapes
Database Management (Lists)
- Consolidating data sources
- Grouping and outlining data structures
- Sorting complex data across multiple columns
- Applying advanced filters
- Using database-specific functions
- Generating subtotals
- Working with Tables and Pivot Charts
Integration with Other Applications
- Importing external data (CSV, TXT)
- Using OLE for static embedding and linking
- Executing Web Queries
- Publishing sheets to websites (static and dynamic)
- Publishing PivotTables
Workflow Automation
- Implementing Conditional Formatting
- Defining custom number and cell formats
- Validating data correctness
- Recording and editing macros
Visual Basic for Applications (VBA)
- Developing custom functions
- Managing results within VBA
- Designing VBA Forms
Requirements
Familiarity with spreadsheet operations and general Windows usage are required.
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
