MENU
Introduction
CoursesCourses
MS Excel - for beginners
Interest in course

MS Excel - for beginners (MSE1)

This course designed for user who want to learn the basics of using powerful spreadsheet MS Excel. Participants will learn how to work with their data in the form of tables and use the powerful tools of the program.

The course is included in the following category: Kancelářské aplikaceMicrosoft OfficeMicrosoft Excel
Microsoft

Difficulty of the course: Beginner

Course duration: 2 days

Contents of the course:

  • Excel Introducing
    purpose and use, workspace, using
  • File
    Save, Open, Save As, type of Files
  • Working with data
    fill data, file, sheet, select cell, selection, Fill Series, Undo
  • Basic Calculation
    function, formula, using, summation, subtraction, multiplication, dividing, involution, evolution, percentage, average
  • Cell address
    relative address, absolut address, using
  • Copy and move
    using, copy or move data, copy or move calculations
  • Table editing
    How to edit numbers? (rules and using), How to edit text? (rules and using), Align data, (rules and using), Borders (rules and using), column width, rows height
  • Charts Graphs
    kind of charts, using, select data, How to create chart, size and chart position, chart editing
  • Objects
    purpose and using, WordArt (insert, edit), Online pictures (insert, edit), picture (insert, edit)
  • Page
    Page Setup (format, margins, orientation), Header and Footer (settings, fill), Fields (purpose, using, insert)
  • Sheets
    move, select, insert, delete, copy, move, rename, Tab color, Hide/Unhide sheet
  • Print
    printers (types, using) ,settings, Print Preview, print
  • Info
    other informations, information resources

Expected knowledge: User knowledge of Windows OS.

The price includes books in the value of: 100 CZK

Time schedule: 9:00 - 17:00

Jednodenní školení 14.3. bude obsahově odpovídat druhé polovině 2denního kurzu

Course dates:

03.10. 04.10.2017 Praha
3 400 CZK (without VAT)
10.10. 11.10.2017 Bratislava
140 EUR (without VAT)
12.10. 13.10.2017 Brno
3 400 CZK (without VAT)
23.10. 24.10.2017 Praha 3 400 CZK (without VAT) Order
02.11. 03.11.2017 Bratislava 140 EUR (without VAT) Order
08.11. 09.11.2017 Brno 3 400 CZK (without VAT) Order
14.11. 15.11.2017 Praha 3 400 CZK (without VAT) Order
20.11. 21.11.2017 Bratislava 140 EUR (without VAT) Order
22.11. 23.11.2017 Košice 140 EUR (without VAT) Order
23.11. 24.11.2017 Ostrava 3 400 CZK (without VAT) Order
04.12. 05.12.2017 Brno 3 400 CZK (without VAT) Order
11.12. 12.12.2017 Bratislava 140 EUR (without VAT) Order
12.12. 13.12.2017 Praha 3 400 CZK (without VAT) Order
14.12. 15.12.2017 Ostrava 3 400 CZK (without VAT) Order
18.12. 19.12.2017 Košice 140 EUR (without VAT) Order
27.12. 28.12.2017 Brno 3 400 CZK (without VAT) Order
03.01. 04.01.2018 Ostrava 3 400 CZK (without VAT) Order
08.01. 09.01.2018 Košice 140 EUR (without VAT) Order
09.01. 10.01.2018 Bratislava 140 EUR (without VAT) Order
10.01. 11.01.2018 Praha 3 400 CZK (without VAT) Order
16.01. 17.01.2018 Brno 3 400 CZK (without VAT) Order
30.01. 31.01.2018 Bratislava 140 EUR (without VAT) Order

Recommended previous and follow-up courses: