Excel 2013, 2016, Office 365 - Fundamentals

Betribsiwwergräifend Formatioun

U wie riicht sech d'Formatioun?

Anyone who wishes to learn how to create and manage electronic tables.

Dauer

12,00 Stonn(en)

Sprooch(e) vun der Déngschtleeschtung

EN

Nächst Sessioun

Ziler

After the training the participant shall be able to:

  • create tables and manage them; to format and manipulate data; to create and print charts from Excel data.

Inhalt

  • Excel environment
    • The Excel environment: Quick Access toolbar, ribbon and tabs
    • Customize Quick Access toolbar and the ribbon
    • Live Preview and Paste Preview
  • Manage spreadsheets
    • Add, rename, delete a worksheet
    • Move and copy a sheet
    • Define a tab color
    • Change the height or width of the formula bar
  • Manage Tables
    • Enter and validate data
    • Manage rows and columns: add, resize, delete, hide / show
    • Find / Replace data
    • Copy / paste data
  • Document Management
    • Create / open / save a document
    • Headers and footers
    • The "Page Layout" view
  • Calculate
    • Enter and copy formulas
    • Smart tags
  • Functions
    • Insert Function using the wizard
    • Insert function manually, semi-automatic formula input
  • Format table
    • Format cells
    • Using styles
    • Predefined conditional formats
  • Present data with a graph(Chart)
    • Create a chart
    • Change / format a Chart
    • Use the chart styles
    • Create and use a chart template
    • Sparklines
  • Analyze the data tables
    • Create a data table (Insert Table)
    • Sort and filter data tables
    • List filters with search box
    • Sort and filter by font or fill color
    • The Flash Fill

Certificat, Diplom

At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.

Dës Formatioune kéinten Iech interesséieren

FR
Dag
Blended-Learning
Logiciel - Logiciel Content Management Entreprise - Spreadsheet-Logiciel - Logiciel Excel