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