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

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

Course dates:

No dates are listed.

Recommended previous and follow-up courses: