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 Work Environment
- Keyboard shortcuts and productivity features
- Creating and customizing toolbars
- Configuring Excel Options (autosave, input settings, etc.)
- Using Paste Special (including transpose)
- Applying formatting (styles, format painter)
- Utilizing the Go To tool
Structuring Information
- Managing sheets (naming, copying, changing colors)
- Defining and managing names for cells and ranges
- Protecting worksheets and workbooks
- Securing and encrypting files
- Facilitating collaboration via change tracking and comments
- Conducting sheet inspections
- Building custom templates, charts, worksheets, and workbooks
Data Analysis
- Logical operations
- Essential functions
- Advanced functions
- Scenario analysis
- Search techniques
- Using the Solver tool
- Chart creation
- Enhancing graphics (shadows, charts, AutoShapes)
Database Management (Lists)
- Consolidating data
- Grouping and outlining information
- Sorting data across multiple columns
- Advanced data filtering
- Applying database functions
- Generating subtotals
- Working with tables and Pivot Charts
Integration with External Applications
- Importing external data (CSV, TXT)
- Using OLE (static and linked objects)
- Performing Web Queries
- Publishing sheets to websites (static and dynamic)
- Publishing PivotTables
Workflow Automation
- Implementing Conditional Formatting
- Creating custom formats
- Validating data correctness
- Recording and editing macros
Visual Basic for Applications
- Writing custom functions
- Understanding VBA outcomes and logic
- Designing VBA Forms
Requirements
Proficiency in using spreadsheets and a solid understanding of the Windows operating system.
21 Hours
Testimonials (2)
the trainer's patience,
Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany
well-prepared training, interesting topics
