Microsoft Excel Basics
Training Objectives
In this seminar you will learn how to work with Excel dependably. Participants at the end of the Seminar will be able to create worksheets, run calculations, format worksheets, print them and present the values in graphs and charts.
Course Prerequisites
Basic knowledge of the PC and Windows operating system
Course Description
- The Excel application window
- Structure of an Excel Worksheet and menus
- Inserting and formatting Text and Numbers
- Inserting, Deleting and Editing cells, rows and columns
- Copy, Cut and deleting cell contents
- Formatting Cells, Rows and Columns
- Font styles, Font size, Borders and Shading
- Cell References (relative and absolute)
- Rules for mathematical operators
- Constructing and using Excel-Functions (SUM, AVERAGE, COUNT)
- Printing Worksheets
- Defining print titles
- Inserting Page breaks
- Defining Headers and Footers
- Working with large worksheets
- Using AutoFilter functions
- Sorting worksheets
- Creating Charts
- Formatting Excel Charts
- Learning the various Chart types
Upcoming Classes and Price
Duration
2 days
Price per Student
378,00 € plus VAT
(Price incl. 19% VAT.: 449,82 €)
On site training
For your customized - on site training we tailor the course to your needs by adapting the schedule, meeting place and applications to fit with your particular agenda. For fast problem solving you can also schedule individual time with one of our instructors (training on the job).
You could not find the class you need? Please contact us directly. We are happy to further assist you.
Keywords for this seminar
Excel, Microsoft, Office, Office 2007, spreadsheet