Microsoft Excel Crash Course
Course description
Excel knowledge is essential in many jobs. In this practical, intensive training, you will learn the essential functions of Microsoft Excel in an understandable and practical way. The course enables you to use Excel efficiently in your everyday work. You will gain practical skills in spreadsheets, learn how to analyze data effectively and use the "Solver" tool profitably.
This training is the perfect preparation for advanced Excel courses in which you can further deepen your knowledge in specific areas.
Course content
- Excel work surface
- Managing workbooks
- Layout and structure of tables
- Navigation in the spreadsheet
- Cell formatting and styles
- Introduction to formulas
- Basic functions: SUM, AVERAGE, COUNT
- The Function Assistant
- Overview of frequently used functions
- Set print area and adjust page view
- Creating and customizing charts
- Inserting graphics
- Monitoring table contents
- Sorting and filtering data
- Conditional formatting
- Basics of database functions
- Working with VLOOKUP
- Use of data tools
- Evaluation of formulas
- Consolidate and combine data
- Creating partial results
- Conducting trend analyses
- Using the Excel Solver
- Using the Scenario Manager
- Target value search
- Defining validity rules
- Integrating Excel with other applications
Current version: New features and updates
- Improved data import functions
- Selecting and editing objects with a pen
- Practical tips & tricks
The course is taught in the latest version (365). Training for earlier versions is also possible upon request.
Requirements
Basics: General PC and Windows knowledge.
Next appointment
17 September 2024
Class times
(8 x 45 minutes)
09:00 a.m. to 4:30 p.m.
Price
369,- EUR Book seminar now