Excel 365 Fundamentals

In this two-day training course, participants will learn the fundamental features of Excel 365, both locally and online.
The course provides hands-on instruction on how to enter, format, calculate, and analyze data.

A special focus is placed on analyzing large data sets, creating charts, and working with dynamic tables.
Participants will also learn how to effectively use Excel Online and shared workbooks.

This course is ideal for beginners and for anyone who wants to build a solid foundation for the professional use of Excel 365.

Your Benefits at a Glance

• Confident use of Excel 365 locally and online
• Efficient data entry, formatting, and analysis
• Creation of dynamic tables and charts
• Tips and tricks for fast navigation in Excel
• Participation possible in person or online

Seminar Contents

Basic Program Operation

• Start Excel locally or online
• Create, save, and organize workbooks

Creating and Editing Tables

• Enter numbers and text
• Move, copy, and use paste options
• Delete or insert rows and columns
• Tips for fast navigation within tables
• Use AutoFill features

Formatting Tables

• Apply text and number formats
• Create borders and background formats
• Add headers and footers
• Use table and cell styles

Working with Large Lists

• Freeze rows and columns, split tables
• Sort and filter lists
• Analyze data in dynamic tables
• Use slicers in dynamic tables
• Create subtotals

Printing Tables and Print Preparation

• Set page margins
• Define print areas and print titles
• Adjust page breaks

Performing Basic Calculations

• Basics of formulas and functions
• Add, multiply, divide, and subtract values
• Use functions: SUM, MAX, MIN
• Understand relative and absolute references

Creating Charts

• Chart types and their uses
• Create simple charts
• Customize chart options

Collaborating on Workbooks

• Share workbooks
• Edit workbooks in Excel Online

Prerequisites

• Basic knowledge of Office 365 or any earlier Office version is an advantage

Target Audience

• Users who work with Excel 365 locally or online to create spreadsheets, perform calculations, and analyze data
• Beginners who want to build a solid foundation for advanced Excel courses