TRAINING INTRODUCTION TO EXCEL Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich

The goals of this introduction to Excel course 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, Vaud, Valais, Neuchatel, Fribourg, Zurich)
Training Advanced Word (Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich)
Training Word: large documents (Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich)
Training Word tables (Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich)
Training Advanced Excel (Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich)
Training Excel pivot tables (Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich)
Training PowerPoint (Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich)
Training Outlook (Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich)
Training New features in Office 2013 (Geneva, Vaud, Valais, Neuchatel, Fribourg, Zurich)