Excel training (Microsoft Office)

Excel training program (beginner)

Woospeak, language and office training center since 2006 , offers you its expertise for your Microsoft Excel office training . Our experienced trainers will help you improve and master the Microsoft Office suite Excel software. .

Goal: Acquire the essential basics of Excel software (Microsoft Office suite).
Discover the potential of the software: create tables, graphs, lists
Create simple tables integrating calculations, format and print them.
Learn to communicate data and figures efficiently using software.
Method: Face to face, telephone, videoconference, e-learning
Prerequisites: Know how to use a computer in a basic way (mouse, keyboard) and know the Windows environment
Public: Anyone with knowledge of Excel software
Duration: 2, 4, 6, 8, 10 hours ... adjustable duration as needed
Possible certifications: TOSA, B2i, PCIE, ENI

The objectives of your Microsoft Excel training

Our Excel training is one of our training courses in our office catalog. It will help you to master all the features of Excel software . This training will allow you among other things: to acquire the essential bases of the Excel software, to discover the potentialities of the software (create tables, graphs, lists), to carry out simple tables integrating calculations, to format them and print them, learn how to communicate data and figures efficiently using software.
Whatever your basic level, our tailor-made training programs are fully adapted to help you progress.

The program of your Excel training (Beginner)

The content of the Excel training program is organized into 5 major areas, and will be adapted according to your objectives and your needs:


Module 1: Presentation of Excel software

  • Become familiar with Excel.
  • Find your way around the screen: toolbar, status bar, menus, ruler.
  • Analyze the basic concepts of a spreadsheet.
  • Organize your tables in the filing cabinets.
  • Insert, delete, move a sheet inside a workbook.
  • Set up formulas and automate them.
  • Manage cells: entry, writing and copying of formulas, modification.

Module 2: Realization of tables with simple calculations

  • The automatic sum.
  • Construction of calculation formulas with operators.
  • The copy of the formula.
  • Copy and move cells.
  • The incremented series.
  • Help tools for data entry.

Module 3: Creating and modifying simple graphics

  • Generate graphs from tables.
  • Choice of abscissa axes, ordered.
  • Modify the presentation.
  • Add text.
  • Selection of cells.
  • Insert a graphic as an object near the table.
  • 3D graphics and 3D view.
  • Add or delete series.
  • Print the graph, table, graph and table.

Module 4: Formatting and layout

  • Management of rows and columns.
  • Selection of cells.
  • Special selections by the Edit - Go command.
  • Formatting cells.
  • Text areas.
  • Layout.
  • Impression.

Module 5: Automating calculations in Excel

  • Addressing modes: absolute and relative.
  • Calculate percentages and produce ratios.
  • Perform statistics: SUM (), AVERAGE ().
  • Apply conditions: IF ().
  • Use the date functions: NOW (), TODAY ().
  • Consolidate several sheets of a workbook with the SUM () function.
  • The assistant function.

Practical work & learning control

If you wish, we can also offer you an office certification such as TOSA. This Excel training is eligible for the CPF (Personal Training Account) .


beginner excel training program

Microsoft Excel in video training, by phone or face to face

As a specialized training organization, Woospeak offers you different training methods:

This Excel training can take place at home or within your company.

DISCOVER ALL OURTRAINING METHODS

We organize training sessions wherever you are and everywhere in France

Want to know more ? Please do not hesitate to contact us with any questions.
You can also ask us for a quote on your Excel training. .