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: 5 Weeks
Number of Classes: 10
Level: Basic to Advanced
Language: Bangla and English
Training Mode: Online

Course Fee

৳ 0
৳ 1000

★ The price for Skills Bangladesh ★

ENROLL NOW

objectives

Get the most out of Microsoft Excel faster and easier than ever and be the Excel Expert of your work place. In this training, maximize your productivity with Microsoft Excel’s best tools and shortcuts; because this training has been designed for the students, newly recruited professionals, mostly regular excel users & keenly interested MS Excel learners who are want to improve and sharp or re-sharp their knowledge in this case. Participants will learn to excel features & functions from the very basic stage to the mostly advanced stage phase by phase with the 100% practical project work & real life example.

BENEFIT OF THIS COURSE

  • Explore the Uncovered Areas of Excel
  • Understand the Full Potential of Excel
  • Learn Excel’s Built-in Utilities
  • Explore Features Most Users Leave Untouched
  • Apply Excel Skills in Regular Work

Pre-Requirements

  • Participants should have basic computer knowledge and operating skills MS Excel 2010 / 2013 / 2016 / 2019 / Office 365 installed (Excel 2013 or above recommended)
  • For offline training, participants must bring a laptop
  • For online training, participants should have an internet-connected PC or mobile device

COURSE MODULE

Class Duration:2 Hours

Introduction

  • Getting Familiar With MS Excel Interface & Its Common Options:
    • Application of Navigation Tools
    • 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
    • Normal, Page Layout, Page Break Preview
    • Create & Manage Custom View
  • Practice With Font Group:
    • Professional Font Size
    • How To Maintain Fill Color & Text Color
    • Increase & Decrease Indent
    • Customizing Border
  • Practice With Alignment Group::
    • Horizontal & Vertical Alignment
    • Text Control: Wrap Text, Shrink To Fit, Merge Cells
    • Text Orientation

Class Duration:2 Hours

Necessary Functions & Formulas (Part 01)

  • Necessary Functions & Formulas (Part 01):
    • Mathematical Function : Sum, Average, Min, Max, Variance
    • Text Function : Left, Right, Mid, Lower, Upper, Proper, Trim, Concatenate
  • Cell Joining Using Ampersand (&)
  • Viewing Data On Worksheet:
    • Showing – Hiding The Screen Objects
    • Freeze Top Row & First Column
    • Freeze & Unfreeze Pane While Scrolling
  • 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
  • Preparing Invoice

Class Duration:2 Hours

Necessary Functions & Formulas (Part 02)

  • Necessary Functions & Formulas (Part 02):
    • Logical Functions : If Condition (Excluding & Including Else), Nested If Formula
  • Entering Data In Cells & Sheets:
    • Relative Cell Reference
    • Absolute Cell Reference
    • Mixed / Partial Relative & Absolute Cell Reference
  • Paste Special Options
  • Advanced Use of “Find & Replace” OptionOptions

Class Duration:2 Hours

Necessary Functions & Formulas (Part 03)

  • Necessary Functions & Formulas (Part 03):
    • Lookup Functions: Vlookup, Hlookup, Match, Index Function,
    • Combination of Index & Match Function
  • Create & Manage Table:
    • Create An Excel Table From A Cell Range
    • Add Column & Rows In The Table
    • Customize Table Style Options
    • Controlling Table Using Slicer
    • Sorting & Filtering Table Data
    • Convert A
    • Table To A Normal Range
  • Professional Use of “Clear” Option Under Editing Group

Class Duration:2 Hours

Necessary Functions & Formulas (Part 04)

  • Necessary Functions & Formulas (Part 04):
    • Date & Time Functions: Day, Month, Year, Now, Today, Weekday, Edate, Dated If, Days360
    • NetworkdaysLogical,Financial & Statistical Function: And, Or, Not, IS, SumIf, CountIf, CountA, CountBlank
  • 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

Class Duration:2 Hours

Interest Calculation (Based On Deposit)

  • Interest Calculation (Based On Deposit): Normal Interest, Compound Interest

  • Necessary Functions & Formulas (Part 05):
    • Round Function, Roundup Function, Rounddown Function
  • 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:2 Hours

  • Electricity Bill Calculation

  • 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 Unprotect The Sheet

Class Duration:2 Hours

Data Visualization

  • Data Visualization with Charts & Graphs:
    • Creating Recommended Charts
    • Moving & Resizing A Chart
    • Formatting And Editing Objects In A Chart
    • Changing A Charts Source Data
    • Working With Pie Charts, Bar Charts, Line Charts, Scatter Charts
    • Uses of 3 Types of Sparklines : Line, Column, Win & Loss
  • Create & Manage Pivottable & Pivotchart:
    • Intro of Pivottable
    • Changing Layout Of Pivottable
    • Managing Subtotal & Grand Total
    • Drill Down The Pivottable Value
    • Filtering The Pivottable Data
    • Creating Pivotchart
    • Use Slicers In Pivottable
    • Formatting A Pivotchart

Class Duration:2 Hours

  • Basic Concept Of Macro & VBA
  • Problem Solving & Recap (Topics From 1st to 8th Class)
  • Various Excel Secrets & Shortcuts
  • Providing Instructions To Submit The Final Assignment / Project

Assignment: Final Assignment / Project

Class Duration:2 Hours

How to Professionally Use the Common Tools & Options of Microsoft Word

Training Schedule

DayFriday
Start Time7:30 PM
End Time9:30 PM
DaySaturday
Start Time8:30 PM
End Time10:30 PM

Learning Outcome

  • Understand Microsoft Excel from basic to advanced level
  • Work confidently with Excel worksheets, workbooks, rows, columns, and formatting tools
  • Create and manage professional Excel spreadsheets
  • Use essential formulas and functions for everyday work
  • Perform basic, financial, and interest calculations
  • Apply advanced functions to solve practical problems efficiently
  • Use Conditional Formatting to analyze and highlight data
  • Work with Excel data more efficiently using shortcuts and productivity tools
  • Create practical reports and spreadsheets based on real-life requirements
  • Apply Excel skills to regular academic, professional, and business tasks
  • Improve accuracy and reduce time spent on repetitive Excel work
  • Develop practical problem-solving skills through hands-on exercises and real-life examples

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:

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 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

ENROLL NOW
  • Discount: 63%
  • Available Seats: 35
  • SKU: SDCEX-ONL-32505

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