Excel: Core and essential features (S-IT0002)

Obtain a global vision of the possibilities of handling the Excel spreadsheet in a professional environment. Participants will also be prepared to participate without difficulty in advanced and specialized courses about the Excel spreadsheet.

• Working with sheets:
• open, create and save workbooks
• select, insert and delete cells
• data types, series and custom lists
• find and replace contents, copy and move cells
• one level data sort
• customize options
• default file locations
• Basic formulas and functions:
• calculating with cells
• use basic functions in calculations
• error message significations
• types of references
• basic content check with the help of the logical IF-function.
• Formatting sheets:
• the autoformat tool
• number and date format
• font and alignment settings
• the format painter
• merge cells
• borders and special effects.
• Creating charts:
• 3 basic chart types
• add, remove and handle chart elements.
• Page layout and printing:
• basic page setup
• automatic fields in headers and footers
• print area selection.
• Managing workbooks:
• insert, delete, rename, copy and move sheets
• insert objects and use comments