Refresh your Excel basics

Tailor-made training

Would you rather have a tailor-made training based on this course? Contact us and we will make it work.
 
 

Description

Contents

Basics

  • Correct data entry (text, numbers, with filling handle)
  • Move around the worksheet
  • Add or remove rows and columns
  • Copy, move, and delete a range of cells
  • Naming the Worksheet
  • Copy, move, delete worksheets
  • Saving the file
  • Help in a New Way: "Tell Excel What You Want to Do"
  • Create and edit lists, e.g. via Autocomplete
  • Filter and sort in a list

Calculating with Excel

  • Manually creating formulas
  • Use simple functions: sum, average, min. and max.
  • Absolute, relative and mixed references
  • Calculating percentages

Formatting a table

  • Apply automatic formatting
  • Manual formatting: character formatting, frames, alignment, width and height
  • Formatting cells with numbers or data

Page Formatting & Printing

  • Control page orientation, margins, headline, and footer
  • Check print view before printing (resize/make it fit a certain number of pages).
  • Manage print settings: repeat print area, column or row titles on each page, etc.

Duration

0,5 day or 1 day (depending on prior knowledge)

E-Learning

95 EUR
Tailor-made training
Each organization is unique in its identity, and no co-worker is the same. That's why we at Learnia offer our clients tailor-made courses as well.
Continue reading