Module 1: Creating macros
- Introducing macros
- Creating macros
- Relative and absolute macros
- Running and editing a macro
- Assigning shortcuts
- Macro security
Module 2: Collaborating with others
- Protecting data, workbook structure and files
- Checking for collaboration issues
- Marking workbooks as final
Module 3: PivotTables
- What is a PivotTable?
- Creating and modifying PivotTables
- Calculations in PivotTables
- Grouping fields
- Slicers and Timelines
- Creating PivotCharts
- PivotTables and related sources
Module 4: Array formulas
- What is an array?
- Array formulas
- Array functions
- Single and multiple cell arrays
Module 5: Further lookup and reference functions
- VLOOKUP and HLOOKUP
- GETPIVOTDATA
- MATCH and INDEX
- XLOOKUP (Excel 365 only)
Module 6: Analysing data
- Input data tables
- Worksheet scenarios
- Goal Seek
- Consolidating data
- Linking to external workbooks
Module 7: Data validation
- Setting up data validation
- Message prompts and alerts
- Conditional data validation
- Data validation errors
Module 8: Importing data
- Importing delimited files
- Importing data with a web query
- Refreshing data
DANONE
We really loved the trainer. I had hesitations on online trainings, but it really went well. I'd love to attend another online training with Bilginc