Two weeks
Monday – Friday
Monday – Friday
300,000/=
Practical and Theory Exams
Prerequisite:
-Willingness to Learn
-Must know English Language
Overview:
Microsoft Office Excel is a spreadsheet application that is part of the Microsoft Office suite. It is widely used for data organization, analysis, and visualization. Excel is available for both Windows and Mac, and it offers a range of features for managing numerical data, performing calculations, and creating reports. Here’s an overview of the basic features of Excel.
Course outline
- Templates, Paste special options
- Pivot tables & charts,
- Hyperlinks, Linking & Embedding
- Importing text files
- Passwords & Security issues
- Sorting & Filtering data
- Advance Filtering data
- Data Validation
- Tracking and Reviewing changes
- Scenarios
- Input tables
- Auditing
- Macros
- Goal seek
- Financial Function (PMV)
- Lookup Function
-H & V Lookup Functions (Three way) - Database Functions.
