Much more than 4 operations on tables, Excel…
Participants will learn the operations that can be done with Excel, shortcuts, tips and tricks of the application through a scenario.
TARGET AUDIENCE
Every employee who has numeric data in his job
DURATION
2 days
CONTENT
- Excel Application (Menu/Ribbon/Clipboard)
- Special Paste
- Text Fit
- Special Character Issues in Pasting
- Conditional formatting
- Filtering/Sorting
- PivotTable
- Data Extraction with Formula: VLOOKUP/INDEX/MATCH
- Text Formulas: MID/UPPER/TRIM/LEFT/RIGHT/LEN
- Conditional Formulas: COUNTIFS/SUMIFS
- Text Splitting: TEXT TO COLUMNS
- Avoiding Multiplexes: REMOVE DUPLICATES
- Conditional Text Input: DATA VALIDATION
- Visualizing Relationships in Data