Use tables, charts, and formulas effectively. Clear instructions, exercises, and examples. Written by instructors - with practical user tips. Get to know and master Excel 2024, the indispensable assistant for work, everyday life, or study, from the ground up. This manual is structured like a course and systematically introduces beginners to the fundamentals of spreadsheet software. 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 as easy for you as working with functions like SUM, IF, COUNT, COUNTA, and XLOOKUP. Clear examples and easy-to-follow step-by-step instructions will help you understand and tackle even complex tasks. Additionally, benefit from the numerous practical tips from experienced instructors. With Excel, you have your numbers under control.

Contents:

• Creating workbooks and using smart tables
• Tips for clever data entry and editing
• Generating sequences, such as number series or weekdays
• Designing tables and applying formatting 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, XLOOKUP, and many more
• Creating, formatting, and modifying charts
• Creating your own templates and sharing tables within a team.