Excel 2000/ 2002/ 2003 (basic)

The topics of this 4-hours instructor-led course include:

• Structure of Excel workbook, settings of main menu commands and toolbars.
• Correct and quick data input into a cell.
• Data formatting.
• Cell address and setting of cell name (cell diapason)
• Calculations in a table, copying and moving of formulas.
• Absolute and relative references.
• Creating and editing of diagrams.
• Organization of working area for working with big tables.
• Hiding of table elements.
• Table formatting and printing.

Excel 2000/ 2002/ 2003 (advanced)

The topics of this 8-hours instructor-led course include:

• Subtotals
• Filters
• Pivot tables
• Table
• Goal seek
• Solver
• Scenarios
• Searching and replacing functions
• Quick transition possibility
• Unauthorized access security tool for records, formulas, objects, scenarios, files
• HTML export feature with static data support
• Templates
• Simple macros creation and interface tuning

EC “Networking Technologies”™ delivers author's trainings on using Microsoft Office applications:

EC “Networking Technologies”™ started to deliver trainings in 1997. Since then several thousands of leading Ukrainian and international companies' members have been trained. Among these companies are Procter&Gamble Ukraine, TetraPak Ukraine, Metro Cash&Carry, Gillette Ukraine and others.
All trainings can be delivered in three languages: Russian, Ukrainian and English.
The training plan is adapted to the requirements of the international certification program MOS (Microsoft Office Specialist).
All trainings are delivered by the certified MOS trainers.

Microsoft Office Word

Microsoft Office Excel

Microsoft Office PowerPoint

Microsoft Office Outlook

Microsoft Office Access

Microsoft Office Project

Internet Explorer