Trainer: Abid Maqsood & Abdul Waheed

Duration: 32 Credit Hours

Mode: Recorded

Objectives of this Training

• Understand the fundamentals of data analytics and analytical thinking.
• Learn Microsoft Excel from basic to advanced levels.
• Perform data entry, formatting, sorting, filtering, and data validation.
• Master formulas, functions, lookup functions, and advanced Excel techniques.
• Learn data cleaning, transformation, and reporting using Power Query.
• Create interactive Excel dashboards, PivotTables, and PivotCharts.
• Learn Google Sheets formulas, functions, dashboards, and reporting automation.
• Understand Upwork profile creation, freelancing, proposal writing, and client communication.

Tools Used in this Training

• Microsoft Excel
• Advanced Excel Formulas and Functions
• Power Query
• PivotTables and PivotCharts
• Google Sheets
• QUERY, FILTER, and ARRAYFORMULA
• Excel and Google Sheets Dashboards
• Upwork

Outcomes of this Training

• Analyze and manage datasets using Excel and Google Sheets.
• Clean, transform, and organize raw data.
• Create advanced spreadsheets and interactive dashboards.
• Develop professional sales and financial reports.
• Build automated reporting solutions.
• Create a professional Upwork profile and freelancing portfolio.
• Understand how to approach clients and apply for data analytics projects.