Seminarinhalt
This seminar provides the necessary knowledge to successfully create tables with Microsoft Excel. Furthermore, easy formula calculations, as well as the different formatting variants are worked through.
After completing this seminar, participants will have knowledge on the following topics:
ETC goes green
As a contribution to conscious environmental protection, ETC has dispensed with printed documents for this seminar since 01.11.2019. Included in the seminar price is access to Video Based Trainings (VBTs): www.trainit.biz. If you would like to receive a printed document in addition to the VBT, this can be purchased from us at any time for a contribution towards costs of € 25,- (excl. VAT). Please contact us at [email protected].
After completing this seminar, participants will have knowledge on the following topics:
- Getting to know Excel
- First steps with Excel
- Designing tables
- Changing the table structure
- Performing calculations with formulas
- Using functions
- Create charts
- Printing spreadsheets
- Tips and tricks
ETC goes green
As a contribution to conscious environmental protection, ETC has dispensed with printed documents for this seminar since 01.11.2019. Included in the seminar price is access to Video Based Trainings (VBTs): www.trainit.biz. If you would like to receive a printed document in addition to the VBT, this can be purchased from us at any time for a contribution towards costs of € 25,- (excl. VAT). Please contact us at [email protected].
Programm
Get to know Excel
- Spreadsheet calculation with Excel
- Starting the Excel program
- Getting to know the Excel window
- The File tab - the Backstage view
- Getting to know the Excel workbook
- Getting help
- Entering text and numbers
- Change or delete cell contents
- Selecting cells
- Special features of data entry
- Entering data quickly with the fill function
- Calculate totals
- Save workbooks
- Close workbooks and exit Excel
- Open workbooks
- Create new workbooks
- Working with multiple workbooks
- Format cells
- Change font, size and color
- Change column width and row height
- Align cell contents
- Use line breaks and join cells
- Use border lines and fill colors for cells
- Assign number formats
- Formatting tips
- Using style sheets
- Using conditional formatting
- Moving and copying with the clipboard
- Moving and copying with drag and drop
- Inserting or deleting columns and rows
- Hiding or showing columns and rows
- Sort table data
- Flash fill
- The structure of a formula
- Entering formulas
- Using different reference types
- Using references to other spreadsheets
- The structure of a function
- Entering functions
- Using the function library
- Correcting incorrect functions
- Using charts in Excel
- Overview of important chart types
- Create a chart
- Quick visualization with suggested charts
- Swap the arrangement of chart data
- Change size and position of a chart
- Assign diagram layouts
- Use diagram style sheets
- Move diagram to a chart sheet
- Printing a spreadsheet quickly
- Use print preview
- Making page layout settings
- Setting up headers and footers
- Printing tips and tricks
- Running the spell checker
- Finding and replacing cell contents
- Fixing rows and columns
- Saving workbooks in PDF format
- Using workbooks in different versions of Excel
Zielgruppen
This seminar is designed for people who want to get an introduction to Microsoft Excel and create various tables with Excel.
- Information Worker
Vorkenntnisse
Windows basics
Wichtige Information
We train the latest version of the program and during the seminar we show the differences in functionality with older versions.
Alternative learning formats
Alternative learning formats
- Video Based Training (self-study)