Advanced Excel course enables students to learn Excel in depth. You will be able to Create Lists, Build Lists, Create Macros, Group Data, Outline Data, use short cuts for operations, also use Analysis tool pack, Analysis by Goal seek and pivot tables. Students will be taught and asked to implement them practically, by which they are able to learn more and perform better.
Contents :
| Workbook | Pivot Table |
| Worksheets | Pivot table and Charts |
| Format Cells Formatting | Slicers |
| Find & Select | Data Validation |
| Templates | Functions – Count and sum |
| Data Validation | Vlookup |
| Keyboard Shortcuts | H lookup |
| if Statement | |
| Share | Sum if |
| Conditional formatting | What if analysis |