26/04/2026
𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗦 𝗘𝘅𝗰𝗲𝗹 𝗧𝗿𝗮𝗶𝗻𝗶𝗻𝗴 𝗳𝗼𝗿 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹𝘀 & 𝗢𝘂𝘁𝘀𝗼𝘂𝗿𝗰𝗶𝗻𝗴
𝗣𝗿𝗼𝗴𝗿𝗮𝗺 𝗦𝗰𝗵𝗲𝗱𝘂𝗹𝗲: 16th May - 27th May 2026 (Every Saturday, Monday & Wednesday, 07.30 PM - 10.00 PM)
𝗦𝗲𝘀𝘀𝗶𝗼𝗻: 6 Sessions
𝗖𝗼𝘂𝗿𝘀𝗲 𝗙𝗲𝗲: 2,500 BDT
Microsoft Excel is one of the most widely used productivity tools in today’s corporate world. It plays a vital role in daily tasks such as data analysis, reporting, application development and many more. Organizations expect a high level of Excel proficiency across departments including Finance & Accounts, Research & Development, Operations, Credit Management, Compliance, HR & Admin, Procurement, and Sales & Marketing. This course helps participants develop practical and advanced Excel skills for real-world applications. It also demonstrates multiple approaches to completing tasks, along with their advantages and limitations.
This course focuses on practical Excel applications rather than theoretical concepts. Participants will learn through relevant, real-world examples aligned with their daily work.
Contents of Training:
Various Parts of the MS Excel
Ribbon:
• Tabs
• Minimize the Ribbon
• Customize the Ribbon
Range:
• Cell, Row, Column
• Range Examples
• Fill a Range
• Move a Range
• Copy/Paste a Range
• Insert Row/Column
• Hide Row/Column
• Custom Lists
• Comments
• Name Manager
Some Other Relevant Tools:
• New Line in a Cell
• Quick Access Toolbar
• Merge Cell
• Wrap Text
• Text Alignment
• Format Painter
• Hide Gridlines
• Freeze Panes
Workbook:
• Open an Existing Workbook
• Close a Workbook
• View Multiple Workbooks
• Workspace
Worksheets:
• Select a Worksheet
• Rename a Worksheet
• Insert a Worksheet
• Move a Worksheet
• Delete a Worksheet
• Zoom
• Split
• Freeze Panes
• View Multiple Worksheets
• Spelling
Find & Select:
• Find
• Replace
• Go To Special
• Copy Visible Cells Only
Paste Special:
• Skip Blanks
• Transpose
• Add or Subtract
Paste to .doc:
• Embed
• Paste Link
Page Setup:
• Header & Footer
• Page Number
• Date & Time
• Page Margins
• Page Breaks
Format Cell:
• Numbers to Text
• Leading Zeros
• Add Text
Cell References:
• Relative Reference
• Absolute Reference
• Hyperlink
• Linking Data
Import Data from Other Source:
• From Web
• From Text File
Print:
• Print a Worksheet
• Print Multiple Copies
• Center on Page
• Repeat Specific Row
Protect File:
• Password to Open
• Password to Modify
• Mark as Final
Sort:
• One Column
• Multiple Columns
• Sort by Color
Data Filter:
• Filtering
• Number and Text Filters
• Date Filters
• Advanced Filter
• Remove Duplicates
• Subtotal
Conditional Formatting:
• Highlight Cells Rules
• Top/Bottom Rules
• Data Bars
• Color Scales
• Icon Sets
• Find Duplicates
Redistricted Data Entry:
• Create Data Validation Rule
• Input Message
• Error Alert
• Prevent Duplicate Entries
• Drop-Down List
• Dependent Drop-Down List
Tables:
• About an Excel Table
• Benefits of Excel Table
• Preparing Data
• Creating an Excel Table
• Choosing Formatting Style
• Sort & Filter Data
• Show/Hide Total Row
• Insert Slicer
• Convert Table Back to a Range
Charts & Graphs:
• About Charts
• Benefits of Charts
• Sort Data Before Charting Chart
• Creating a Chart
• Change Chart Type
• Switch Row/Column
• Chart Title
• Legend Position
• Data Labels
• Display/Hide Gridlines
• Remove Noise
• Don`t Make People Head Tilt
• Column Chart
• Bar Chart
• Line Chart
• Pie Chart
• Area Chart
• Combination Chart
• Sparklines
Pivot Table & Chart:
• Pivot Table
• Pivot Chart
Date & Time:
• Year, Month, Day
• Date Function
• Current Date & Time
• Hour, Min, Sec
• Time Function
• DateDif
• Weekdays
• Last Day of the Month
• Day of the Year
Count and Sum Functions:
• Count
• Countif
• Countifs
• Sum
• Sumif
• Sumifs
• Count Logical Values
• Count Blank/Nonblank Cells
Text Functions:
• Join Strings
• Partial Strings ( Left , Right , Mid )
• Text to Columns
• Lower/Upper Case
Lookup Functions:
• VLookup
• HLookup
• Match
• Index
• Choose
Round Functions:
• Round
• Round Up
• Round Down
• MRound
• Even & Odd
Logical Functions:
• IF Function
• AND Function
• OR Function
Data Analysis:
• Goal Seek
• Data Consolidate
Macro:
• Turn on Developer Tab
• Command Button
• Assign a Macro
• Record a Macro
Mail Merge
• Why Mail Merge
• Mail Merge Process
• Final Mail Merge
Our training starts from the very basics and gradually advances to professional-level applications, ensuring every participant builds strong, practical Excel skills step by step.
Whether you are a beginner or looking to upgrade your expertise, this course will help you turn Excel into a powerful tool for your daily work and career growth.
Join us and take your Excel skills to the next level, see you there!
