Excel 2021 - Stufe 1: Grundlagen

Targeted use of tables, charts, and formulas

Illustrative instructions, exercises, and examples

Written by instructors - with practical user tips

Learn Excel 2021 - the indispensable assistant for work, everyday life, or study - from the ground up and master it! This manual is structured like a course and systematically introduces beginners to the fundamentals of spreadsheet applications. Users with some prior knowledge can use the manual as a practical reference guide.

The authors guide you from efficient data entry to formatting text and numbers, all the way to using formulas and functions. Soon, creating professional charts will be just as easy for you as working with functions like SUM, IF, COUNT, COUNTA, and VLOOKUP. Clear examples and easy-to-follow step-by-step instructions will help you understand and implement even complex tasks. Additionally, benefit from the numerous practical tips from the experienced instructors. With Excel, you have your numbers under control!

Content includes:

• Creating workbooks and using smart tables
• Tips for clever data entry and editing
• Generating series, such as number sequences or days of the week
• Designing tables and applying templates
• Managing, sorting, and filtering data
• Printing tables (setting print areas, page layout, etc.)
• Calculations with formulas and useful evaluation functions
• Relative and absolute cell references in formulas
• Other important functions: IF, IFS, VLOOKUP, and many more
• Creating, formatting, and modifying charts
• Creating your own templates and sharing tables in a team.