Master key Excel tools in 2 days: formulas, tables, charts, pivot tables. Practical training with a Microsoft Certified Trainer with over 20 years of experience. No “dry” theory - only useful techniques, proven methods and work with real examples.
Entering and editing data (text, numbers, dates)
Autocomplete and autocomplete lists
Cell format: text, number, date
Adding, deleting, copying sheet elements
Custom insert with dynamic preview
Hotkeys to speed up work
Move and copy sheets within a workbook and between files
Grouping sheets and working with grouped sheets
View two sheets of the same book at the same time
Synchronous and asynchronous viewing of two books
Entering and editing formulas
Relative, absolute, and mixed references
Function Wizard
Mathematical, statistical, logical functions, substitution functions, text operations
Examples: SUM, SUMPRODUCT, SUMPRODUCT, AND, OR, SUMPRODUCT
Combining functions into complex formulas (nested functions)
Eliminating errors in formulas
Formulas with references to other sheets and workbooks
Working with connections
Data validation (drop-down lists)
Sorting and filtering (features for different data types)
Calculations on filtered data
Creating and formatting tables
Formulas in tables, table names, and column pointers
Subtotals (simple and nested)