Module 1: Formula tools and techniques
- Quick analysis.
- Absolute and mixed referencing.
- Working with range names.
- Linking to other worksheets.
- Linking to external workbooks.
Module 2: Popular Excel functions
- Understanding functions.
- Criteria-based functions.
- Logical functions.
- Lookup and reference functions.
- Dynamic array functions.
Module 3: Working with data lists
- Flash fill.
- Advanced sorting.
- Summarising with subtotals.
- Advanced filters.
Module 4: Mastering Excel tables
- Introducing tables.
- Creating and managing tables.
- Calculation and totals in tables.
- Formatting a table.
- Further table tools.
Module 5: Creating Visuals
- Understanding charts
- Creating a chart
- Resizing and moving
- Managing a chart
- Working with chart elements
- Formatting charts
- Working with chart templates
- Creating maps from Geographic data
- Creating Infographics with Excel add-ins
- Analyse data with sparklines
Module 6: Conditional formatting
- Applying and managing conditional formatting.
- Creating custom conditional formatting.
- Sorting and filtering by colour.
Arçelik
Rated the training 5 stars.
Arçelik
Rated the training 5 stars.
Arçelik
Rated the training 5 stars.
Arçelik
Rated the training 5 stars.
Arçelik
Rated the training 5 stars.
Arçelik
Rated the training 5 stars.
Arçelik
Rated the training 5 stars.
Arçelik
Rated the training 5 stars.
Arçelik
Rated the training 5 stars.
Arçelik
Rated the training 5 stars.
ACTECON
Rated the training 5 stars.
ICBC Turkey
Rated the training 5 stars.
ICBC Turkey
Rated the training 5 stars.
ICBC Turkey
Rated the training 5 stars.