MS Excel - basic level

    Czas trwania
    Godzina rozpoczęcia
    Stopień trudności

      MS Excel - basic level

      Remote and stationary training options

      About training

      The training is intended for people who are just starting to work with MS Excel

      View the training programme

      What will you gain from the training?

      Training objectives and skills

      After completing the course, participants will know how to:

      • perform basic operations on copying and pasting data
      • protect cells, sheets and workbooks
      • use data filter and subtotals
      • use advanced filter
      • perform operations on dates and hours
      • use text conversion functions
      • use logical functions with multiplied conditions
      • insert data from other applications
      Is this training for you?

      Audience profile

      The training is intended for people who are just starting to work with MS Excel.


      Basic knowledge of the Windows environment is required from the training participants



      • 2 days, 16 hours
      Detailed training program

      Detailed training program

      Data management

      • Sheets management (naming, copying, colour change)
      • Efficient data entering
      • Efficient selecting
      • Go To and Go To Special tools
      • Sorting data
      • Custom lists
      • Autofilter and Advanced filter
      • Advanced operations on copying and pasting data

      Adjustment of the working environment

      • Hotkeys, facilities
      • Create and modify toolbars
      • Excel Options (autosave, input, calculations, etc.)


      • Cell styles
      • Format painter
      • Number formats


      • Subtotals function and subtotal tool
      • Statistical functions (average, maximum, minimum and quantity)
      • Text conversion functions
      • Date and time functions
      • Sheet inspection

      Tables and list management

      • Using names of cells and ranges
      • Format as Table

      Conditional functions

      • IF
      • Logical functions
      • Informational functions
      • Avoiding errors
      • Other conditional functions (countif, sumif  and others)
      • Creation of complex / multiple formulas

      Consolidation of data

      • Getting external data (CSV, TXT, Access)
      • Data consolidation functions and tools


      • Collaboration
      • Tracking changes
      • Comments


      • Protect worksheet and workbook
      • Secure and encrypt files

      Training delivery method

      The training is carried out in the form of theoretical part in the form of mini lectures and the practical part in the form of computer exercises.


      Podobne tematy

      Customer care

      Sylwester Woźniak
      Sylwester Woźniak