Copying, moving workbook cells.
Paste Special (Transpose, Value, Drawing, etc.) Use Paste Special to calculate without formulas.
Find and replace, highlighting groups of cells.
Auto-completion, using a drop-down list to select values.
Autocomplete, progressions.
Lists, creating custom lists.
Notes in cells (inserting, editing, displaying, printing).
Working with hyperlinks (hyperlinks to files, web pages and places in the document).

Standard conditional formatting functionality. Highlighting repeated values in a table.
Use visualization to display histograms, various icons, and color scales in cells.
Conditional Formatting Rules Manager. Editing formatting rules.
Use formulas and functions to create conditional formatting rules.
Find cells with conditional formatting.

Organizing your workbook. Working with sheets: renaming, inserting, moving and copying, deleting.
Leaf structure. Simultaneous data entry on multiple sheets.

Creation of elementary formulas.
Copying formulas.
Types of errors in formulas, correction of formulas.
Relative, absolute, mixed links.
Using data from other sheets in formulas - remote links. Three-dimensional formulas.
Tracing formulas. Influencing and dependent cells.

Function Wizard.
Autosum (SUM, AVERAGE, COUNT, MIN, MAX).
Mathematical and statistical functions. Summation functions for one and several criteria (SUMMIF, SUMIFS). Counting functions based on one or more criteria (COUNTIF, COUNTIFS). Averaging functions (AVERAGEIF, AVERAGEIFS).
Text functions (combining data - &, CONCATENATE. Functions PSTR, DLST, bringing information into the correct form: SPACE).
Date processing functions: calculation of length of service, age, operating period of RAZNDAT, calculation of the number of working days in the time period NETWORKDAYS.
Logical functions (IF, OR, AND, IFERROR).
Nested functions.

Comfortable presentation of data on the screen. Freezing areas (rows, columns).
Preparing a workbook for printing. Page Layout and Page modes.
Setting page parameters: setting margins, changing page orientation, printing continuous rows (columns), printing a grid, headings. Page breaks. Print area.
Print the document. Print part of the table. Printing diagrams.

Sorting data. Simple and multi-level data sorting. Sorting by color. Sorting options.
Data filtering. Selection by value, by format, by condition. Numeric, text, date filters. Selection of the largest and smallest values. Filtering data by the contents of the active cell.

Subtotal tool.
Grouping and structure. Grouping by columns and rows. Working with control buttons. Multi-level grouping of information.
Data consolidation - combining data from several tables into one.
Removing duplicates.
Text by columns. Master of text parsing.
Automatic formatting of tables. Smart Excel table: creation, editing, formatting.

IT Courses in Kyiv