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
Tailoring Your Workspace
- Utilizing keyboard shortcuts and handy features
- Building and customizing toolbars
- Configuring Excel options (such as autosave and input settings)
- Using Paste Special options (including transpose)
- Applying formatting styles and using the Format Painter
- Navigating efficiently with the Go To tool
Structuring Information
- Managing worksheets (naming, duplicating, and applying color coding)
- Defining and managing named cells and ranges
- Protecting worksheets and entire workbooks
- Securing and encrypting files
- Facilitating collaboration via change tracking and comments
- Performing worksheet inspections
- Developing custom templates, charts, worksheets, and workbooks
Analyzing Data
- Applying logical operations
- Mastery of basic functions
- Implementing advanced functions
- Working with scenarios
- Using Search By
- Utilizing the Solver
- Creating charts
- Enhancing visuals (shadows, charts, and AutoShapes)
Database Management (Lists)
- Consolidating data
- Grouping and outlining information
- Sorting data across multiple columns
- Applying advanced data filters
- Using database functions
- Generating subtotals
- Building tables and Pivot Charts
Integrating with Other Applications
- Importing external data (CSV, TXT)
- Using OLE (static and linked)
- Executing web queries
- Publishing sheets to a website (static and dynamic)
- Sharing PivotTables
Automating Tasks
- Applying conditional formatting
- Creating custom number formats
- Validating data integrity
- Recording and editing macros
Visual Basic for Applications
- Developing custom functions
- Managing results in VBA
- Designing VBA forms
Requirements
Proficiency in spreadsheet operations and a solid understanding of the Windows environment.
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
