Excel Professional Assignments — Office Automation (2025)
30 advanced assignments for Office Automation students. Instructions, formulas & dashboards included.
Content source: PICT assignments document | Computer Short Courses in Lahore
Assignments (Excel Course Assignment # 1)
General instructions:
You must create separate sheets: Raw Data, Cleaned Data, Calculations and Report/Dashboard. Use formulas: VLOOKUP/INDEX/MATCH, IF/IFS, SUMIFS, COUNTIFS, TEXT functions, pivot tables, and conditional formatting. Save and submit as StudentName_PICT_2025_AssignmentNo.xlsx. (See document for full rules.)
Assignment details & tools
Security & Server Management
PICT is one of the best organization offer Security & Server Management