This is an online course on Advanced Excel. The course is suitable for those who have a basic understanding of computers and would want to get a working knowledge on a spreadsheet program which can help them in their job or if they are looking for a job, it will improve their prospects of getting a job.
This course is very useful for people who intend to work on a large amount of data and would want to use the data for taking the right kind of decisions. For e.g. jobs in accounting, finance, investment planning or those working on report generation for senior professionals.
The course focusses on the following and is not limited to just these points:
- Details of functions
- Relative and Absolute referencing
- Report generation (including column/pie chart)
- Conditional formatting and Data validation
- Printing
- Pivot tables and Pivot charts (one of the key concepts in excel)
- macros
- V lookup etc.