Advanced MS Excel & Google Sheet

Program Overview

This professional course on Advanced MS Excel & Google Sheets is designed to build strong data management, analysis, and reporting skills.The course is ideal for professionals, students, and entrepreneurs who want to enhance their efficiency, accuracy, and decision-making through advanced spreadsheet skills. With live instruction, practical examples, and guided exercises, learners will gain the confidence to tackle complex data tasks with ease.

Course Duration: 2 Months
Total Classes:15 sessions

Course Content

Through 15 live interactive classes, participants will learn practical tools and techniques used in real-world business, research, and organizational settings.This course provides hands-on training in Excel and Google Sheets, covering both fundamental and advanced features. Participants will master formulas, data visualization, automation, and collaboration techniques to streamline work and make informed decisions.

Interface, navigation & customization
Data entry, formatting & shortcuts
Differences & integration between Excel and Google Sheets

Logical, text, date & lookup functions
Nested formulas & error handling
Real-life problem-solving with formulas

Sorting, filtering & conditional formatting
Data validation & drop-down lists
Importing & cleaning datasets

Creating professional charts & dashboards
Pivot tables & pivot charts
Interactive reports for decision-making

Macros & automation in Excel
Power Query basics
Google Sheets automation with Apps Script

Sharing, permissions & real-time collaboration in Google Sheets
Integration with Google Forms & other apps
Case studies: business, finance, and project reporting

Exclusive Features of This Course

Course Fee: 4500

Payment Deatils:

The Bank Details are given below:

Bank Name: Dutch Bangla Bank PLC

Account Name: I E C B
Account Number: 3211100328585
Branch Name: Rabindra Sarani
Routing Number: 090261433
Bkash Number: 01830083091

Industry Expert Trainers

Our faculty members are not only experts in logistics and supply chain management but also have experience

WhatsApp-Image-2025-08-03-at-12.45.40-AM-1-237x300

Shajibul Hasan

View Details

Our Corporate Clients

Assessment Processes:

Each course assessment mark is 100.
The assessment for each course consists of midterm and final term examinations
The examination follows a Multiple-Choice Question (MCQ) and Short Answer Question.
Case Study
Assignment
Passing Score: To complete PGDSCM, participants must obtain at least 60% marks in each course and average marks at least 70%.