MSEX207 - Microsoft Excel 2007 – In Practice

This course is assigned for users, who already work with Microsoft Excel on basic level. We will teach you to fully employ its possibilities and create documents with tables and graphs on a professional level. It is assumed that you already know Microsoft Excel on “Microsoft Excel - basic course” level.

Who the course is for

What we teach you

Required skills

Teaching methods

Teaching materials

Course syllabus

Formatting cells

• Cell style
• Conditional formatting

Template

Automatic saving

Working with files and sheets

Copying

• Series
• Using clipboard with Paste options

Creating formulas

• Inserting formulas rules
• Absolute addressing
• Naming of regions

Insert function wizard

• Examples of different types of functions

Databases and working with large tables

• Windows, panes, splitting
• Forms
• Validation
• Find, Replace, Go To
• Sorting
• Large tables printing options

Filters and working with lists

• AutoFilter and advanced filter

Managing databases accessories

• Text decomposition to columns
• Outlining, Grouping, Subtotals, Consolidation
• Pivot tables

Formatting charts

Recommended prior courses

MSEX107 - Microsoft Excel 2007 – Basic Course
MSSA - Microsoft Office 2007 – Application Co–operation
PCWI - PC and Windows – For Beginners

Recommended subsequent courses

MSEX307 - Microsoft Excel 2007 – Advanced Methods and Functions
MSEXE07 - Microsoft Excel 2007 for Economists

Catalog price of course and handbook

Locality	Course price ex VAT	Price of handbook ex VAT	Number IT points
Praha	4200 Kč	--	0 items
Brno	3600 Kč	--	0 items

Course dates

Course date		Course length	Locality	Price ex VAT	Handbook ex VAT	Speaker language
16.09.2010		2	GOPAS Praha	4200 Kč	included in course price
30.09.2010		2	GOPAS Praha	4200 Kč	included in course price
11.10.2010		2	GOPAS Praha	4200 Kč	included in course price
26.10.2010		2	GOPAS Praha	4200 Kč	included in course price
18.11.2010		2	GOPAS Praha	4200 Kč	included in course price
30.11.2010		2	GOPAS Praha	4200 Kč	included in course price
21.12.2010		2	GOPAS Praha	4200 Kč	included in course price
13.01.2011		2	GOPAS Praha	4200 Kč	included in course price
25.01.2011		2	GOPAS Praha	4200 Kč	included in course price
10.02.2011		2	GOPAS Praha	4200 Kč	included in course price
22.02.2011		2	GOPAS Praha	4200 Kč	included in course price
10.03.2011		2	GOPAS Praha	4200 Kč	included in course price
22.03.2011		2	GOPAS Praha	4200 Kč	included in course price
07.04.2011		2	GOPAS Praha	4200 Kč	included in course price
21.04.2011		2	GOPAS Praha	4200 Kč	included in course price
	23.09.2010	2	GOPAS Brno	3240 Kč	included in course price
19.10.2010		2	GOPAS Brno	3600 Kč	included in course price
15.11.2010		2	GOPAS Brno	3600 Kč	included in course price
09.12.2010		2	GOPAS Brno	3600 Kč	included in course price
10.01.2011		2	GOPAS Brno	3600 Kč	included in course price
10.02.2011		2	GOPAS Brno	3600 Kč	included in course price
03.03.2011		2	GOPAS Brno	3600 Kč	included in course price
29.03.2011		2	GOPAS Brno	3600 Kč	included in course price
28.04.2011		2	GOPAS Brno	3600 Kč	included in course price
16.09.2010		2	GOPAS Bratislava	140 EUR	included in course price
	20.09.2010	2	GOPAS Bratislava	126 EUR	included in course price
27.09.2010		2	GOPAS Bratislava	140 EUR	included in course price
12.10.2010		2	GOPAS Bratislava	140 EUR	included in course price
09.11.2010		2	GOPAS Bratislava	140 EUR	included in course price
14.12.2010		2	GOPAS Bratislava	140 EUR	included in course price
11.01.2011		2	GOPAS Bratislava	140 EUR	included in course price
08.02.2011		2	GOPAS Bratislava	140 EUR	included in course price
08.03.2011		2	GOPAS Bratislava	140 EUR	included in course price

If none of the offered dates suits you, please contact our customer service department on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).