Seminar S-IT0002 - Excel: Core and essential features

Target Audience

Anyone who wants to master the general and essential features of Excel or to pass the ICDL certification.

Objectives

  • 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.

Content

  • Working with sheets:
    • open, create and save workbooks;
    • select, insert and delete cells;
    • data types, series and custom lists;
    • 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.

Sessions