Excel - Fundamentals Course (English)

Welche Themen werden im Excel - Fundamentals Course behandelt?

• User Interface and Fundamentals
  • Structure and navigation of the Excel interface
  • Basic steps for creating and editing workbooks
  • Understand key program settings and adapt them to individual requirements
• Format Spreadsheets Professionally
  • Apply fonts, colours, borders, and cell formatting
  • Align content and present it clearly
  • Apply number formats and custom formats
  • Highlight cell values visually
• Formulas and Functions
  • Create formulas for common tasks
  • Use functions for calculations, sales statistics, and date and time calculations
  • Apply relative and absolute cell references with confidence
  • Move and copy cells and ranges
  • Use the Microsoft Office Clipboard efficiently
  • Copy formulas correctly to additional ranges
  • Create simple formulas and functions using ChatGPT or Gemini, and apply them in Excel
• Charts
  • Select suitable chart types
  • Create, edit, and format charts effectively
  • Visualise data clearly
• Edit Spreadsheets Efficiently
  • Structure spreadsheets correctly and avoid common errors
  • Work with multiple worksheets
  • Insert, delete, and adjust rows and columns
  • Organise large spreadsheets clearly
  • Format data as an Excel table and make use of its benefits
  • Search for and highlight formulas, numbers, and text
  • Prepare spreadsheets for printing, including headers and footers, page numbers, and print layout
• Practical Tips
  • Compatibility with older Excel versions
  • Overview of the most important Excel file formats
  • Proven tips and tricks based on our trainers’ many years of practical experience