This course takes you to a high level of knowledge using financial topics available in Excel such as financial functions, auditing and charts.
Overview:
- Creating, maintaining, filtering and using subtotals in a List
- Recording, assigning and using macros
- Creating and using user defined functions
- Performing “What If” analyses
- Working with scenarios
- Querying a database
- Importing and exporting files and data
- Protecting data
- Pivot tables, reports and charts
- Other advanced business analysis tools