EXCL-K

Microsoft Excel intermediate

Intermediate level spreadsheet training for those who already have a solid foundation
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.

Suggested For

The course is designed for users with a basic knowledge of Excel, who will be expected to use Excel spreadsheets on a daily basis, and to create and format more complex spreadsheets, apply common functions and formulas, and create and format charts.

Outline

Overview of Excel basics
Series

  • Create arithmetic and geometric series
  • Date and time series
  • Using ready-to-use text series
  • Creating custom series, Modifying a custom list

References

  • Relative and absolute reference
  • Mixed reference

Domain names

  • Domain name types and creation
  • Using domain names as references in formulas

Data tables

  • Creating data tables
  • Parts of data tables
  • Data table summary row
  • Specificities of data tables (new reference types, automatic formulas, format preservation)
  • Calculations in data tables
  • Filtering data tables

Logical functions

  • IF, IFS, AND, OR, NOT, SWITCH functions
  • SUM (SUMIF), SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MINIF (MINIFS), MAXIF (MAXIFS), and IFERROR functions

Search functions

  • functions FKERES (VLOOKUP), KERES (LOOKUP), HOL.VAN (MATCH), INDEX and XKERES (XLOOKUP)

Text functions

  • TRIM and CLEAN functions
  • FIND, SEARCH functions
  • Text replacement functions: REPLACE, SUBSTITUTE
  • LEN, LEFT, RIGHT, MID functions
  • TEXTJOIN, CONCAT
  • REPT

Date and time management functions

  • Enter and format date and time data
  • TODAY, NOW, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
  • WEEKNUM, WEEKDAY and ISO.WEEK.DAY functions
  • DATE, DATEVALUE, TIME, TIMEVALUE, functions

Charts

  • Diagram types and their use
    • <liOther types of diagrams (Tree diagram, Multi-level ring diagram, Waterfall, Histogram, Pareto, Box plot, Funnel)
  • Diagram drawing and formatting
  • Editing combined diagrams
  • Diagram tools, Diagram components, Diagram style, Using diagram filter buttons
  • Recommended chart function to use: pivot basics

Charting basics

  • Use the Pivot Pivot Pivot Pivot Pivot Pivot
  • Creating a statement chart

    Sparklines in cells

    • Insert, edit, delete

    Conditional formatting

    • Data analysis with conditional formatting
    • Data bars, icons, colour scale in cells
    • Use quick analysis buttons
    • Conditional formatting window
    • Writing custom rules
    • Outline (PDF)

    Prerequisites

    To participate in the course, you must have successfully completed our Microsoft Excel Beginner course or have equivalent practical experience.