Intermediate Excel Training

Intermediate excel navigation includes (but not limited to):

- Text to column

- Left formula

- Right formula

- Concatenating sets of data

- Range Names and drop-down lists

- Graphs

- Date function

- Time function

- Sorting and managing big sets of data

- Data validation

- Financial functions (pv, fv etc.)

- VLOOKUP’s

- XLOOKUP's

- Pivot tables

- Conditional formatting

- IF/NESTED IFS formula

- SUMIF/SUMIFS formula

 

Prerequisites:

To ensure success, delegates should have completed our Basic Excel course.

​

* The training takes approximately 8 hours.