Excel 2013, 2016, 2019 - Fundamentals

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.
  

• 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

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

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