The aim of the event is a secure handling of Excel. To begin, your basics will be refreshed. We then delve deeper into the topics of “creating tables independently, formatting, editing data lists, getting to know basic functions and creating charts”.

Workshop Content

First steps with Excel   

•    Starting Excel
•    The screen layout
•    Creating and opening Excel spreadsheets

Working in Excel sheets

•    Entering data
•    Copying and pasting cells
•    Inserting and merging rows and columns
•    Saving Excel workbooks
•    Inserting and editing comments
•    Entering formula

Formatting

•    Formatting of rows and columns
•    Changing number formats
•    Drawing frames
•    Formatting pages

Extended Range of Application

•    Cell references (relative and absolute)
•    Creating styles
•    Conditional formatting

Functions 

•    The Function Wizard
•    Example usage of functions

Charts

•    Basic information about charts
•    Creating and editing charts

 Printing 

•    Selecting a printer
•    Configuring printer settings