Get in Touch
 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.
Investment

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)

Upcoming Courses

Related Categories