Course code: MSEX210« Back

Microsoft Excel 2010/2007 – In Practice

This course is assigned for users, who already work with Microsoft Excel on basic level. We will teach you to fully employ its possibilities and create documents with tables and graphs on a professional level. It is assumed that you already know Microsoft Excel on “Microsoft Excel - basic course” level.

This course is recommended to prepare for the ECDL certification Preparatory course for MOS certification
No terms found, contact our client service.

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 4 800 CZK included in course price 0
Brno2 4 200 CZK included in course price 0
Bratislava2 160,00 EUR included in course price 0

Who is the course for

This course is assigned for users with basic knowledge in Microsoft Excel.

What we teach you

You learn how to fully use Microsoft Excel application in practice.

Required skills

Microsoft Excel - basic course.

Teaching methods

Professional explanation with practical samples and examples.

Teaching materials

Gopas guide book for this course.

Course Outline

Advanced possibilities of copying

  • Generating of series
    • String (text) series
    • Numerical series
    • Date & time series
  • Formulas copying
  • Clipboard & Paste special options & alternatives
  • Best practices

Advanced cells formatting

  • Cells content protection
  • Format copying
  • Table style
  • Conditional formatting
  • Custom format
  • Comments

Creating formulas

  • Formulas rules
  • Operators
    • Arithmetical, String, Relation
    • Logical operations
  • Absolute & relative & mixed addressing  

Functions

  • Date & time functions
  • Logical functions
  • String (text) functions
  • Mathematical functions - rounding
  • Examples of different types of functions

Workbooks & worksheets

  • Protection of workbooks
  • Editing of several worksheets
  • Templates
  • Automatic saving

Databases and working with large tables

  • "Smart" Tables for automatic organization of datasets
  • Freezing of headers
  • Workbook windows arrangement
  • Windows splitting
  • Input validation
  • Sorting
  • Find, Replace, Go To
  • Header & Footer
  • Large tables printing options

Filters and working with lists

  • AutoFilter
  • Advanced filter

Built-in data tools

  • Text decomposition to columns
  • Duplicates removing
  • Outlining, Grouping, Subtotals,
  • Pivot tables
  • Consolidation of ranges

Formatting of charts

  • Chart types
  • Trendlines
  • Two-axis chart
  • Chart templates
  • Sparklines

For a deeper practicing we recomend the course Microsoft Excel - In practice workshop.

Příručka MS Excel 2010 - praktické využití [Cz/Cz]

Price:
included in course price
Příručka MS Excel 2010 - praktické využití [Cz/EN]

Price:
included in course price
Příručka MS Excel 2010 - praktické využití [EN/EN]

Price:
included in course price
Příručka MS Excel 2010 - praktické využitie [SK/SK]

Price:
included in course price
The prices are without VAT.