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
- Utilizing keyboard shortcuts and productivity features
- Creating and customizing toolbars
- Configuring Excel Options (including autosave and input settings)
- Using Paste Special (transpose)
- Applying formatting (styles, format painter)
- Navigating with the Go To tool
Information Organization
- Managing worksheets (naming, copying, and tab colors)
- Defining and managing cell and range names
- Protecting worksheets and workbooks
- Securing and encrypting files
- Collaborating via change tracking and comments
- Conducting sheet inspections
- Creating custom templates, charts, worksheets, and workbooks
Data Analysis
- Logical operations
- Essential functions
- Advanced functions
- Working with scenarios
- Lookup techniques
- Using the Solver add-in
- Charting capabilities
- Visual enhancements (shadows, charts, AutoShapes)
Database Management (Lists)
- Data consolidation
- Grouping and outlining data
- Sorting complex datasets (four or more columns)
- Advanced filtering techniques
- Database-specific functions
- Creating subtotals
- Building tables and PivotTables
Integration with Other Applications
- Importing external data (CSV, TXT)
- OLE (static embedding and linking)
- Web queries
- Publishing sheets to websites (static and dynamic)
- Publishing PivotTables
Workflow Automation
- Applying conditional formatting
- Developing custom number formats
- Implementing data validation
- Recording and editing macros
Visual Basic for Applications
- Developing custom VBA functions
- Handling return values in VBA
- Designing VBA UserForms
Requirements
You should possess fundamental spreadsheet skills and a working knowledge 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
