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
Introduction
- Overview of fundamental program concepts
- Understanding the structure of the main interface
- Managing workbooks and individual sheets
Data Entry and Modification in Cells
Data Formatting
- Configuring display settings for various data types and calculation outcomes, such as dates, currency, percentages, and fractions
- Customising cell borders and background fills
- Styling row and column headers
- Application of predefined Styles
Navigation
- Efficient movement through large worksheets
- Simultaneous work across multiple worksheets and workbooks
Copying and Moving Data
- Selecting specific areas and cell ranges
- Transferring data effectively
- Advanced insertion techniques
- Using Autofill to populate data series, including ordinals and subsequent working dates
Formulas, Addresses, and Cell Names
- Creating, editing, and duplicating formulas
- Identifying and resolving circular references
- Applying conditional formatting
- Understanding different address types and their applications
- Referencing data from other worksheets and workbooks
- Utilising named cells for clarity
Functions
- General principles for using functions
- Exploring frequently used functions
- Nesting functions for complex logic
- Working with conditional functions
- Utilising the Function Wizard
Graphics in Spreadsheets
- Incorporating AutoShapes and WordArt
- Embedding static and dynamic data visualisations
Charts
- Overview of primary chart types and their use cases
- Best practices for designing effective charts
- Step-by-step chart creation
- Customising chart components and modifications
- Developing custom chart types
Data Protection and Hiding
- Concealing specific sheets, columns, and rows
- Hiding formulas and cell contents
- Securing worksheets and workbooks against modifications
- Protecting workbooks prior to opening
Printing
- Printing specific sheets and non-contiguous areas
- Outputting charts to print
Requirements
Familiarity with the Windows operating system.
14 Hours
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 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
well-prepared training, interesting topics
