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
- Fundamentals of the software
- Understanding the main window layout
- Managing workbooks and worksheets
Inputting and updating data in worksheet cells
Data Formatting
- Configuring the display for various data types and calculation outcomes, such as dates, currency values, percentages, and fractions
- Setting cell borders and background styles
- Styling row and column headers
- Applying predefined Styles
Navigation
- Efficiently navigating large worksheets
- Working simultaneously with multiple worksheets or workbooks
Duplication and relocation of data
- Selecting specific areas (cell ranges)
- Migrating data
- Special insertion techniques
- Auto-filling data series, such as ordinal numbers and subsequent business days
Formulas, addresses, and cell naming
- Creating, editing, and duplicating formulas
- Understanding circular references
- Implementing conditional formatting
- Different address types and their specific uses
- Referencing data in other worksheets and workbooks
- Utilizing defined cell names
Functions
- General principles for using functions
- Commonly applied functions
- Nesting functions
- Utilizing conditional logic
- Using the Function Wizard
Visual elements in spreadsheets
- Using AutoShapes and WordArt
- Inserting static and dynamic data images
Charts
- Key chart types and their practical applications
- Core principles for designing impactful charts
- Chart creation process
- Modifying graph components
- Developing custom chart types
Data Concealment and Protection
- Concealing sheets, columns, and rows
- Masking formulas and cell entries
- Safeguarding worksheets and workbooks from edits
- Protecting workbooks prior to opening
Printing
- Printing individual sheets and non-contiguous areas
- Printing charts
Requirements
Familiarity with the Windows operating system is required.
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 2900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
well-prepared training, interesting topics