Introduction
Office productivity is a vital part for high growth and better performance in personal career and education. Microsoft Excel is most widely used productivity tool in today’s corporate world and education sector. Day to day corporate analysis and tools are prepared with Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel for office and academic activities. Excel allows us to accomplish a task in multiple ways which will be shown to attendees with Pros and Cons of the methods.

How participants will benefit after the course:
HANDS ON EXPERIENCES. Each widely practiced Excel topics are covered in the course syllabus with practical exercises. Lookups (Vertical, Horizontal, 2 Ways), Sumif-Sumifs, Countif-Countifs, If-Nested If, Logical AND-OR-NOT, Date, Number, Charts, Sorting, Advanced Filtering, Table-Pivot Table, File Security-Protection, Macros-VBA, and other required functionalities of this course will ensure participants high performance in their career and academics.

Workshop topics to be covered:

DAY 1
Excel Concepts
• Workbook, Worksheet, Row, Column, Cell, Range
• Ribbons (Tab>Group>Command)
• Quick Access Toolbar (QAT)
• Formula Bar, Name Box, Scroll Bar, Status Bar, Toolbar

Customization Options in Excel
• Popular Options
• Formulas Options
• Proofing Options
• Save Options
• Customize Options

Common Operations
• Workbook (New, Open, Save, Save As, Close)
• Worksheet (Insert, Modify, Move, Copy, Delete, Rename, Hide/Unhide, Color)
• Rows, Columns (Insert, Copy, Cut, Delete, Hide/Unhide)
• Cells & Range (Select, Copy, Cut, Paste, Delete)

Special Operations
• Paste Special
---o Values
---o Transpose

• Auto Fill Options and Edit Series List

Keyboard Short Cuts
• CTRL Combination Keys
• ALT Combination Keys
• SHIFT Combination Keys
• Function Combination Keys

Cell References
• Relative cell references (A1)
• Absolute cell references ($A$1)
• Worksheet cell references
• Workbook cell references
• Shortcuts

Formatting, Style & Custom Formats
• Create, Copy and Clear Formats
• Cell Formatting
• Number Formatting
---o Decimal
---o Percentage

• Text Formatting
• Date Formatting
• Custom Formats
• Shortcuts

Conditional Formatting - Changing the Appearance of Data Based on Its Value
• Highlight greater than average Values
• Highlight Top 10% Values
• Data Bars
• Icon Sets
• Create, Clear, Manage & Customize Rules

Table
• Convert To Table
• Dynamic Range & Naming
• Add, delete records
• Table Names & Formula Nomenclature
• Table Formatting & Styling
• Convert Back to Range
• Shortcuts

Sort
• Sorting Numbers (Smallest to Largest)
• Sorting Words A to Z in Single Column
• Sorting Words A to Z in Multiple Columns
• Sorting #NA Errors
• Sort by Color

Filter
• Turn on Filter
• Filter with One Criteria
• Remove Applied Filtering
• Filtering on Cell Fill Color
• Filtering Below Average Values
• Filtering Texts
• Filtering Dates
• Shortcuts

Advanced Filter
• Extracting Records With AND Criteria
• Extracting Records With OR Criteria
• Extracting Records to a New Sheet
• Extracting Unique Records (Remove Duplicates) Find & Select
• Find and Replace within Worksheet
• Find and Replace within Workbook
• Shortcuts

View & Windows
• Freeze Panes
• Hide/Unhide windows
• Workspace
• Switch Windows
• Zoom windows and selection

Proofing
• Spell Check
• Thesaurus

Comments
• New comments
• Edit comments
• Show/Hide Comments

Charts
• Categories & Series
• Chart Types
---o Pie Charts
---o Column Charts
---o Bar Charts
---o Line Charts
---o X-Y Scatter Charts

• Creating & Formatting Charts
• Adding Chart Data Labels
• Printing Charts
• Changing Chart Styles
• Shortcuts

Chart Trend Line – Finding trends from data
• Linear
• Exponential
• Polynomial

Named Range
• Define Names Using Name Box
• Define Names Using Dialog Box
• Modifying, Deleting Names
• Using Names in Formulas
• Shortcuts

Grouping
• Rows
• Columns

Subtotal
• Subtotals to Summarize Data By Field
• Navigate Subtotal Levels
• Expand/Collapse Subtotals
• Removing Subtotals

Pivot Table – Analyze Data Dynamically
• Create Pivot Table with Row Labels, Column Labels & Values Area
• Formatting & Style
• Collapse Row Labels
• Filtering a Field
• Sorting by Fields
• Report Filter Area
• Summary Functions
• Group Dates By Days, Week, Month, Quarter, Year
• Group Numbers & Decimals by Range
• Source Data Refresh
• Dynamic Pivot Chart
• Shortcuts

DAY 2

Formulas
• Difference Between Formula & Function
• Create, Copy, Edit Formulas
• Formula Elements
• Order of Arithmetic Operations
• Use Cell References
• Formulas with Named Ranges

Functions
• Insert functions
• How functions work
• Find functions

Functions (Math)
• SUM Function – Adding all numbers in a range
• COUNT-COUNTA Function – Counting total number of words and numbers.
• MIN- MAX Function – Finding smallest and largest values
• SUMIF-SUMIFS Function - Summarizing data with conditions
• Decimal Functions
---o ROUND

Functions (Statistical)
• AVERAGE Function – Averaging numbers
• MODE-MEDIAN

Functions (Text)
• TRIM, UPPER, LOWER, PROPER, CLEAN
• CONCATENATE, &, CHAR(10)
• LEFT, MID, RIGHT
• FIND-SEARCH
• SUBSTITUTE, REPLACE
• VALUE

Functions (Logical)
• IF & Nested IFs
• AND-OR-NOT
• TRUE-FALSE

Functions (Lookup)
• VLOOKUP, HLOOKUP
---o Exact lookup
---o Partial lookup
---o Two-way lookup

• INDEX- MATCH
---o INDEX Function
---o MATCH Function

Functions (FINANCE)
• Future Value (FV)
• Present Value (PV)
• Periodic Payment (PMT)

Functions (Date/Time)
• DATE
• TODAY
• NOW
• DATEDIF
• Shortcuts

Protection & Securities
• Password Protect Workbook for Opening & Modification
• Backup Workbook Automatically
• Disallow Worksheet Creation, Renaming, Hiding, Deletion
• Password Protect Worksheets
• Disallow Cells or Range for Modification by Locking

Image and Smart Art
• Adding Images to Document
• Adding Background
• Adding Shapes

Printing
• Page Setup
• Print Preview
• Print Repetitive Titles
• Margin
• Background
• Header/Footer
---o Page Numbering
---o Current Date/Time

• Page Setup for Large Spreadsheets
• Set Print Area
• Shortcuts

Errors & Fix
• Pound(#) Sign Error
• #NAME? Error
• #N/A Error
• #REF! Error
• #VALUE! Error
• #NUM! Error
• #DIV/0! Error
• Circular Cell Reference Error
• #NULL! Error

What-If Analysis
• Goal Seek – Get desired result by varying your data
---o Break-Even with Goal Seek

• Scenario and Sensitivity Analysis

Data Validation
• Create Validation List
---o Number
---o List

• Show Input Message
• Show Error Alert
• Mark Invalid Data

Data Import-Export
• Importing From Different Open Excel Workbook
• Importing From Comma-Separated or Tab-Separated Data
• Exporting to MS Word
• Exporting to MS PowerPoint
• Exporting to Comma-Separated or Tab-Separated Data

Sharing & Collaboration
• Track Changes by Different Users
• Highlight Changes
• Accept or Reject Changes

Hyperlinks
• Link to Worksheets
• Link to Different Workbooks
• Screen Tip

Techniques
• Find & Remove Duplicates
• Unique List
• Text To Column

Data Fix & Cleanup
• Fix Number Problems
• Fix Date Problems
• Fix Text Problems

Business Cases
• Customer Insight
• Debt Analysis
• Credit Analysis

Macros & VBA – Automate repetitive tasks
• Working with Macros
---o Difference between Macros and VBA
---o Record and run a macro.
---o Understand and edit simple recorded macros.
---o Run a macro by using a shortcut key.
---o Running Macros using Buttons
---o Manage macro security

• Visual Basic Editor
• Macro & VBA Examples

• 10.5 Habits of Successful Selling for Breakthrough Results
• 1001 Selling Techniques for Excellence
• 1111 Selling Techniques for Excellence
• 13 Lessons to turn every Company into Fantastic Brands
• Advance Selling Techniques
• Advanced Brand Management
• Advertising Technology, Branding Guideline, Corporate Identity & Computer Art
• Art of Pharmaceutical Sales
• Basic Brand Management
• Brand Building Lessons for SME
• Brand Management–Walking the Talk
• Brand Planning Motorbike
• Brand You: How to Use World Class Branding Skills to Position Yourself As A Brand
• Branding for Bangladeshi Business
• Building Customer Relationship beyond Traditional Service
• Building World Class Brands
• Constructive & Modern Leadership Approach in Selling through Team Building
• Corporate Account Management
• Corporate Sales Management
• Corporate Sales Management
• Corporate Sales Management Excellence
• Corporate Sales Management for Excellence
• Creating Impact at Retail
• Creating New Prospects and Managing Sales Pipeline
• Creative & Successful Selling Techniques for Excellence
• Customer Relationship Management (CRM)
• Developing A Winning Brand Plan
• Digital / On-line Marketing - New Era of Brand Management
• Effective Print Advertising: 13 Tips to Create Powerful Advertising
• Effective Selling Techniques
• Essential Territory Management & Distribution Excellence
• Essentials of Export Marketing
• FMCG Sales Management
• From Facebook to Viral Marketing: How to use New Media for your Brands
• Fundamentals of Marketing
• Fundamentals of Media Planning
• Generating Sales through Retail: Impact of Trade Marketing Excellence
• Highway to Super Sales Management
• How A Successful Salesman Can Become Even More Successful
• How to Sell Anything to Anybody
• How To Successfully Close Every Sales Call
• Integrated Marketing Communication (IMC): Winning Strategies for the 21st Century
• International Diploma in Marketing Management
• Market Research - Get the Right Data to Make the Right Decisions
• Marketing Plan Development Workshop
• Marketing ROI: Maximize Your Marketing Investment
• Merchandising Excellence for Consumer Products
• Microsoft Excel 2007 for Marketing, Sales and Credit Management Professionals
• Negotiating Skills & Establishing Strategic Alliances
• Power of Professional Customer Relations Management
• Practical Industrial Engineering and Work Study
• Practical Marketing
• Professional Key Account Management & Strategic Alliances
• Professional Sales Management & The Challenge of Leadership
• Professional Sales Techniques in the 21st Century
• Recognizing the Hidden Opportunities to Increase Sales
• Retail Selling Skills
• Retail Selling Techniques for Excellence
• Sales & Marketing Fast Track Training
• Sales & Marketing mini MBA
• Sales and Marketing Management Master Class
• Sales Effectiveness
• Sales for Non Sales Professionals
• Sales Force Management: Rewards, Compensation, Motivation & Team Building
• Sales Team Management Excellence
• Secrets of Building A High Performance Sales Team
• Selling Engine
• Selling Skills for Success
• Sharpening Selling Skills & Effective Territory Management
• Sharpening Selling Skills by Creating New Prospects
• Shopper Marketing: How to Win in Point of Purchase (PoP)
• Strategic Brand Management
• Strategic Brand Planning
• Strategic Sales Management
• Successful Digital Marketing
• Successful Event Management
• Taking Sales to Higher Level through Account Management Excellence
• The Art of Professional Selling
• The Power of Professional Marketing and Sales Promotion by Objectives
• The Professional Brand Manager
• The World of Marketing & Corporate Sales Management
• Trade Marketing & Distribution
• Win over Competition
• Win the battle at POP (Point of Purchase)
  See the world in the Eyes of your Shopper
  
• Winning at Retail
• World Class Service Marketing

• Administration and Logistics Management for HR & Administrative Professionals
• Advanced HR Training
• Balanced Scorecard
• Bangladesh Labour Act, 2006 (as amended)
• Basic Concepts of HR
• Basics of Labor Laws
• Civil, Criminal and Labor Law at Workplace
• Coping with Trade Union
• Developing Assessment Tests & Conducting Competency-based Interviews
• Disciplinary Actions, Departmental Enquiry & Labor Laws
• Disciplinary Actions- Its laws and practices
• Domestic Enquiry & Labor Laws
• Effective HR & Administration Techniques
• Effective Interviewing Skills
• EFFECTIVE PAYROLL MANAGEMENT - Are Your Employees Paid Correctly?
• Effective Performance Management
• Employee Learning, Training & Development Process
• Essential Skills for HR & Administrative Support Professionals
• Foundation Course on HR
• Grievance Handling and Conflict Management According to Labor Laws
• Hire Smart – Interviewing Skills Workshop
• HR Accounting
• HR Audit
• HR Blue Chips: The Value Stream Functionalities
• HR Management and Organizational Behavior for RMG Factories
• HR Planning
• HR Training
• HRM for Non HR Professionals
• Human Resource Department
• Human Resource Information System (HRIS)
• Human Resource Management and Organizational Behavior
• Human Resources Best Practices – Recent Trends
• Improving Employee Relations
• Job Analysis
• Labor Law 2006: Disciplinary Proceedings and Major Mistakes
• Management and Finance Skills for Administrative Professionals
• Management of Change & New Agenda of HR
• Management of Conflict, Grievance & Counseling at Workplace
• Management Skills for Administration and HR Professionals
• Management Skills for Administrative & HR Professionals
• Managing Compensation and Benefits
• Modern Concepts of HR
• Organizational Development
• Performance Management & Coaching Skills for Line Managers
• Performance Management Systems
• Recruitment and Selection of HR
• Strategic HR Planning
• Strategic Human Resources Management
• Talent Management
• The Balanced Scorecard
• Training and Development of HR
• Training Needs Analysis (TNA)
• Using Job Analysis for HR Planning
• Writing Effective Job Descriptions

• A Comparison between the VAT Act, 1991 and the (Draft) VAT Act, 2011
• A General Overview of the VAT System of Bangladesh
• Advanced Business & Financial Modelling using Excel 2010
• Advanced Financial Forecasting
• Advanced Financial Modelling and Risk Management using Microsoft Excel 2007
• Advanced Logistics Engineering & Supply Chain
• Advanced Master Course on Logistics Optimization, Material Management, Warehouse System Design & Distribution Channel
• Advanced Supply Chain Planning
• Budget Planning & Control
• BUDGETARY CONTROLS AND CASH FLOW IN BUSINESS
• C & F Agent Business & Its Functional Activities
• Changes in Value Added Tax (VAT) Act, Rules, SROs and General Orders in the Budget 2010-11
• Changes in VAT Act, Rules, SROs and General Orders in the Budget 2011-12
• Changes in VAT Act, Rules, SROs and General Orders in the Budget 2012-13
• Changes of Income Tax in Budget, 2011 and Details of Direct Tax Act, 2012 (Proposed)
• Changes of Income Tax in Finance Act, 2011, New SROs and Tax Planning
• Changes of Income Tax in Finance Bill 2010-11 and Individual Tax Planning
• CIMA – MBA Gateway Exam Preparation Course
• CIMA Certificate in Business Accounting
• Commercial & Marketing Guideline for Export Import Business
• Competitive Advantage through Supply Chain
• Competitive Procurement
• Compliance with Money Laundering Laws, Rules and Regulations
• Corporate and Individual Tax Planning
• Corporate Credit Analysis
• Corporate Tax Management
• Credit Analysis
• Credit Management & Debt Collection Strategies
• Customs Procedure and role of C&F agents in Import & Export
• Customs Procedures & Formalities for Import & Export
• Customs Procedures and Role of C&F Agents in Import & Export
• Customs Procedures for Export and Import
• Customs Procedures for Import & Export
• Debits and Credits: Taking the Fear out of Accounting
• Deduction of VAT at Source and VAT on Traders
• Documentation & Procedure of Import Export Business
• Documentation of Loans and Advances
• Easy Financial Modeling Tools in Excel with Case Studies & Templates
• Economic Value Add Concepts and measurements ( EVA )
• Effective Budgeting Techniques
• Effective Tax Planning for Minimizing Tax Burden Legally
• Emergence and Application of Value Added Tax ( VAT) in Bangladesh
• Executive Course on Income Tax Management
• Executive Course on VAT
• Executive Training on Individual & Corporate Tax Planning
• Export and Import through L/C
• Export Import Finance
• Export Import, Indenting, C&F Agent, Tender & Buying House Business Functional Activities
• Finance & Accounting: IT Integrated Mini MBA
• Finance for Business Professionals
• Finance for Non Financial Managers
• Finance for Non-Finance Managers
• Finance for Non-financial Managers
• Financial Analysis & Modeling with MS Excel 2007/2010
• Financial Analysis and Modeling with Microsoft Excel
• Financial Forecasting Essentials
• Financial Management Certificate Program
• Financial Management Training
• Financial Modeling and Forecasting Training
• Financial Planning, Forecasting and Risk Modelling using Oracle Crystal Ball
• Financial Planning, Forecasting and Simulation with Crystal Ball
• FM 02: Financial Modeling in Excel with Case Studies & Templates
• FM O1: Financial Modeling in Excel with Case Studies & Template
• Fundamentals of Finance and Accounting for Administrative Professionals
• Fundamentals of Financial Reporting & Accounting Techniques
• Fundamentals of Purchasing
• Fundamentals of Purchasing and Vendor Management
• Fundamentals of Supply Chain Management
• Global Supply Chain, Procurement and Logistics Management
• Green Logistics- An Overview
• How Do You Fill-up Your Income Tax Return and Wealth & Liability Statement ? - Some Valuable Tips
• How to Fill-in Major VAT Forms
• How to Setup Indenting Business
• How to Setup Indenting Business and Run Its Functional Activities
• HOW TO START & MANAGE EXPORT/IMPORT AND INDENTING BUSINESS
• Implementing Absorption, Activity Based & Life Cycle Costing in Service & Manufacturing Organisations
• Import Export Procedure - Documentation & Financing
• Income Tax Management
• Income Tax Management & Planning
• Incoterms, URC and URR
• Input Tax Credit and Input Management in Value Added Tax (VAT) System
• International Diploma in Business Management
• International Diploma in Financial Management (IDHRM)
• International Tender Business & Agency Agreement with Foreign Suppliers
• International Trade Process and Related Supply Chain Management
• Inventory and Store Management
• Inventory Management
• Investment Fundamentals and Analysis
• Investment Fundamentals and Risk Mitigation
• Islamic Banking, Investment and Fund Management
• Islamic Finance and Insurance
• L/C Procedures for Import & Export with Practical Exercise
• Logistics and Trade Docs Function in Supply Chain Management
• Logistics and Transportation- A Way to Success
• Managing Accounts Receivables - Best Practices
• Material and Inventory Management
• Material, Inventory, Logistics and Transport Management
• Mergers and Acquisition
• Multi-modal Transportation, Logistics and Export/Import
• New VAT Act, 2012: Basic Features & Differences with VAT Act, 1991
• Organizational Cost Control & Management Techniques
• Practical Accounting
• Practical Cost Accounting
• Practical Financial Accounting
• Procurement Negotiation
• Procurement, Logistics and Transportation
• Role of Logistics for Global Supply Chain Integration
• Rules Applicable for Imports and Exports
• SAGE (ACCPAC) Simply Accounting for Professional Accountants
• SAP FI (Finance ) Foundation Course
• Shipping and Logistics Process
• Source Tax and Corporate Tax Planning
• Standard Practices of Value Added Tax (VAT)
• Strategic Financial Modelling with Microsoft Excel
• Strategic Framework of Supply Chain & Developing Efficient Supply Chain for Telecommunication Industry
• Strategic Procurement
• Supply Chain for Non Supply Chain Professionals
• Supply Chain Management
• Supply Chain Management
• Supply Chain Management for Manufacturing Industry
• Supply Chain Management Fundamentals
• Tally.ERP 9 for Accounting Management
• Tally.ERP 9 for Inventory Management
• Tally.ERP 9 for Payroll Management
• Tax Planning and Changes of Income Tax in Finance Act, 2012, New SROs & More
• Technical Session on Value Added Tax (VAT)
• The Proposed VAT Act, 2011: Salient Features and Comparison with the VAT Act, 1991
• Trouble Shooting Session on Value Added Tax (VAT)
• Understanding ICC Rules (UCPDC) and Key Techniques for Applying on Documentary Credit (L/C) Operations
• Understanding Shipping Business
• Value Declaration of Goods under VAT
• VAT and VAT Accounting
• VAT Audit and Accounts
• VAT Training

• Applied Health, Safety & Environment (HSE)
• Business Process Management (BPM)
• Business Process Reengineering and ERP Implementation
• CSR, Supply Chain Management and Social Audits
• Fire & Safety Management
• Fundamentals of Six Sigma Applications
• Good Manufacturing Practices (GMP) – 2012 and Beyond
• HSE for Supervisors / Managers
• Implementing Corrective and Preventive Actions (CAPA)
• Implementing HACCP Based FSMS According to ISO 22000:2005
• Internal Auditor Course on ISO 14001:2004
• Internal Auditor Course on ISO 9001:2008
• Internal Auditor Course on OHSAS 18001:2007
• Internal Quality Audit According to ISO 9001:2008
• ISO 14000 and OHSAS 18000: HSE Management
• ISO 14001:2004- Internal Auditing
• ISO 9001:2000 – IQA/MR/NCR/CAPA
• ISO 9001:2008 - The New Era of Quality Management
• Managing Safety for Insurance Audit
• Risk Assessment and HAZOP Analysis
• SA 8000 – Awareness and Implementation
• Safety Management Systems
• Six Sigma Black Belt Certification Training
• Six Sigma Green Belt Certification Course
• Total Quality Management
• Total Quality Management (TQM)
• Total Quality Management for Manufacturing Sector
• Understanding Lean Six Sigma (Lean Manufacturing)
• Understanding Six Sigma

• 2D Animation with Flash 8.0
• 31 Excel Tips with Case Studies
• 55 Useful Tips for MS Excel
• Advance Professional Tips on Microsoft Excel
• Advanced Professional Tips on Microsoft Excel
• Advanced Professional Tips on MS Excel
• Analysis and Reporting with Microsoft Excel 2007
• Applying COBIT 5 for better IT Governance
• ATEST
• Basic PHP and CakePHP Framework
• Basic PHP Programming
• Basics of IT Service Management (ITSM)
• Be A Bug-free Developer: TDD by Example
• Be a Bug-Free Developer: TDD by Example
• Beginners to Intermediate on MS Excel
• Build Your Own CMS with PHP
• Building Powerful Web Applications by Ajax!
• Business Intelligence with Excel
• Business Management Training with State of the Art ERP Technology
• Character Animation and Fundamentals of 3D Studio Max
• CISA Exam Preparation Course
• CISA Exam Preparatory Course
• Cloud Computing Bootcamp – Technology for Business Transformation
• Cloud Computing Course: Essentials of Cloud Infrastructure
• Computer Aided Structural Design & Analysis with STAAD.Pro
• Construction Management
• Creating Interactive Web Pages by ASP.NET
• Creative and Professional Course on Graphic Design
• Creative and Professional Graphic Designing Workshop
• Creative Image Editing using Advanced Photoshop Techniques
• Database Design & Management for Software Applications: Hands-on Course for Real Life Issues and Solutions
• Developing Excel Based Application: Advanced MS Excel 2007
• Developing Professional & Dynamic Website Using Joomla!
• Developing Rich Client Applications with Flex 3
• Developing Website with CodeIgniter Framework
• e-Business Strategies and Technologies
• E-Commerce Applications by osCommerce & Zen Cart
• Enterprise Content Management: MS SharePoint 2007 as A Tool
• Ethical Hacking & Information Security Workshop
• Evening Course: Mastering MS Visio 2007( Basic to Advanced)
• Excel 2007/2010: From Novice to Professional
• Excel Functions, PivotTable, Lookups & Charts in Depth
• Flash CS4 with Actionscript 3.0
• Freelancing IT Jobs – How to Make Yourself Ready
• HTML CSS and Javascript for PHP
• HTML5 and CSS3 Training
• Implementing Agile/Scrum in Practice
• In-Depth Pivot Table, Array and Lookup Functions in Excel
• ISO 27001 Lead Auditor for Information Security (ISMS)
• IT and Business Alignment
• IT GRC Course: Essentials of COBIT^®
• IT Security Fundamentals
• ITIL Foundations 2011 Edition
• ITIL Version 3 Foundation Course
• ITIL- IT Service Management
• ITSM Course: Essentials of ITIL^®
• Java Programming Basics
• Joomla, OsCommerce, ZenCart, Drupal & WordPress
• Learn the Latest Joomla 1.6
• Learn the Latest Joomla 1.6 and ZenCart 1.3.9
• Managing Excel and Worksheet Data
• Mastering MS Access 2007 (Database Designing and Programming)
• Mastering Charts in MS Excel
• Mastering Charts in MS Excel
• Mastering Photoshop with Advance Techniques
• Microsoft Access 2007/2010: Database Management for Beginner to Advanced
• Microsoft Excel 2007 & 2010: Advanced Application Development
• MICROSOFT EXCEL 2007 : Practices in Operations and Management
• Microsoft Excel 2007-2010 – Intermediate
• Microsoft Excel 2007/2010 for Beginners
• Microsoft Excel 2007/2010 Formulas & Functions for Beginner to Intermediate
• Microsoft Excel 2007/2010 Formulas & Functions in Depth
• Microsoft Excel 2007/2010 in Depth for Beginner to Advanced
• Microsoft Excel 2007/2010 Lookups, Charts & PivotTable in Depth
• Microsoft Excel 2010 – Advance Level
• Microsoft Excel 2010 – Starter Level
• Microsoft Excel 2010 – Starter to Expert Level
• Microsoft Excel Macro & VBA Made Easy
• MS Access 2007 Database Designing and Programming (Part 1 of (Two) parts series)
• MS Excel 2007 Simple and Easy
• MS Excel 2007/2010 Formulas & Functions for Intermediate to Advanced
• MS Excel 2007/2010 Lookups, Charts & PivotTable for Intermediate to Advanced
• MS Project 2007 with Case-Studies
• Object oriented PHP, MySQL Programming with HTML5, CSS3, JavaScript, Ajax and jQuery
• Object Oriented Programming with PHP 5
• Organizational Website Management by JOOMLA 2.5 !
• Organizational Website Management by Joomla and Wordpress!
• Organizational Website Management by JOOMLA!
• PHP Basic to CodeIgniter Framework
• PHP Basics with CSS, Java Scripts & MySQL
• PHP Programming & Joomla
• PHP Programming & Joomla 1.6
• PHP Programming & Joomla! 1.5
• PHP Programming by CodeIgniter Framework
• PHP Programming with CakePHP Framework
• PHP Programming with CakePHP Framework and osCommerce
• PHP Programming with CodeIgniter & CakePHP Framework
• PHP Programming with CodeIgniter Framework
• PHP Programming with HTML, CSS, JavaScript, MySQL, Ajax & jQuery
• PHP with CodeIgniter Framework
• PHP, MySQL Programming with CodeIgniter
• Pivot -Table in Excel 2010 - Advance Data Analysis and Reporting
• Power Excel 2010 Workshop
• Powering Endless Variety of Websites by Drupal
• Practical MIS and Analytics
• Professional Blog Development using PHP Programming and WordPress
• Professional Data Analysis Using Microsoft Excel
• Professional Excel by Case Studies
• Professional Graphic Design Master Class
• Professional PowerPoint for Business
• Professional Tips on MS Excel 2007
• Project Management A to Z Using MS Project Professional with Case Studies
• Search Engine Optimization Training
• STATA 10.0 for Business Analysts
• Statistical Analysis using SPSS
• Tally.ERP 9 for Accounting, Inventory & Payroll Management
• Web Templates Design with Dreamweaver, HTML, CSS & JavaScript
• Website Development by PHP Basics,HTML,CSS,Javascript & Joomla 2.5
• Work Breakdown Structure and Scheduling using MS Project Professional
• Zend Framework Fundamentals

• 6S- Implementation Methodology, Assessment Technique with Practical Case Study
• Apparel Merchandising
• C-TPAT: Supply Chain Security Management
• Effective Quality Assurance in RMG Sector
• EFFICIENT PRODUCTION PLANNING (RMG)
• EFFICIENT PRODUCTION PLANNING
• Ergonomics in Garment Industries
• Fire Safety and Health Implementation Management System for Garments
• Fundamentals of Fashion Designing and Forecasting
• How to Become A Smart Merchandiser
• How to Ensure Shipment on Time, Produce Quality Garments & Increase Productivity in Knit Composite
• How to Handle Exports Imports in the Garments Sector including EPZ Rules
• How to Prepare a Factory for C-TPAT/GSV/SCS Audit
• How to Prepare A Factory for Compliance Audit (Knit & Woven)
• How to Setup A Knit Composite Factory
• How to Setup Garments Buying House and Its Functional Activities
• Industrial Engineering & Work Study in Garment Industry
• Industrial Engineering and Work Study in RMG
• Industrial Engineering for Garment Industry
• Knit and Woven Production Planning
• Knit Garments Consumption and Costing
• Knit Garments Costing
• Knit Garments Merchandising and Costing
• Knit Garments Production Planning and Control
• Lean Manufacturing
• Merchandising Follow-up in Knit Garments
• Merchandising in Knit Garments
• Merchandising in Textile & Garment Industry
• Occupational Safety & Health in Garments Factory
• Operational Excellence in Garment Industries through Industrial Engineering Concepts
• Operations Management for Effective Merchandising and Productivity of Garments
• Pattern & Product Development and Sampling
• Prevention of Fire and Casualties in Garments Industries
• Role of Garments Merchandiser
• Safety, Health & Hygiene, Work Ergonomics and 5S for Productivity
• Sample Management in Garments Business
• Shipping Procedure for Export, Import and Garments Industry
• Six Sigma Applications in Manufacturing Sector
• Social Compliance Auditing System
• Social Compliance Management for Industries
• Standard Codes of Conduct for Garment Industries
• Standard Compliance in Garment Industries
• Supply Chain Management in Garments Business
• Tools and Techniques of Achieving Production Target and Quality
• Total Merchandising in Knit and Woven Garments
• Total Merchandising in Knit Garments
• Total Quality Control in Garments
• Toyota Production System in Garment Industry
• Work Study and Time Study
• Work Study as Management Tool
• Woven Garments Consumption and Costing
• Woven Garments Costing
• Woven Garments Merchandising and Costing

• Bank Management Training
• Basel Framework of Capital Measurement in Relation to Risk Management
• Credit Risk Management Workshop
• Evening Course: Export and Import Finance
• Export Import Procedures and Financing
• Financial Analysis for Bankers
• Foundation Course on Bank Management
• Fundamental Course in Finance and Banking
• Loans and Advances: Types, Its Management & Other Related Issues
• Risk Management in Banks
• SME Financing for Bankers
• Syndication Financing with Feasibility Study & Credit Risk Grading
• Training on Foreign Exchange
• UCPDC – 600: A Legal Component of International Trade
• Uniform Customs & Practice for Documentary Credit (UCPDC - 600) and ISBP - 681

• Advocacy Initiatives in Development Sector: Tools and Strategies
• Designing an Effective Project Proposal
• Financial Management for NGOs
• Gender & Violence Against Women (VAW)
• Logical Framework: The Essential Tool for NGO Project
• Project Development and Management for NGOs
• Project Management for NGO Managers
• Project Management for NGOs
• Project Monitoring & Evaluation
• Project Proposal Writing for NGOs
• Rights Based Approach for NGOs

• A to Z Business Report Writing
• Advanced Business Writing
• Basic English Writing: for Work and Daily Life
• Be A High-powered Professional Manager: MBO & Decision Making
• Boost up Your Office Productivity and Accomplish Tasks Faster
• Breaking through English Writing Barriers
• Breaking through English Writing Barriers 2
• Business & Financial English Training
• Business Communication Training
• Business Writing Essentials
• Career in Outside Bangladesh - Specially in Middle East and North America
• Communicating for Success
• Communication in Managerial Context
• Competitive Negotiation (A Competitive approach to win-win negotiation)
• Easy Tips and Techniques for Professional Excel Users
• Effective Communication & The Disciplines of Professional Presentations
• Effective Supervisory Management
• Effective Team Building
• Effective Teamwork for the Demanding Workplace
• Essential Management Skills Training
• Essential Managerial Skills Toolkit
• Essential Skills for Professionals
• Forward Planning & Management by Objectives
• How to Start & Establish A New Business
• IELTS Mock Test & Review with Complete Solution Workshop
• IELTS Preparation and Practice
• IELTS Preparation Course
• IELTS Preparatory Course
• IELTS Writing Preparation Course
• Improving Managerial Effectiveness
• Inter-organizational Conflicts and Negotiation
• Interpersonal Skills
• Interpersonal Skills for Professionals
• Leadership Development Plan Workshop
• Leadership Development Workshop
• Leadership for Results
• Learn To Attack TOEFL in 1 Day
• Learn to Crack IELTS in 1 Day
• Learn to Grab IELTS only in 3 hours
• Learning Corporate Culture
• Let’s Get Ready for the Corporate Environment
• Listen for Improved Understanding, Listen to Communicate
• Make an Impact ! Business Grooming & Etiquette
• Management Skills for First Line Leaders
• Managing English Writing Errors
• Managing for Results & The Challenge of Leadership
• Managing Time for Success
• Negotiating to Win
• Office Etiquettes
• Organizational Leadership and Managerial Communication
• Personal Effectiveness
• Personal Excellence through Neuro Linguistic Programming (NLP)
• Prepare Yourself for Interviews & Build Your Resume
• Present Perfect ! Impactful Business Presentation Skills
• Professional Grooming Boot Camp
  (2-Week-Extensive Grooming Program, Mainly for Fresh Graduates)
• Professionalism at Work
• Report Writing Skills
• Role of Corporate Managers
• Secrets of Personal and Interpersonal Leaderships
• Speak in English with Confidence!
• SPEAKRAFT: Effective Communication & The Art of Public Speaking
• Spoken and Written English
• Stress Management
• Teaching Methodology Update and Classroom Management
• The Power of Professional Communication & Telephone Courtesies and Disciplines
• The Power of Professional Judgment & Problem Solving Skills
• The Power of Professionalism, Self Evaluation & Goal Setting
• Time & Task Management
• TOEFL Preparation Aid
• Train the Trainer Course
• Win-Win Negotiation Skills
• Writing for Business
• Written Business Communication
• Written Business Communication Skills
• Written Business Communication Training

• Effective Project Management
• Fundamental Project Management Course
• IT Project Management
• IT Project Management ( Knowledge into action)
• Managing Projects with MS Project Professional and Project Server 2007
• Microsoft Excel for Professional Project Managers
• Microsoft Project 2007 with Case-Studies
• Microsoft Project 2010 – Beginner to Advance
• PMP Exam Preparation Course
• Power Excel for Project Managers
• Practical Project Management
• Practical Six Sigma Project Management with Minitab
• Program Management Training with PgMP Exam Preparation
• Project Appraisal and Management
• Project Cost Management: Estimating, Budgeting and Earned Value Analysis
• Project Earned Value Management using MS Project Professional
• Project Management
• Project Management for Engineers & Technicians
• Project Management Fundamentals, Methodology and Technology
• Project Management Training with PMP Examination Preparation
• Project Management with Primavera 6
• Project Management with PRINCE2 Methodology
• Project Risk Management: Controlling Your Project Uncertainty
• Project Scheduling: Controlling the Project Timeline
• Project Selection Tools and Techniques
• Smart Project Management using Microsoft Project 2010 with Case Studies
• Technical Project Management

• Administration & Logistics Management
• Advance Project Management
• AS/NZS ISO 31000:2009 Risk Management
• Basics of Environment Management System and Green Production
• Be A Powerful Negotiator
• Building Structural Safety Management
• Business Plan Development Workshop
• Business Presentation Skills
• Business Presentation Skills Training
• CBAP Exam Preparation Course
• Cost Reduction & Workplace Organization through 5S
• Crash PMP Exam Prep Course
• Creating the Repeat Customer
• Creating Win-Win Situation to Resolve Customer Conflict
• Creativity and Innovation: Unleash Your Potential
• Crisis Communication through Effective PR
• Customer Care Excellence through Neuro Linguistic Programming (NLP)
• Customer Service Excellence
• Data Analysis & Research
• Data Analysis and Research
• Data Management and Statistical Analysis
• Documentary Filmmaking Course
• Drafting Commercial Contracts
• Effective Communication & Task Management by MS Outlook 2007
• Effective Delegation
• Effective Teaching through LEARN Instructional Model
• Effective Writing Skills by MS Word 2007
• Email at Work
• Emotional Intelligence - The Success Factor at Work
• Employee Engagement
• Enhancing Secretarial and Administrative Skills
• Essential Management Skill for Executive Assistant/Secretary
• Essential Skills for Administrative Support Professionals
• Evening Course: Breaking through English Writing Barriers
• Excellence in Tourism Marketing
• Fire Safety & First Aid Management
• Fire Safety Management
• Front-desk Behaviour and Telephone Etiquettes
• Fundamentals of Stock Markets
• Getting Advanced with PRINCE 2
• GMAT Crash Course
• Good Housekeeping in Hospitality Industry
• Green Marketing for People, Planet and Profit
• How to Be An Outstanding Receptionist
• HSE Risk Management and Accident Investigation
• Leadership Development for Achieving Excellence
• Leadership Development Program
• Leadership Effectiveness
• Leading Change
• Leading Effective Meetings
• Learn to Rock, Mock & Roll the IELTS in 2 days
• Legal Issues for Administrative Professionals
• Management Skills for Administrative Professionals
• Management Skills for the Executive Secretary
• Managers Battleground - Managing Time, Emotions & Stress
• Managing Difficult Clients
• Managing Occupational Health & Safety
• Managing Project Resources using MS Project Professional
• Managing the Teaching & Learning Process
• Microsoft Excel 2007 Professional
  (For Professional and Business Use)
• Microsoft Excel 2007/2010 Macro and VBA Made Easy
• Motivating Employees towards Peak Performance
• Negotiation Skills for Procurement Professionals
• Office Management
• Office Productivity Series: Microsoft Excel
• Operations Management Excellence
• Optimizing Customer Service
• Professional Analysis, Reporting and Presentation: Powered by MS Excel 2007 & PowerPoint 2007
• Professional Courtesies, Communication & Telephone Etiquettes
• Profitably Invest in Stock Market
• Project Risk Management
• Psychometric Profiling / Assessment Workshop
• Public Procurement under Public Procurement Act 2006 and Procedure
• Public Speaking & Presentation Skills
• Quality Customer Care & The Win-Win Approach
• Root Cause Analysis
• Running Business using Excel:
  Purchase and Sales Management
• SAP-CO Course
• SAP-FI Course
• SAP-FI End-User Training
• SAP-MM Professional Consultancy Course
• SAP-Sales & Distribution (SD) Course
• Security & Safety Management Training
• Service for the 21st Century Customers
• Six Sigma Black Belt Certification Course
• Strategic Leadership in Turbulent Times
• Stress, Emotions & Time Management
• Successful Project Management
• Tally for Real Estate Business Management
• Teachers Training: Effective Classroom Management and Lesson Planning
• Team Building and Leadership Development
• Telephone Etiquette & Customer Service
• Telephone Etiquettes – 1st Step to Win the Customer
• The Art & Skill of Managing People Effectively
• The Magic of Winning Life
• The New Features and Functions in Excel 2010 and PowerPoint 2010
• TQM – Ways to Make it Work for YOU
• Training of Trainers(TOT)
• Transformational Leadership
• Upgrading to MS Office 2007: New Features and Interface
• WordPress Workshop: Create your Own Dynamic Blog and Website
• Workplace Behavior: Impression & Stress Management
• Workplace HSE Management