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
Adjusting the Working Environment
- Utilising keyboard shortcuts and available facilities
- Creating and customising toolbars
- Configuring Excel Options (e.g., autosave, input settings)
- Using Paste Special options (including transpose)
- Applying formatting styles and using the Format Painter
- Utilising the Go To tool
Organising Information
- Managing sheets (naming, copying, and changing tab colours)
- Assigning and managing names for cells and ranges
- Protecting worksheets and workbooks
- Securing and encrypting files
- Collaborating using tracked changes and comments
- Performing sheet inspections
- Creating custom templates, charts, worksheets, and workbooks
Data Analysis
- Logical operations
- Basic functions
- Advanced functions
- Scenario analysis
- Search capabilities
- Solver
- Chart creation
- Graphics support (shadows, charts, AutoShapes)
Database Management (Lists)
- Data consolidation
- Grouping and outlining data
- Sorting data (across four or more columns)
- Advanced data filtering
- Database Functions
- Subtotals
- Tables and Pivot Charts
Collaboration with Other Applications
- Retrieving external data (CSV, TXT)
- OLE (static and linked)
- Web Queries
- Publishing sheets to a website (static and dynamic)
- Publishing PivotTables
Automation of Work
- Conditional Formatting
- Creating custom number formats
- Data validation and correctness checks
- Recording and editing macros
Visual Basic for Applications
- Creating custom functions
- Managing results in VBA
- VBA Forms
Requirements
Prerequisites include the ability to operate a spreadsheet and a general familiarity with 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
