When one works on excel, it is implied that certain basics are taken care of for everything else, there is an Advanced Excel course.
- Get used to advanced formulas and functions that seamlessly ease-out the complex excel workings.
- A career in Research, Investment Banking gets a further lift with an accelerated knowledge of excel.
- Unmatched proficiency in data mining makes advanced excel an absolute go-to.
Course Details
- Setup a workbook
- Work with data and Excel tables
- Perform calculation on data
- Change workbook appearance
- Manage worksheet data
- Reorder and summarize data
- Combine data from multiple sources
- Analyze Alternative data sets
- Create charts & graphics
- Create dynamic worksheet by using Pivot Tables
- Print worksheet and charts
- Automate repetitive tasks by using macros
- Work with other Microsoft Office apps
- Collaborate with colleagues
- Perform business intelligence analysis
- Create forecasts and visualizations