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
- Essential keyboard shortcuts and features
- Building and customizing toolbars
- Configuring Excel Options (such as autosave and input settings)
- Using Paste Special (including transpose)
- Applying formatting (styles and format painter)
- Navigating using the Go To tool
Structuring Information
- Managing worksheets (naming, copying, and color coding)
- Defining and managing named cells and ranges
- Securing worksheets and workbooks
- Encrypting files for data security
- Collaborating and tracking changes or comments
- Using the Inspector tool
- Creating custom templates, charts, worksheets, and workbooks
Analyzing Data
- Logical operations
- Foundational functions
- Advanced functions
- Scenario analysis
- Search techniques
- Using the Solver tool
- Creating charts
- Visual enhancements (shadows, charts, and AutoShapes)
Managing Databases (Lists)
- Data consolidation techniques
- Grouping and outlining data
- Sorting data across multiple columns
- Advanced filtering methods
- Utilizing database functions
- Generating subtotals
- Working with tables and Pivot Charts
Integrating with Other Applications
- Importing external data (CSV, TXT)
- Using OLE (static insertion and linking)
- Performing Web Queries
- Publishing sheets to websites (static and dynamic)
- Publishing PivotTables
Automating Tasks
- Implementing Conditional Formatting
- Designing 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
Proficiency in working with spreadsheets and a solid understanding of the Windows operating system are required.
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
