Course Content
Course Contents:
- Personalising Excel
- Understanding and Using Basic Functions
- Text Functions
- Arithmetic Functions
- Proofing and Formatting
- Protecting Excel- Excel Security
- Printing Workbooks
- Advance Paste Special Techniques
- Time and Date Functions
- Filtering and Sorting
- What-If Analysis
- Data Validation
- Logical Analysis
- Lookup Functions
- Pivot Tables
- Slicers and Charts
- Introduction to VBA
- Variables in VBA
- Input box and Message Box Functions
- Report Card Management
- Attendance Sheet Management
- Salary Management
- Bank Transactions Management
- Stock Management
- Profit /Loss Management