EXCL-A

Microsoft Excel beginner

Basic user-level spreadsheet training
Form of participation
Form of training
Length of training
  • 2 day (2×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates

Training price

from 
65 000 Ft
+ VAT/person
Please choose the date and form of participation!
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Description

The training will provide effective, usable knowledge for people who are responsible for using Excel spreadsheets on a daily basis, creating simple spreadsheets, creating, formatting and printing worksheets.

Suggested For

The course is specifically designed for beginners who have some previous Windows experience but have never used a spreadsheet or have minimal knowledge of one.

Outline

The Excel interface

  • Ribbon, dialog boxes
  • Customize the Ribbon
  • Using and customizing the Quick Start Toolbar
  • The File menu (Backstage view)
  • Screen views (Sheet Layout view)
  • Create, save and open Excel workbooks

Excel parameters (number of rows, columns, colours, etc.)

  • Excel parameters (number of rows, columns, colours, etc.)
  • Create new document, file formats (.xlsx, file formats of previous versions)
  • Use of new templates (own template for cash flow and stock market analysis, template for displaying calendar background knowledge)
  • Save and open
  • Save as PDF, XPS

Data entry into workbook

  • Data types (number, date, time, formula, function, text)
  • Data entry, basic database creation
  • Automatic completion
  • Data entry with simple sequences
  • Flash filling

Navigation and selection

  • Navigation with mouse and keyboard
  • Mouse and keyboard selection
  • Common keyboard shortcuts and their use

Editing a dataset

  • Editing cells
  • Finding and replacing data
  • Setting finger height and column width
  • Insert rows/columns
  • Delete rows/columns
  • Move and copy data
  • Guided pasting

Formatting cells

  • Cell formats (character, alignment, border and pattern)
  • Formatting with collections
  • Number formats

Basics of formula writing and function use

  • Basics of formula writing, operation symbols, order of operation execution
  • Cell and range references
  • Basics of function use
  • Scalable Editorial Alphabet, Formula Completion
  • Copy formulas, functions
  • SUM, AVERAGE, MAX, MIN, SMALL, LARGE, COUNT, COUNTA and IF functions

Worksheet management

  • Inserting, deleting, renaming and colouring tabs
  • Moving and copying pages

Printing

  • Page settings
  • Print command in the File menu
  • Printing options
Outline (PDF)

Prerequisites

Computer and Windows skills and practice. Completion of or knowledge of the Effective Computer Use course.