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 the software program
- Anatomy of the main interface window
- Managing workbooks and worksheets
Entering and Modifying Data in Worksheet Cells
Data Formatting
- Customizing display formats for various data types, including dates, monetary amounts, percentages, and fractions
- Setting cell borders and background colors
- Formatting headers for rows and columns
- Applying and customizing Styles
Navigation
- Efficiently navigating through large spreadsheets
- Simultaneous work across multiple worksheets and workbooks
Copying and Moving Data
- Selecting specific areas and cell ranges
- Moving data within the worksheet
- Utilizing special paste options
- Auto-filling data series, such as ordinal numbers and consecutive working days
Formulas, Cell References, and Named Ranges
- Creating, editing, and copying formulas
- Understanding and resolving circular references
- Applying conditional formatting rules
- Different address types and their practical applications
- Referencing cells in other worksheets and external workbooks
- Utilizing named ranges for clarity and ease of use
Functions
- General principles for using functions
- Overview of frequently used functions
- Nesting functions within one another
- Leveraging logical conditions (IF statements)
- Using the Function Wizard
Graphics in Spreadsheets
- Inserting AutoShapes and WordArt
- Incorporating static images and dynamic data-linked visuals
Charts
- Key chart types and their appropriate use cases
- Core principles for designing effective charts
- Step-by-step chart creation process
- Customizing chart components and elements
- Creating custom chart types
Hiding and Data Protection
- Hiding specific sheets, columns, and rows
- Concealing formulas and cell content from view
- Protecting worksheets and workbooks from unintended changes
- Password-protecting workbooks prior to opening
Printing
- Printing entire sheets and specific non-contiguous ranges
- Printing charts directly from the spreadsheet
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 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
well-prepared training, interesting topics
