TRAINING INTRODUCTION TO EXCEL Geneva, Zürich and Vaud

The goals of this introduction to Excel course (Geneva, Zürich and Vaud) are:

To master the main functions of Excel 2013 so that you can independently create, format, layout and print tables; to master basic calculations; to use the graphics tool and benefit from the new wizard for choosing the type of chart you want to create.

Participants
Open to everyone.

Course requirements
Participants must have attended a course on Windows or have equivalent knowledge.

Practical exercises
This introduction to Excel course, which is based on realistic simulation exercises and a comparison of different practices, will equip participants with techniques that can be used directly.

Programme for the introduction to Excel course

Getting started with Excel 2013

• Exploring the new start-up interface
• The ribbon – tabs
• Full-screen mode
• Exploring the File tab with the new Backstage view
• Quick access toolbar
• Context menus
• Using the dialog box launcher

Managing workbooks in Excel 2013

• Opening / saving / saving as
• Sending a workbook by mail as a PDF
• Displaying a table on-line using the internet
• Sharing via SkyDrive or SharePoint
• Printing

Entering, validating and changing data

• Entering and validating data
• Modifying cells
• Selecting cell ranges
• Using the fill handle
• Inserting / deleting rows, columns and cells
• Copying / cutting / pasting rows, columns and cells

Formatting in Excel 2013

• Home tab: font / alignment / number
• Reproducing formatting
• Cell styles
• Conditional formatting (using the rapid analysis tool)

Calculation formulas in Excel 2013

• Using AutoSum
• Structuring a calculation formula using a function
• Creating a formula using mathematical operators (+ – * /)
• Using other functions (Average, Count, Max., Min.)
• Re-copying a calculation formula
• Cells: relative or absolute

Layout in Excel 2013

• Applying themes
• Adjusting the document layout for printing (Preview, Orientation, Margin, Scaling)
• Creating headers and footers

Managing sheets in a workbook

• Tabbing (inserting, copying/moving, naming and deleting a spreadsheet)

Generating charts in Excel 2013

• Principles and tips for creating charts
• Using the recommended charts function
• Customising a chart
• Using Sparklines (mini charts positioned in individual cells)
• Animating charts (TimeLine, Slicers)

Course diploma / certificate

A certificate is obtained at the conclusion of the Introduction to Excel course.

Similar types of training courses:

Training Introduction to Word (Geneva, Zürich and Vaud)
Training Advanced Word (Geneva, Zürich and Vaud)
Training Word: large documents (Geneva, Zürich and Vaud)
Training Word tables (Geneva, Zürich and Vaud)
Training Advanced Excel (Geneva, Zürich and Vaud)
Training Excel pivot tables (Geneva, Zürich and Vaud)
Training PowerPoint (Geneva, Zürich and Vaud)
Training Outlook (Geneva, Zürich and Vaud)
Training New features in Office 2013 (Geneva, Zürich and Vaud)