The goal of this course, assuming you are comfortable with excel basics, is to learn how to organize and manage your data on a higher level. We will learn how to customize toolbars, charts, create custom lists and custom number formats. We also cover conditional formatting, advanced filtering, hiding and grouping your data and the essentials to manipulating your data, including but not limited to COUNTIF, SUMIF, logical (AND, OR, IF), lookup (VLOOKUP, HLOOKUP) functions, and a quick look at pivot tables Tematika Customizing Menus and Toolbars "Series and custom lists Custom number format" "References (Refreshing) Define Names" "Data validation I. Conditional formatting I. (based on cell value)" Recording Macro, assigning macro to objects or icons Mathematical and statistical functions SUMIF, COUNTIF, ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, ABS, SUMPRODUCT, SUBTOTAL, MEDIAN, MODE Date and time functions YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATE "Logical functions AND, OR, IF Lookup and reference function LOOKUP, VLOOKUP, HLOOKUP" Text functions PROPER, UPPER, LOWER, LEFT, RIGHT, MID, FIND, SEARCH, CONCATENATE, LEN, TRIM, VALUE "Group and Outline Subtotal and Consolidate Pivot Basics" Create list   Bővebb információt honlapunkon olvashat: http://www.samling.hu/controlling_excel_english