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. 07 Jan.

Wed. 04 Feb.

Thu. 05 Feb.

Mon. 02 Mar.

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!