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.
Duration 14 hours
Course Outline
Introduction
- Core information about the application
- Structure of the main window
- Managing workbooks and worksheets
Inputting and Editing Data in Worksheet Cells
Data Formatting
- Specifying display formats for various data types and calculation outcomes (such as dates, currencies, percentages, or fractions)
- Adjusting cell borders and backgrounds
- Formatting row and column headers
- Applying Styles
Navigation
- Traversing large spreadsheets efficiently
- Working simultaneously with multiple worksheets or workbooks
Copying and Moving Data
- Selecting specific cell ranges
- Relocating data
- Special insertion methods
- Using AutoFill to generate data series (e.g., sequential numbers or upcoming business days)
Formulas, Addresses, and Cell Names
- Creating, editing, and duplicating formulas
- Understanding circular references
- Implementing conditional formatting
- Different types of cell addresses and their applications
- Referencing other worksheets and workbooks
- Utilizing named cells
Functions
- General guidelines for function usage
- Commonly used functions
- Nesting functions
- Applying conditional logic
- Using the Function Wizard
Graphics in Spreadsheets
- Working with AutoShapes and WordArt
- Displaying static and dynamic data visualizations
Charts
- Overview of primary chart types and their use cases
- Key principles for designing impactful charts
- Building charts step-by-step
- Modifying chart components
- Creating custom chart types
Concealing and Protecting Data
- Hide sheets, columns, and rows
- Conceal formulas and cell contents
- Locking worksheets and workbooks to prevent changes
- Securing workbooks prior to opening
Printing
- Printing specific sheets and non-contiguous ranges
- Outputting charts
Requirements
Familiarity with the Windows operating system
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
well-prepared training, interesting topics
