Course Outline
- Basic Excel Calculations
- absolute and relative references
- Name Manager tools
- paste special
- find formula / Go to Special
- name Manager importance in making automated spreadsheets
- if, If/ and, If / OR and nested if functions
- essential formatting
- conditional formatting
- data validation
- sort and filter
- Table formation
- charts and graphs
- Linear Regression
- V Look up / H LOOKUP / Match / Index