Professional Training on MS Excel

Training Contents

course detail

Trainer

Saikat Biswangri
Excel Trainer, Skill Development Cell
Ex-President of DEC - D Engineers' ClubAssociate Partner - ACCOUNTAXAccounts Manager of ARDJAS GroupIncome Tax Lawyer (ITP)Member of The Chittagong Taxes Bar Association (CTBA)
Course Duration: 10 Weeks
Number of Classes: 10
Level: Basic to Advanced
Language: Bangla and English
Training Mode: Offline

Course Fee

৳ 0
৳ 1000

★ The price for Skills Bangladesh ★

  • info@skilldevelopmentcell.com
  • 4th Floor, Gausia Market, Beside Dewanhat Fire Service, Agrabad, Chattogram
ENROLL NOW

objectives

Maximize your productivity with MS Excel’s best tools, functions, and shortcuts. Designed for students, job seekers, and working professionals, this 100% practical, project-based course takes you step-by-step from basic functions to advanced analytical mastery to make you the go-to Excel expert in your workplace.

Nearly 70% of Excel users utilize only 20% of the software’s full capabilities. Our Professional Training on MS Excel bridges that gap by taking you on a structured journey from basic data handling to advanced analytical workflows.

Conducted offline at our Chattogram venue, this 10 Weeks intensive course is built around 100% practical project work and real-world business scenarios. Led by industry expert Saikat Biswangri, you will master dynamic formulas, efficient data visualization, and time-saving automation shortcuts. By the end of this course, you will be equipped to handle complex workplace data tasks faster and easier than ever.

BENEFIT OF THIS COURSE

  • Master the 80% of Excel features left untouched by average users
  • Streamline daily tasks and automate repetitive manual workflows
  • Learn step-by-step through 100% practical, real-world project work
  • Boost workplace productivity and become your team's go-to Excel expert
  • Gain hands-on guidance from an experienced financial and tax professional

Pre-Requirements

  • Basic computer operating skills (e.g., turning on/off PC, opening/closing software, copy/paste operations)
  • MS Excel installed on your laptop (Excel 2013, 2016, 2019, or Office 365 recommended)
  • Attendees must bring their own laptop for offline/venue-based classes.

COURSE MODULE

Class Duration:3 Hours

Getting Familiar With MS Excel

  • Getting Familiar With MS Excel Interface & Its Common Options:
    • Customize Quick Access Toolbar
    • Discussion About Backstage View
    • Customize Ribbon
    • How To Add Developer Tab
    • Managing Worksheets: Hide, Unhide, Insert, Delete, Color
    • Sheet Move or Copy & Rename
    • Inserting & Hiding Columns & Rows
    • Adjusting Row Hight & Columns Width
    • Name Box & Formula Bar
    • Fill & Advanced Autofill
    • Create & Manage Hyperlink
    • Uses of Format Painter
    • Basic Calculation (Addition, Subtraction, Multiplication & Division)
    • Change Workbook View
    • Create & Manage Custom View
  • Practice With Font Group:
    • Professional Font Size
    • How To Maintain Fill Color & Text Color
    • Increase & Decrease Indent
    • Customizing Border
    • Strikethrough, Superscript & Subscrip
  • Practice With Alignment Group:
    • Horizontal & Vertical Alignment
    • Text Control: Wrap Text, Shrink To Fit, Merge Cells
    • Text Orientation
  • Practice With Number Group:
    • Number Format
    • Comma Style And Increase & Decrease Decimal
    • Currency, Text, Date & Time
  • Preparing Invoice

Class Duration:3 Hours

  • Discuss & Practice With Insert Tab
    • Insert & Edit Pictures
    • Insert Shapes
    • Insert SmartArt
    • Insert Text Box
    • Insert Equation & Symbol
    • Table & Chart (Basic Part)
  • Page Setup & Printing A Worksheet Smartly:
    • How To Print Large Worksheet Professionally
    • Managing Page Margins & Orientation : Top, Bottom, Left & Right
    • Managing Print Titles & Gridlines : Rows To Be Printed At Top On Each Page
    • Setting Page Number
    • Printing A Specific Area Of A Worksheet
    • Customizing Header & Footer
    • Managing Page Break
  • Necessary Functions & Formulas (Part 01):
    • Mathematical Function : Sum, Average, Min, Max, Variance
    • Text Function : Left, Right, Mid, Lower, Upper, Proper, Trim, Concatenate, Len, Value
  • Viewing Data On Worksheet:
    • Showing – Hiding The Screen Objects
    • Freeze Top Row & First Column
    • Freeze & Unfreeze Pane While Scrolling
  • Entering Data In Cells & Sheets:
    • Paste Specials Options
    • Go To Special Options
    • Relative Cell Reference
    • Absolute Cell Reference
    • Mixed / Partial Relative & Absolute Cell Reference

Class Duration:3 Hours

  • Necessary Functions & Formulas (Part 02):
    • Logical Functions : If Condition (Excluding & Including Else), Nested If Formula
  • Formula Auditing & Show Formula
  • How To Prepare & Maintain A Salary Sheet
  • Data Sorting & Filtering:
    • Data Sorting With Single & Multiple Criteria Respectively
    • Sort By Month or Day Name
    • Data Sort By Color
    • Row & Column Wise Sort
    • Data Filtering : Single & Multiple Criteria
    • Data Filtering By Color
    • Customized Filtering : Text Values, Number Values
    • Clear Filtered Data By One Click
  • Conditional Formatting:
    • Single & Multiple Conditional Formatting
    • Highlighting Top Or Bottom Values
    • Highlighting Cells Rules
    • Data Bar Type Conditional Formatting with Gradient & Solid Fill
    • Color Scale Conditional Formatting
    • Icon Set Conditional Formatting
    • Customizing Icon Set
    • Clearing The Conditional Formatting

Class Duration:3 Hours

  • Preparing Result Sheet Using If Condition
  • Necessary Functions & Formulas (Part 03):
    • Lookup Functions: VLOOKUP, Hloookup, Match, Index Function, Combination of Index & Match Function.
    • Date & Time Functions: Day, Month, Year, Now, Today, Weekday, Edate, Dated If, Days360, Network days.
    • Logical, Financial & Statistical Function: And, Or, Not, IS, Sum If, Count If, Count A, Count Blank, PMT Function.

Class Duration:3 Hours

  • Data Validation:
    • Setting Data Validation In A Specific Area
    • Drop Down List For Easy Data Entry
    • Changing Data Validation
    • Finding Data Validation
    • Array & Sheet Referencing
  • Secure Worksheet & Workbook By Generating Password:
    • Protect Worksheet Structure
    • Protect Workbook
    • Restricting Editing In A Specific Sheet Area
    • Unprotect The Sheet With Correct Password
    • Removing Password To Unprotected The Sheet
  • Interest Calculation Based On Deposit: Normal Interest, Compound Interest
  • Labour Payment Bill & Overtime Calculation

Class Duration:3 Hours

  • Electricity Bill Calculation
  • Necessary Functions & Formulas (Part 04):
    • Round Function, Roundup Function, Rounddown Function, Goal Seek Command
  • Create & Manage Table:
    • Create An Excel Table From A Cell Range
    • Add Column & Rows In The Table
    • Customize Table Style

Class Duration:3 Hours

  • Data Visualization – Creating & Working With Charts:
    • Creating Recommended Charts
    • Moving & Resizing A Chart
    • Formatting And Editing Objects In A Chart
    • Changing A Charts Source Data
    • Changing A Chart Type
    • Working With Pie Charts, Bar Charts, Line Charts, Scatter Charts
    • Uses Of 3 Types Of Sparklines: Line, Column, Win & Loss
  • Create & Manage Pivottable & Pivotchart (Part 01):
    • Intro of Pivottable
    • Creating Pivottable With One Row & Column
    • Creating Pivottable Report With Multiple Groups
    • Changing Layo

Class Duration:3 Hours

  • Create & Manage PivotTable & PivotChart (Part 02):
    • Managing Subtotals & Grand Totals
    • Changing the Data Field Summary Operation
    • Drilling Down into PivotTable Values
    • Filtering PivotTable Data
    • Creating a PivotChart
    • Using Slicers in a PivotTable
    • Formatting a PivotChart
    • Printing a PivotTable
    • Printing a PivotChart
  • How to Prepare & Maintain a Professional Petty Cash Book in an Excel Sheet
  • Concept of Macros

Class Duration:3 Hours

  • Concept Of VBA
  • Practice With Practical Business Case Study
  • Various Excel Secrets & Shortcuts
  • Problem Solving & Recap
    (Topics From 1st to 8th Class)

Class Duration:3 Hours

  • Practical Exam

Training Schedule

DayFriday
Start Time9:00 AM
End Time12:00 PM

Learning Outcome

  • Master basic to advanced Excel formulas, functions, and logic.
  • Efficiently organize, clean, and analyze complex workplace datasets.
  • Build dynamic data charts, reporting structures, and visual summaries.
  • Utilize time-saving keyboard shortcuts to speed up daily tasks.
  • Confidently solve real-world workplace data challenges with practical hands-on experience.

FAQ

4th Floor, Gausia Market, Beside Dewanhat Fire Service, Agrabad, Chattogram.

Hello, and welcome to Skill Development Cell!

To enroll in this course, please follow these simple steps:

  1. Click the Enroll Now button on this course page.
  2. Complete the Online Registration Form with all the required information carefully.
  3. After submitting the registration form, proceed with the payment to book your seat.
  4. You can make your course payment via bKash using the following number:

bKash Number: +880 1810-067069

Thank you for choosing Skill Development Cell. We look forward to welcoming you to the course!

After completing your payment, please send us an SMS to +880 1810-067069 with the following details:

  • Your Name
  • bKash/Nagad/Payment Mobile Number used to send the payment
  • Transaction ID

After receiving your SMS, we will send you a welcome and payment confirmation SMS or call.

Thank you for choosing us!

For More Information

+880 1810-067069

ENROLL NOW
  • Discount: 50%
  • Available Seats: 30
  • SKU: SDCMSE-OFF-6165

students say...

দাদা এতটা দরদ দিয়ে না শিখালে হয়তো ms_excel এর কাজ শিখতাম তবে এতটা বিশ্লেষিত ভাবে শিখতে পারতাম না। Skill Development Cell এর অধীনে excel এর ২ টি ক্লাস শেষ হয়েছে। তিনি যেভাবে প্রতিটি বিষয় হাতে কলমে বারবার শিখিয়ে দিচ্ছেন তাতে excel এর যে কোনো সমস্যা সমাধানের আগ্রহ জাগে মনে অথচ ২ সপ্তাহ আগে ও ভাবতাম এটা হবেনা হয়তো,পারবোনা মনে হয়। ডিইসি প্রেসিডেন্ট সৈকত দাদার কাছে অশেষ কৃতজ্ঞতা।
Bashundhara Abhi
Hubei University of Technology
Topic: Ms Excel Course.
প্রথমত ধন্যবাদ জানায় আামাদের প্রেসিডেন্ট স্যার কে, যিনি এতো ব্যস্ততার মধ্যেও সময় বের করে আমাদের জন্য কোর্স টি পরিচালনা করে যাচ্ছেন। MS Excel course টা যে কতটা গুরুত্বপূর্ণ তা যারা ক্লাস করছেন তারা উপলব্ধি করতে পেরেছেন। এই কোর্স সম্পর্কে অামার নিজের কোন ধারণা নেই বললেই চলে। তবে দুইটা ক্লাস সম্পন্ন করে অনেক কিছু বুঝতে পারলাম। কিভাবে ফাংশন ব্যবহার করে এবং কম সময়ে কোন প্রবলেম সমাধান করতে হয়। কিভাবে কোন ডকুমেন্ট খুব সহজে তৈরি করা যায় ইত্যাদি।Skill Development Cell এর অধীনে সল্প মূল্যে এতো গুরুত্বপূর্ণ কোর্স করার সুযোগ করে দেওয়ায় ধন্যবাদ জানায় ডিইসির সকলকে।
Hossain Shuvo
Port City International University
Popular Training

WordPress Web Design & Development

Course Duration:6 Weeks
Number of Classes:16
Training Method:Online

WordPress Web Design & Development

Course Fee:17,000 ৳
Course Duration:6 Weeks
Number of Classes:16
Level:Basic to Advanced
Status:Running
See Module

Professional Training on MS Excel

Course Duration:5 Weeks
Number of Classes:10
Training Method:Online

Professional Training on MS Excel

Course Fee:8,000 ৳
Course Duration:5 Weeks
Number of Classes:10
Level:Basic to Advanced
Status:Running
See Module