Trainer: Abid Maqsood

Mode: Recorded

Duration: 32 Credit Hours

Fee: PKR. 5,000

This training is designed to help learners build strong, practical data analytics skills using Microsoft Excel and related tools. The focus is on real-world reporting, dashboard creation, automation, and cloud-based analytics, along with guidance on freelancing through Upwork.

The training is delivered through recorded sessions and is supported with mentorship to help learners understand concepts, solve problems, and apply skills confidently.

What This Training Includes

Microsoft Excel Learn how to create professional reports and interactive dashboards used in real business environments. The training covers advanced formulas, PivotTables, and data visualisation techniques for effective reporting and decision-making.

You will also learn to automate repetitive tasks with Macros, improving efficiency. Power Pivot is included to help you work with large datasets, build data models, and perform advanced calculations. Power Query is covered for data extraction, transformation, and cleaning from multiple data sources.

Google Sheets Understand how to perform data analysis in a cloud-based environment. Learn formulas, data validation, collaboration features, and dashboard creation using Google Sheets, making it ideal for remote teams and online reporting.

Upwork Get practical guidance on freelancing fundamentals, including profile optimization, proposal writing, client communication, and how to find and win data analytics projects using Excel and Google Sheets.

By the end of this training, learners will be able to analyze data efficiently, automate workflows, build professional dashboards, and confidently offer their skills for jobs or freelance projects.