Microsoft Excel – Advanced Course

MEXCELP

Two-day course is intended for all common users who have already worked with MS Office Excel application and would like to extend their basic knowledge. The course focuses on the most common and the most useful functions, which are generally used while working with MS Office Excel.

Accredited course for Continuing Education of Pedagogical Staff

Course length: 2 days (8:30 - 16:00)

Dates

04/11/2024 - 04/12/2024 Prague cs Free date Guaranteed date
4 400 CZK Add to cart
06/18/2024 - 06/19/2024 Prague cs Free date
4 400 CZK Add to cart

PDF to download Expand allCollapse all

  • Students will be able to

    • Using advanced formulas and functions
    • Using formulas with values that match your conditions (functions: countif, sumif)
    • Effectively insert the copied values according to given criterias
    • Organise, filter and sort large data
    • Create reports and statements, aggregate data for the relevant period or category and print them
  • Course requirements

  • This course is intended for

    • The course is intended for all common users who have already worked with MS Office Excel application and would like to extend their basic knowledge.
    • Methodology of education
    • Tutor’s explanation is accompanied by several practical examples, individual and group exercises on PC
  • Literature

    The workbook in English language is included.

  • Hardware

    Spacious classrooms are equipped with premium computers with the access to the Internet, the wireless access included.

  • Syllabus

    Chapter 1: Advanced formatting

    • Keep the source formatting
    • Deleting format
    • Conditional formatting
    • Custom format

    Chapter 2: Protecting workbook and worksheet

    • Cell protection
    • Protect sheet and protect workbook
    • Protecting the file by using password, encryption

    Chapter 3: Advanced copy and paste options

    • Copy and paste options
    • Fill series using AutoFill
    • Possibilities of cooperation between MS Word and MS Excel

    Chapter 4: Applying formulas in Excel

    • Principles of creating and using formulas
    • Relative and absolute references
    • How to quickly find the function, how to revise and edit a formula

    Chapter 5: The most used functions

    • Logic functions
    • Text functions
    • Date and time functions
    • Math functions
    • Conditional calculations

    Chapter 6: Analysing and organising data

    • Freeze panes, arrange and split windows
    • Data validation
    • Sorting
    • Filtering
    • Creating an outline, group and ungroup rows and columns
    • Converting text to a table
    • Printing large data

    Chapter 7: Creating reports and statements using pivot table

    • Principles and using of pivot table
    • Creating and changing pivot table
    • Creating and changing pivot chart

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.