Microsoft Excel, which is available in the versatile Microsoft Office Standard 2021 Suite is one of the most important tools for data management, analysis and visualization. Whether you are just starting out or an advanced user looking to expand your skills, this guide will take you through the key features and capabilities of Excel.

First steps with Microsoft Excel

1. Understanding the user interface

  • Workbooks and worksheetsA workbook is the Excel file that is created with Microsoft Office Standard 2021, and each workbook contains several worksheets (tabs).
  • Menu ribbon: The toolbar at the top of the window, which you can use to access various functions.
  • Cells, rows and columnsThe grid layout in which data is entered. Cells are individual boxes, rows run horizontally, columns vertically.

2. Basic navigation and data entry

  • NavigationUse the arrow keys, scroll bars or the mouse to move around the worksheet.
  • Data inputClick on a cell and start typing. Press Enter to move to the next cell below or Tab to move to the next cell on the right.

Important functions and formulas

1. Basic arithmetic operations

  • Addition (=SUM(A1:A10))Adds all numbers in a range.
  • Subtraction (=A1-B1))Subtracts the value of one cell from another.
  • Multiplication (=A1*B1))Multiplies the values of two cells.
  • Division (=A1/B1))Divides the value of one cell by another.

2. Common functions

  • AVERAGE (=MEAN(A1:A10))Calculates the average of a cell range.
  • MIN and MAX (=MIN(A1:A10), =MAX(A1:A10)): Finds the smallest or largest value in a range.
  • COUNT (=NUMBER(A1:A10))Counts the number of numerical values in a range.

3. Text functions

  • CHAIN (=VERKETTEN(A1; ” “; B1)): Combines text from several cells into a single cell.
  • LEFT, RIGHT, PARTExtract parts of a text string from a cell.

Data visualization

1. Create diagrams

  • Select dataSelect the data you want to display in the diagram.
  • Insert diagram: Gehen Sie zur Registerkarte “Einfügen” in Microsoft Office Standard 2021 und wählen Sie den gewünschten Diagrammtyp (z. B. Balken, Linien, Kreis).
  • Customize diagrams: Verwenden Sie die “Diagrammtools”, um Design, Layout und Format Ihres Diagramms zu ändern.

2. Conditional formatting

  • Highlight dataUse conditional formatting to visually highlight data that meets certain criteria.
  • Apply rules: Wählen Sie den Zellbereich aus, gehen Sie zu “Start” > “Bedingte Formatierung” und wählen oder erstellen Sie eine Regel.

Advanced functions

1. Pivot tables

  • Create pivot table: Wählen Sie Ihren Datenbereich aus, gehen Sie zu “Einfügen” > “PivotTable” in Microsoft Office Standard 2021 und wählen Sie den Speicherort der Tabelle.
  • Using pivot tablesDrag fields to group data, create reports and analyze large amounts of data.

2. SVERWEIS and WVERWEIS

  • SVERWEIS (=SVERWEIS(value;table;column index;[range_reference]))Searches for a value in the first column of a table and returns a value in the same row from a specific column.
  • WVERWEIS (=WREFERENCE(value;table;row index;[range_reference]))Like SVERWEIS, but for horizontal searches in the first line.

Tips and tricks

1. Keyboard shortcuts

  • Ctrl + C / Ctrl + VCopy and paste.
  • Ctrl + Z / Ctrl + YUndo and Redo.
  • Ctrl + F: Search and replace.

2. Data verification

  • Restrict entriesUse data validation to check the type of entries in a cell (e.g. date, numbers).
  • Create drop-down lists: Gehen Sie zu “Daten” > “Datenüberprüfung” in Microsoft Office Standard 2021, wählen Sie “Liste” und geben Sie Ihre Einträge ein.

Conclusion

As part of Microsoft Office Standard 2021, Microsoft Excel is an extremely powerful tool that, once mastered, can significantly increase your productivity and efficiency in data processing. From simple data entry and basic calculations to complex data analysis and visualization, Excel offers a wide range of functions for the most diverse requirements. Practice regularly, discover advanced functions and use the many online resources available to continuously improve your Excel skills.

Ready to unleash the full potential of Microsoft Excel? Have your product key for Microsoft Office Standard 2021 ready and consider upgrading to a Microsoft Office Standard 2021 License for 3 PCs. This comprehensive package ensures that you have all the tools you need for professional and personal use on multiple devices. Good luck with Excel!