PDF
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
