Details

Goals

Being able to use the basics functions of an Excel table.

Prerequisite

None.

Contents

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
  • Paste options

Document management

  • Create / open / save a document
  • Headers and footers
  • The « Page Layout » view

Format table

  • Format cells
  • Using styles

Calculate

  • Simple formulas
  • Simple functions

Sign up

Next session(s)

Wed. 25 Mar.

Thu. 02 Apr.

Wed. 15 Apr.

Wed. 06 May.

Tue. 02 Jun.

Wed. 03 Jun.

Fri. 12 Jun.

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!