Microsoft Excel Foundation

Course code: MEXCELFOU

This course is recommended for users, who need to learn quickly the basics of work with Microsoft Excel. We will teach beginning users to create, edit and print common documents. You learn how to create and format simple tables with calculations and graphs.

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: Upon request

Type: Virtual

Course duration: 2 days

Language: cz/sk

Price without VAT: 135 EUR

Register

Starting date: Upon request

Place : Praha

Type: In-person

Course duration: 2 days

Language: cz/sk

Price without VAT: 150 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
Upon request Virtual 2 days cz/sk 135 EUR Register
Upon request Praha In-person 2 days cz/sk 150 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course description

This course is recommended for users, who need to learn quickly the basics of work with Microsoft Excel. We will teach beginning users to create, edit and print common documents. You learn how to create and format simple tables with calculations and graphs.

Course structure

Basic terms in Microsoft Excel

  • Description of Microsoft excel environment
  • Ribbon FILE – save and open files
  • Workbook, sheet, cell and its address
  • Movement throughout cells, selection of cells
  • Cell content and its changes
  • Change of rows height and columns width
  • Copy of a cell content
  • Keyboard shortcuts for facilitation the work
  • Status help
  • Options Paste Special, Find and Replace

Tables formatting

  • Text formatting, format preview
  • Text alignment
  • Merge of cells and text wrap
  • Number format
  • Borders
  • Inserting and deleting cells, rows and columns
  • Hiding and unhiding rows and columns
  • Copying a format

Formulas

  • Basic mathematical operations
  • Formulas modifications
  • Quick check of formulas
  • Copying and moving formulas
  • Relative and absolute references of cells ($A$1)

Functions

  • Use of basic functions and its view in calculation line
  • Inserting function in a cell
  • Modifying formulas with functions

Charts

  • Automatic format of a chart – recommended charts
  • Basic types of charts
  • Creating and adjusting charts

Work with large tables

  • Basic terms
  • Freeze of panes
  • Sorting data according its value or format
  • Automatic filter

Print in Microsoft Excel

  • View
  • Setting margins, placement on a page
  • Print options
  • Print area
  • Repeating a header on every page
  • Advanced page appearance settings for print
ComGate payment gateway MasterCard Logo Visa logo